PREVIEW / stock_30min / 2016-07-06

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-07-06.parquet
  size:    1.6 MB
  rows:    81,545
  symbols: 3,252

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
2016-07-06 04:00:00	AAPL	Stock	23.755	23.755	23.7175	23.7175	4800.0
2016-07-06 04:30:00	AAPL	Stock	23.7175	23.7175	23.6925	23.6925	3032.0
2016-07-06 05:00:00	AAPL	Stock	23.68	23.68	23.6675	23.6675	42168.0
2016-07-06 05:30:00	AAPL	Stock	23.6425	23.6425	23.6425	23.6425	400.0
2016-07-06 06:00:00	AAPL	Stock	23.67	23.67	23.6175	23.6175	37072.0
2016-07-06 06:30:00	AAPL	Stock	23.6175	23.6275	23.6175	23.6275	5868.0
2016-07-06 07:00:00	AAPL	Stock	23.625	23.675	23.6225	23.6625	49836.0
2016-07-06 07:30:00	AAPL	Stock	23.66	23.6625	23.65	23.6625	20728.0
2016-07-06 08:00:00	AAPL	Stock	23.645	23.68	23.6175	23.6225	159456.0
2016-07-06 08:30:00	AAPL	Stock	23.62	23.65	23.6125	23.65	149796.0
2016-07-06 09:00:00	AAPL	Stock	23.65	23.6675	23.6375	23.65	66688.0
2016-07-06 09:30:00	AAPL	Stock	23.65	23.775	23.625	23.7325	16299868.0
2016-07-06 10:00:00	AAPL	Stock	23.73	23.85	23.6525	23.655	12371248.0
2016-07-06 10:30:00	AAPL	Stock	23.6535	23.7025	23.5925	23.6962	12820384.0
2016-07-06 11:00:00	AAPL	Stock	23.6975	23.825	23.695	23.7925	10986596.0
2016-07-06 11:30:00	AAPL	Stock	23.7925	23.814	23.7725	23.7975	5473172.0
2016-07-06 12:00:00	AAPL	Stock	23.8	23.915	23.7985	23.89	7304740.0
2016-07-06 12:30:00	AAPL	Stock	23.89	23.9	23.8375	23.8688	4587448.0
2016-07-06 13:00:00	AAPL	Stock	23.87	23.905	23.8225	23.8375	4138880.0
2016-07-06 13:30:00	AAPL	Stock	23.8375	23.8538	23.8125	23.825	3950172.0
2016-07-06 14:00:00	AAPL	Stock	23.8275	23.8375	23.755	23.795	6741872.0
2016-07-06 14:30:00	AAPL	Stock	23.7968	23.8862	23.7908	23.8762	5886076.0
2016-07-06 15:00:00	AAPL	Stock	23.8775	23.8775	23.8075	23.826	5441892.0
2016-07-06 15:30:00	AAPL	Stock	23.825	23.885	23.823	23.8825	13529068.0
2016-07-06 16:00:00	AAPL	Stock	23.8825	23.8975	23.7878	23.87	5160960.0
2016-07-06 16:30:00	AAPL	Stock	23.87	23.8825	23.865	23.865	318116.0
2016-07-06 17:00:00	AAPL	Stock	23.875	23.875	23.8575	23.8625	6360.0
2016-07-06 17:30:00	AAPL	Stock	23.865	23.8825	23.865	23.8825	3204.0
2016-07-06 18:00:00	AAPL	Stock	23.8625	23.8675	23.8625	23.8675	13204.0
2016-07-06 18:30:00	AAPL	Stock	23.875	23.875	23.8675	23.875	13100.0
2016-07-06 19:00:00	AAPL	Stock	23.875	23.875	23.8675	23.8675	14752.0
2016-07-06 19:30:00	AAPL	Stock	23.8675	23.875	23.865	23.875	12988.0
2016-07-06 05:00:00	MSFT	Stock	51.0	51.0	51.0	51.0	1300.0
2016-07-06 05:30:00	MSFT	Stock	50.9	50.9	50.9	50.9	400.0
2016-07-06 07:00:00	MSFT	Stock	50.84	50.84	50.84	50.84	435.0
2016-07-06 07:30:00	MSFT	Stock	50.85	50.85	50.85	50.85	100.0
2016-07-06 08:00:00	MSFT	Stock	50.95	50.98	50.95	50.98	334.0
2016-07-06 08:30:00	MSFT	Stock	50.86	50.86	50.86	50.86	200.0
2016-07-06 09:00:00	MSFT	Stock	50.97	50.98	50.78	50.78	12564.0
2016-07-06 09:30:00	MSFT	Stock	50.78	50.82	50.39	50.49	3345155.0
2016-07-06 10:00:00	MSFT	Stock	50.49	50.82	50.485	50.495	2546765.0
2016-07-06 10:30:00	MSFT	Stock	50.5	50.81	50.46	50.805	1854517.0
2016-07-06 11:00:00	MSFT	Stock	50.81	51.11	50.73	51.035	2523900.0
2016-07-06 11:30:00	MSFT	Stock	51.03	51.167	51.01	51.14	1756240.0
2016-07-06 12:00:00	MSFT	Stock	51.14	51.36	51.14	51.325	1684228.0
2016-07-06 12:30:00	MSFT	Stock	51.33	51.37	51.25	51.365	790947.0
2016-07-06 13:00:00	MSFT	Stock	51.36	51.37	51.22	51.285	1046847.0
2016-07-06 13:30:00	MSFT	Stock	51.29	51.33	51.22	51.27	888663.0
2016-07-06 14:00:00	MSFT	Stock	51.28	51.37	51.185	51.31	1062341.0
2016-07-06 14:30:00	MSFT	Stock	51.3	51.54	51.29	51.44	1450440.0

> showing 50 of 81,545 rows — these rows as CSV

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