PREVIEW / stock_30min / 2011-04-13

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-04-13.parquet
  size:    1.4 MB
  rows:    76,467
  symbols: 3,528

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-13 04:30:00	AAPL	Stock	11.9236	11.9236	11.9236	11.9236	2800.0
2011-04-13 05:00:00	AAPL	Stock	11.9236	11.95	11.9236	11.9418	16800.0
2011-04-13 05:30:00	AAPL	Stock	11.9464	11.9464	11.9464	11.9464	2800.0
2011-04-13 06:00:00	AAPL	Stock	11.9682	11.9729	11.9661	11.9729	14000.0
2011-04-13 06:30:00	AAPL	Stock	11.9764	11.9764	11.9764	11.9764	2800.0
2011-04-13 07:00:00	AAPL	Stock	11.9696	11.9775	11.9479	11.9696	409164.0
2011-04-13 07:30:00	AAPL	Stock	11.9711	11.9854	11.9614	11.9854	501536.0
2011-04-13 08:00:00	AAPL	Stock	11.9807	11.9875	11.9643	11.9821	953204.0
2011-04-13 08:30:00	AAPL	Stock	11.9821	11.9893	11.9646	11.9657	928060.0
2011-04-13 09:00:00	AAPL	Stock	11.9725	11.9725	11.8702	11.9664	1660484.0
2011-04-13 09:30:00	AAPL	Stock	11.9664	11.9664	11.8839	11.8979	51852752.0
2011-04-13 10:00:00	AAPL	Stock	11.8989	11.9221	11.8757	11.9132	31526208.0
2011-04-13 10:30:00	AAPL	Stock	11.9139	11.9714	11.9093	11.9564	35189168.0
2011-04-13 11:00:00	AAPL	Stock	11.9568	11.9643	11.9257	11.935	21370188.0
2011-04-13 11:30:00	AAPL	Stock	11.9329	11.9404	11.9021	11.9121	17977876.0
2011-04-13 12:00:00	AAPL	Stock	11.9126	11.9464	11.9107	11.9393	14150024.0
2011-04-13 12:30:00	AAPL	Stock	11.9396	11.9396	11.8804	11.8973	21366520.0
2011-04-13 13:00:00	AAPL	Stock	11.8946	11.9136	11.8775	11.8982	14353556.0
2011-04-13 13:30:00	AAPL	Stock	11.8986	11.9154	11.8796	11.8957	12192348.0
2011-04-13 14:00:00	AAPL	Stock	11.8957	11.9361	11.8857	11.9343	13665624.0
2011-04-13 14:30:00	AAPL	Stock	11.9361	11.9611	11.9204	11.9514	20638408.0
2011-04-13 15:00:00	AAPL	Stock	11.9529	11.9771	11.9461	11.9611	22118824.0
2011-04-13 15:30:00	AAPL	Stock	11.9614	12.005	11.9536	12.0031	42630336.0
2011-04-13 16:00:00	AAPL	Stock	12.0032	12.0352	11.8765	12.0018	7653940.0
2011-04-13 16:30:00	AAPL	Stock	12.0	12.0	11.9625	11.9982	521892.0
2011-04-13 17:00:00	AAPL	Stock	11.9979	12.0032	11.9914	11.9929	5407416.0
2011-04-13 17:30:00	AAPL	Stock	11.9914	11.9964	11.9914	11.9929	79996.0
2011-04-13 18:00:00	AAPL	Stock	11.9961	12.0046	11.9957	12.0018	198632.0
2011-04-13 18:30:00	AAPL	Stock	12.0021	12.0021	11.9964	11.9964	42000.0
2011-04-13 19:00:00	AAPL	Stock	11.9954	11.9982	11.9893	11.9957	79800.0
2011-04-13 19:30:00	AAPL	Stock	11.9907	11.9929	11.9786	11.9875	96152.0
2011-04-13 07:00:00	MSFT	Stock	25.84	25.84	25.78	25.82	7509.0
2011-04-13 07:30:00	MSFT	Stock	25.79	25.79	25.75	25.75	4056.0
2011-04-13 08:00:00	MSFT	Stock	25.72	25.79	25.64	25.76	20225.0
2011-04-13 08:30:00	MSFT	Stock	25.75	25.76	25.73	25.75	2900.0
2011-04-13 09:00:00	MSFT	Stock	25.75	25.75	25.6	25.67	124823.0
2011-04-13 09:30:00	MSFT	Stock	25.67	25.87	25.62	25.82	4555659.0
2011-04-13 10:00:00	MSFT	Stock	25.82	25.85	25.76	25.82	2366327.0
2011-04-13 10:30:00	MSFT	Stock	25.82	25.86	25.75	25.825	3335179.0
2011-04-13 11:00:00	MSFT	Stock	25.83	25.83	25.73	25.755	1478257.0
2011-04-13 11:30:00	MSFT	Stock	25.75	25.76	25.65	25.65	1650967.0
2011-04-13 12:00:00	MSFT	Stock	25.66	25.69	25.635	25.675	1359163.0
2011-04-13 12:30:00	MSFT	Stock	25.674	25.68	25.56	25.64	2047313.0
2011-04-13 13:00:00	MSFT	Stock	25.65	25.73	25.64	25.665	1280301.0
2011-04-13 13:30:00	MSFT	Stock	25.665	25.7	25.62	25.63	1259565.0
2011-04-13 14:00:00	MSFT	Stock	25.62	25.72	25.62	25.71	1544377.0
2011-04-13 14:30:00	MSFT	Stock	25.7	25.77	25.7	25.75	1513380.0
2011-04-13 15:00:00	MSFT	Stock	25.758	25.81	25.74	25.775	2769144.0
2011-04-13 15:30:00	MSFT	Stock	25.77	25.8	25.62	25.62	5914973.0
2011-04-13 16:00:00	MSFT	Stock	25.63	25.836	25.58	25.59	920143.0

> showing 50 of 76,467 rows — these rows as CSV

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