PREVIEW / stock_30min / 2011-12-16

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-12-16.parquet
  size:    1.5 MB
  rows:    77,881
  symbols: 3,542

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-12-16 04:00:00	AAPL	Stock	13.5804	13.5804	13.5804	13.5804	2800.0
2011-12-16 05:00:00	AAPL	Stock	13.6225	13.6225	13.6225	13.6225	2800.0
2011-12-16 07:00:00	AAPL	Stock	13.5982	13.5982	13.5982	13.5982	14000.0
2011-12-16 07:30:00	AAPL	Stock	13.6036	13.6179	13.5964	13.5964	98420.0
2011-12-16 08:00:00	AAPL	Stock	13.6071	13.6071	13.5768	13.6071	364588.0
2011-12-16 08:30:00	AAPL	Stock	13.6	13.6	13.5804	13.5857	163604.0
2011-12-16 09:00:00	AAPL	Stock	13.5929	13.6071	13.5714	13.5921	1985816.0
2011-12-16 09:30:00	AAPL	Stock	13.59	13.6211	13.5561	13.5889	84506744.0
2011-12-16 10:00:00	AAPL	Stock	13.5918	13.7196	13.5714	13.6771	50850632.0
2011-12-16 10:30:00	AAPL	Stock	13.6757	13.6954	13.6629	13.6786	19382272.0
2011-12-16 11:00:00	AAPL	Stock	13.6761	13.68	13.6557	13.6736	17184188.0
2011-12-16 11:30:00	AAPL	Stock	13.6722	13.674	13.6004	13.6032	24443216.0
2011-12-16 12:00:00	AAPL	Stock	13.6029	13.6189	13.5811	13.6011	15306228.0
2011-12-16 12:30:00	AAPL	Stock	13.6029	13.6061	13.5618	13.5921	27770456.0
2011-12-16 13:00:00	AAPL	Stock	13.593	13.6143	13.5871	13.61	13854512.0
2011-12-16 13:30:00	AAPL	Stock	13.6095	13.6139	13.5864	13.5893	10292940.0
2011-12-16 14:00:00	AAPL	Stock	13.5921	13.5979	13.5664	13.5675	10736992.0
2011-12-16 14:30:00	AAPL	Stock	13.5682	13.5961	13.5671	13.5825	13416536.0
2011-12-16 15:00:00	AAPL	Stock	13.5836	13.5918	13.5721	13.5811	13807976.0
2011-12-16 15:30:00	AAPL	Stock	13.5811	13.5964	13.5714	13.5961	37878904.0
2011-12-16 16:00:00	AAPL	Stock	13.5918	13.6218	13.5336	13.6078	49460572.0
2011-12-16 16:30:00	AAPL	Stock	13.6078	13.6177	13.5814	13.6078	5417608.0
2011-12-16 17:00:00	AAPL	Stock	13.6018	13.6143	13.6018	13.6079	6598340.0
2011-12-16 17:30:00	AAPL	Stock	13.6121	13.6432	13.6071	13.6321	306068.0
2011-12-16 18:00:00	AAPL	Stock	13.6079	13.6079	13.6079	13.6079	2800.0
2011-12-16 18:30:00	AAPL	Stock	13.6375	13.6382	13.6268	13.6268	36120.0
2011-12-16 19:00:00	AAPL	Stock	13.6214	13.6339	13.615	13.6339	20636.0
2011-12-16 19:30:00	AAPL	Stock	13.6321	13.6371	13.6321	13.6371	46676.0
2011-12-16 07:30:00	MSFT	Stock	25.73	25.73	25.73	25.73	400.0
2011-12-16 08:00:00	MSFT	Stock	25.66	25.81	25.66	25.81	10736.0
2011-12-16 08:30:00	MSFT	Stock	25.78	25.78	25.71	25.71	5600.0
2011-12-16 09:00:00	MSFT	Stock	25.7	25.78	25.66	25.71	211841.0
2011-12-16 09:30:00	MSFT	Stock	25.67	25.94	25.63	25.93	21385374.0
2011-12-16 10:00:00	MSFT	Stock	25.93	26.1	25.894	26.09	6399179.0
2011-12-16 10:30:00	MSFT	Stock	26.09	26.17	26.08	26.1	5523636.0
2011-12-16 11:00:00	MSFT	Stock	26.108	26.14	26.08	26.105	3552148.0
2011-12-16 11:30:00	MSFT	Stock	26.11	26.12	25.9	25.93	5339292.0
2011-12-16 12:00:00	MSFT	Stock	25.93	25.99	25.85	25.96	3314561.0
2011-12-16 12:30:00	MSFT	Stock	25.95	25.98	25.85	25.95	4642378.0
2011-12-16 13:00:00	MSFT	Stock	25.95	26.069	25.931	25.995	3921663.0
2011-12-16 13:30:00	MSFT	Stock	26.0	26.08	25.97	25.985	3471835.0
2011-12-16 14:00:00	MSFT	Stock	25.99	26.02	25.93	25.93	2408643.0
2011-12-16 14:30:00	MSFT	Stock	25.935	26.01	25.925	25.944	2080237.0
2011-12-16 15:00:00	MSFT	Stock	25.94	26.01	25.93	25.93	3344645.0
2011-12-16 15:30:00	MSFT	Stock	25.93	26.03	25.9	25.98	10472518.0
2011-12-16 16:00:00	MSFT	Stock	25.975	26.04	25.56	25.998	11834733.0
2011-12-16 16:30:00	MSFT	Stock	25.998	26.1	25.85	25.999	3474288.0
2011-12-16 17:00:00	MSFT	Stock	26.0	26.03	25.98	26.03	1836635.0
2011-12-16 17:30:00	MSFT	Stock	25.98	25.98	25.98	25.98	1935.0
2011-12-16 18:00:00	MSFT	Stock	26.0	26.0	25.98	25.98	134200.0

> showing 50 of 77,881 rows — these rows as CSV

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