PREVIEW / stock_30min / 2011-04-05

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-04-05.parquet
  size:    1.4 MB
  rows:    75,037
  symbols: 3,545

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2011-04-05 04:00:00	AAPL	Stock	11.9786	11.9786	11.7679	11.8036	126896.0
2011-04-05 04:30:00	AAPL	Stock	11.8214	11.8514	11.8214	11.8393	125468.0
2011-04-05 05:00:00	AAPL	Stock	11.8214	11.8529	11.8179	11.8179	131908.0
2011-04-05 05:30:00	AAPL	Stock	11.8146	11.8271	11.8143	11.825	60872.0
2011-04-05 06:00:00	AAPL	Stock	11.8268	11.8304	11.7857	11.7857	433384.0
2011-04-05 06:30:00	AAPL	Stock	11.7857	11.8571	11.7857	11.8571	263060.0
2011-04-05 07:00:00	AAPL	Stock	11.8868	12.0179	11.885	11.9732	2347548.0
2011-04-05 07:30:00	AAPL	Stock	11.975	12.0714	11.9732	12.0357	2532348.0
2011-04-05 08:00:00	AAPL	Stock	12.0357	12.0536	11.9339	12.0189	4932732.0
2011-04-05 08:30:00	AAPL	Stock	12.0189	12.025	11.9918	12.0232	4210920.0
2011-04-05 09:00:00	AAPL	Stock	12.02	12.0768	12.0	12.0357	5334196.0
2011-04-05 09:30:00	AAPL	Stock	12.0354	12.1136	12.0	12.0786	102194792.0
2011-04-05 10:00:00	AAPL	Stock	12.0768	12.1321	12.0582	12.1257	52926944.0
2011-04-05 10:30:00	AAPL	Stock	12.1257	12.2011	12.1139	12.1786	51702952.0
2011-04-05 11:00:00	AAPL	Stock	12.1786	12.1894	12.1364	12.1384	27157536.0
2011-04-05 11:30:00	AAPL	Stock	12.1393	12.1561	12.1304	12.1507	21388080.0
2011-04-05 12:00:00	AAPL	Stock	12.1507	12.2232	12.1496	12.1896	28194908.0
2011-04-05 12:30:00	AAPL	Stock	12.1899	12.2107	12.1711	12.1818	16976876.0
2011-04-05 13:00:00	AAPL	Stock	12.1823	12.1925	12.1646	12.1868	13364960.0
2011-04-05 13:30:00	AAPL	Stock	12.1861	12.2086	12.1834	12.1941	15438892.0
2011-04-05 14:00:00	AAPL	Stock	12.1939	12.2018	12.1607	12.1607	16188088.0
2011-04-05 14:30:00	AAPL	Stock	12.1607	12.1675	12.0907	12.1118	35604268.0
2011-04-05 15:00:00	AAPL	Stock	12.1114	12.1179	12.0571	12.0807	30807616.0
2011-04-05 15:30:00	AAPL	Stock	12.0807	12.1036	12.0664	12.0961	35056224.0
2011-04-05 16:00:00	AAPL	Stock	12.1021	12.1199	12.0839	12.095	7838460.0
2011-04-05 16:30:00	AAPL	Stock	12.0893	12.1309	12.0284	12.0925	300300.0
2011-04-05 17:00:00	AAPL	Stock	12.0918	12.0918	12.0875	12.0882	47208.0
2011-04-05 17:30:00	AAPL	Stock	12.0918	12.0929	12.0911	12.0911	38948.0
2011-04-05 18:00:00	AAPL	Stock	12.0925	12.1071	12.0925	12.1068	195244.0
2011-04-05 18:30:00	AAPL	Stock	12.1039	12.1057	12.0986	12.0986	27048.0
2011-04-05 19:00:00	AAPL	Stock	12.1036	12.1043	12.1004	12.1018	51744.0
2011-04-05 19:30:00	AAPL	Stock	12.1018	12.1018	12.0957	12.0996	31640.0
2011-04-05 04:00:00	MSFT	Stock	25.76	25.89	25.72	25.88	29750.0
2011-04-05 04:30:00	MSFT	Stock	25.83	25.89	25.83	25.89	11100.0
2011-04-05 05:00:00	MSFT	Stock	25.89	25.91	25.89	25.91	25550.0
2011-04-05 05:30:00	MSFT	Stock	25.86	26.0	25.86	25.95	5083.0
2011-04-05 06:00:00	MSFT	Stock	26.0	26.2	25.91	26.15	60071.0
2011-04-05 06:30:00	MSFT	Stock	26.15	26.24	26.15	26.2	49850.0
2011-04-05 07:00:00	MSFT	Stock	26.2	26.27	26.06	26.1	207190.0
2011-04-05 07:30:00	MSFT	Stock	26.1	26.15	25.91	25.95	225631.0
2011-04-05 08:00:00	MSFT	Stock	25.99	26.0	25.83	25.95	790432.0
2011-04-05 08:30:00	MSFT	Stock	25.95	25.99	25.91	25.94	362143.0
2011-04-05 09:00:00	MSFT	Stock	25.95	25.95	25.8	25.82	466314.0
2011-04-05 09:30:00	MSFT	Stock	25.82	26.18	25.77	25.88	15938201.0
2011-04-05 10:00:00	MSFT	Stock	25.88	25.96	25.81	25.869	6502272.0
2011-04-05 10:30:00	MSFT	Stock	25.87	25.96	25.75	25.94	7523415.0
2011-04-05 11:00:00	MSFT	Stock	25.94	26.07	25.94	26.05	6323722.0
2011-04-05 11:30:00	MSFT	Stock	26.055	26.06	25.98	26.0	4944398.0
2011-04-05 12:00:00	MSFT	Stock	25.998	26.0	25.93	25.95	2079710.0
2011-04-05 12:30:00	MSFT	Stock	25.945	25.99	25.89	25.99	2499990.0

> showing 50 of 75,037 rows — these rows as CSV

> unlock the full archive -- $79 one-time