US Insider Trading (Old) - TrimTabs

southdakotascrawnyData Management

Nov 29, 2012 (4 years and 6 months ago)

328 views

TrimTabs
IT Documentation on Servers & SQL Databases


1.
Servers

1.1.

FreeBSD Server



Old Retired Server



General Information

Server Name

FreeBSD Server

Location

In Sausalito Office

Local IP Address

N/A ( retired)

Specification

CPU: Single Intel Pentium 4 3.0
GHz

RAM: 2 GB

HardDisk: 50 GB IDE

DVD ROM

Global Hostname

N/A

O/S

FreeBSD

5.4

Active User and Password

diggler:uptime5

Root/Admin Password

biderman81

Software Loaded

MySQL 3.23.59

Perl 5.8.6

PHP 5.2.1

Apache 2.0.58

phpMyAdmin 2.10.0.2

Comment

This server is retired.

All databases are backed up in Sonic ftp server




Database housed

Database Name

Explanation

DBMS

Comment


US Insider Trading




DTS Tax DB




1.2.

Fedora #1



General Information

Server Name

Fedora #1

Location

In Sausalito Office

Local IP Address

10.1.10.20

Global Hostname

trimtabs.dnsalias.net

db.trimtabs.com

Specification

CPU: Single Intel Pentium 4 2.26 GHz

RAM: 512 MB

Hard Disk: 40 GB IDE

CD
-
RW Drive

O/S

Fedora 6

Active User and Password

diggler:uptime5

Root/Admin Password

python

Software Loaded

jetty
-
6.1.11

java 1.6.0_16

apache
-
tomcat
-
6.0.18

MySQL 5.0.37

Perl 5.8.6

PHP 5.2.2

Apache http Server 2.2.4

phpMyAdmin 2.10.0.2

PostgreSQL 8.3.3

pure
-
ftpd 1.0.21




Database housed



all databases are old and no longer used

Database
Name

Explanation

DBMS

Comment

canada_insider

Canadian Liquidity

M
ysql

Old version

etfdb

US ETF Database

M
ysql

Old Version

eurofunddb


M
ysql


eurotest


M
ysql


form4insider


M
ysql


global_etfdb

Global ETFs

M
ysql

No longer used

mfdb

US Mutual Funds

M
ysql

Old version

mysql


M
ysql


trimtabs


M
ysql


vuln


M
ysql



Foreclosures.com DB

Pgsql

No longer maintained


1.3.

Fedora #2



General Information

Server Name

Fedora #2

Location

In Sausalito Office

Local IP Address

10.1.10.2
4

Global Hostname

trimtabs.dnsalias.net

db.trimtabs.com

Specification

CPU: Single
Intel(R) Pentium(R) 4 CPU 3.00GHz

RAM:
3 GB

Hard Disk:
160

GB IDE

DVD ROM

O/S

Fedora 7

Active User and Password

diggler:uptime5

Root/Admin Password

P
ython

Software Loaded

jetty
-
6.1.
11

java 1.6.0_14

apache
-
tomcat
-
6.0.18

MySQL
5.0.45

Perl 5.8.8

PHP 5.2.5

Apache http Server 2.2.4

phpMyAdmin 2.10.0.2

PostgreSQL 8.3.3

pure
-
ftpd 1.0.21




Database housed

Database Name

Explanation

DBMS

Comment

form4insider

Old US Insider Trading

M
ysql


index_db


M
ysql


jasperserver


M
ysql


liquidity

L1 Liquidity Float DB

M
ysql


stock_db

Stock Price and Volume

M
ysql


sugarcrm


M
ysql


tax_db

Tax Witholdings

M
ysql


us_insider_trading

US Insider Trading DB

mysql


french_l1

French Insider Trading

psql


stock_db


psql


stock_level_backtesting


psql



1.4
Fedora #4



General Information

Server Name

Fedora #4

Location

In Sausalito office

Local IP Address

10.1.10.80

Global Hostname

Trimtabs.dnsalias.net; db.trimtabs.com

Specification

CPU: Intel(R)
Pentium(R) 4 CPU 3.00GHz

RAM: 2GB

Hard Drive 160GB

O/S

Fedora 9

Active User and Password

diggler:uptime5

Root/Admin Password

P
ython

Software Loaded

apache
-
tomcat
-
6.0.20

jetty
-
6.1.12

j
ava 1.6.0_16

perl

v5.10.0

PHP 5.2.9

PostgreSQL

8.3.6

mysql
5.1.30




Database housed

Database Name

Explanation

DBMS

Comment

canada_insider

Unused Version

mysql


etfdb

Non
-
olap Legacy

mysql


jasperserver


mysql


mfdb

Non
-
olap Legacy

mysql


sugarcrm


mysql


A
qldb


psql


olap_funds

OLD VERSION OF ETF/MF

psql


short_interest

Short Interest Data

psql



1.5

TrimTabs Window Server #1



General Information

Server Name

TrimTabs Window Server #1

Location

In Sausalito office

Local IP Address

10.1.10.
1
4

Global Hostname

db.trimtabs.com

Specification

CPU: Intel(R)
Xeon 2.4

Ghz (2

CPUs)

RAM: 2GB

Hard Drive
70
GB

O/S

Microsoft Windows Server 2003 Enterprise Edition

Active User and Password

tresearc:b1derman

conradgann:ttam

vincent.deluard:deluard

knielsen:n9e01uCh

lbai:sanfrancisco

mpiken:vegas06

dsantschi:

hdonavon:whatever

mschnapp:

sanglee:secret

Root/Admin Password

Administrator:biderman81

Software Loaded

Microsoft Office 2007 Enterprise Edition

WinRATS 6.35

F
-
Secure Antivirus for Windows Servers 7

PC Tools Firewall Plus

WinRAR 3.62

Adobe Reader 9.1.2

WinSCP 4.0.2





Database housed

Database Name

Explanation

DBMS

Comment

AQLDB Access




DailyLog Excel




Master_XXX Excel




LTT History





1.4.

GoGrid #1



General Information

Server Name

Fedora #4

Location

Go Grid
Cloud
Server hosting

Local IP Address

N/A

Global Hostname

db2.trimtabs.com

Specification

CPU
: Intel(R) Xeon(R) CPU E5450 @ 3.00GHz

RAM: 2GB

Hard Drive
128GB

O/S

CentOS 5.2

Active User and Password

root:
8b68adc3

Root/Admin Password

root:
8b68adc3

Software Loaded

apache
-
tomcat
-
6.0.20

j
ava 1.6.0_16

perl

v5.
8.8

PostgreSQL

8.3.6

MySQL 5.1.40




Database housed

Database Name

Explanation

DBMS

Comment

adviser_holdings


psql


A
qldb


psql


Hk_insider_trading


MySQL


stock_db


P
sql


craigslist


MySQL


hk_insider_trading

1.6 CentOS #1



General Information

Server Name

CentOS #1

Location

In Sausalito office

Local IP Address

10.1.10.17

Global Hostname

Trimtabs.dnsalias.net; db.trimtabs.com

Specification

CPU:
AMD Athlon(tm) 64 Processor 3800+

RAM: 2GB

Hard Drive 12
0GB

O/S

CentOS 5.2

Active User and Password

diggler:uptime5
; root:ttresearch

Root/Admin Password

Python

Software Loaded

M
onetDB
-
5.18.1

MySQL 5.1.40

Java 1.6.0_21

Perl 5.8.8

PHP 5.2.13

PostgreSQL 8.4.2

Apache HTTP Server 2.2.15

Apache Tomcat 6.0.20




Database housed

Database Name

Explanation

DBMS

Comment

mfdb

OLAP ETFs/Mutual Funds

monetdb


k
r_insider_trading

Korean Insider Trading

monetdb


c
n_insider_trading

Mainland China Insider
Trading

monetdb



s
hort_interest

MonetDB short interest

monetdb





2.
Databases

2.1.

US
Mutual Funds Database




General Information

US Mutual Funds Database

Server Location

Fedora #1
,
Fedora #4

DBMS

MySQL

D
2
atabase
name

m
fdb




Tables

Table name

usage

allegiant_ticker_map


big_four


big_four_crosstab_table


categories


daily


delaware_ticker_map


dws_ticker_map


evergreen_daily_table


evergreen_ticker_map


ge_ticker_map


gsam_daily_table


gsam_ticker_map


hbk_table


john_hancock_ticker_map


ms_crosstab_table


nuveen_ticker_map


principal_ticker_map


sanny_weights


schroders


uam_ticker_map





Stored Procedure



View



Related Source page and Importing
scripts




2.2.

US ETFs DB




General Information

US Mutual Funds Database

Server Location

Fedora #1
,
Fedora #4

DBMS

MySQL

Database name

etfdb




Tables

Table name

usage

aci_table


categories


daily


dtcc


etf_families


leveraged_etfs


ticker_list_from_user

To maintain ticker list for
easy retrieval of multiple
tickers.




Stored Procedure

Procedure Name

Description

Parameter

etf_flows_by_ticker_proc

Create ETF csv file for specific
ticker

Ticker
name

etf_flows_by_ticker_list_proc

Create ETF csv files for list of
tickers specified by list name.

Ticker List Name (should be
specified in
ticker_list_from_user table)





etf_flows_by_ticker_list_proc



View



Related Source page and Importing scripts


2.3.

European Mutual Funds DB




General Information

US Mutual Funds Database

Server Location

Fedora #1

DBMS

MySQL

Database name

eurotest




Tables

Table name

usage

euro_catmaster


euro_daily


exchange_rates


morningstar_translation


ms_categories





Stored Procedure



View



Related Source page and Importing scripts


2.4.

Canadian Liquidity DB



General Information

US Mutual Funds Database

Server Location

Fedora #
3

DBMS

MySQL

Database name

canada_insider




Tables

Table name

usage

S
ectormap


T
ransactions





Stored Procedure



View



Related Source page and Importing scripts

2.5.

US Insider Trading
(Old)



General Information

US Mutual Funds Database

Server Location

Free BSD Server(retired)

DBMS


Database name





Tables

Table name

usage

S
ectormap


T
ransactions





Stored Procedure



View



Related Source page and Importing scripts

2.6.

US Insider Trading

(Old)



General Information

US Mutual Funds Database

Server Location

Free BSD Server(retired)
, Fedora #2

DBMS

MySql

Database name

form4insider

Comment

Back up database at
sonic ftp Server




Tables

Table name

usage

S
ectormap


T
ransactions





Stored Procedure



View



Related Source page and Importing scripts

2.7.

Liquidity Float



General Information

US Mutual Funds Database

Server Location

Fedora #2

DBMS

MySQL

Database name

trimtabs.dts

Comment

Back up database at sonic ftp Server




Tables

Table name

usage

averages_change_tPlusOne


date_ticker_last


price_and_volume





Stored Procedure



View



Related Source page and Importing scripts


3.
Intranet
Website
Menu

3.1.

Mutual Funds

3.1.1.

Daily

Upload



Related pages

Name

Programming Language

Deployed Servers

File Name












Related database and tables




Related sources page



3.1.2.

Database Examiner

3.1.3.

Big Four Query

3.1.4.

Morningstar Query

3.1.5.

Data By Date

3.1.6.

Data By Ticker

3.1.7.

Weighted Flows

3.1.8.

Weighted Flows by
Category

3.1.9.

Formatted Weighted Flows By Category

3.1.10.

Mutual Funds Bar Chart Query