PREVIEW / stock_30min / 2017-12-11

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-12-11.parquet
  size:    1.7 MB
  rows:    83,713
  symbols: 2,959

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
2017-12-11 04:00:00	AAPL	Stock	42.45	42.45	42.45	42.45	800.0
2017-12-11 04:30:00	AAPL	Stock	42.4375	42.4375	42.42	42.42	3200.0
2017-12-11 05:00:00	AAPL	Stock	42.4225	42.4225	42.4225	42.4225	1316.0
2017-12-11 05:30:00	AAPL	Stock	42.45	42.45	42.45	42.45	5652.0
2017-12-11 06:00:00	AAPL	Stock	42.4225	42.4225	42.4225	42.4225	2196.0
2017-12-11 06:30:00	AAPL	Stock	42.3875	42.3875	42.3875	42.3875	2000.0
2017-12-11 07:00:00	AAPL	Stock	42.425	42.425	42.35	42.4	29568.0
2017-12-11 07:30:00	AAPL	Stock	42.3975	42.4675	42.355	42.375	72584.0
2017-12-11 08:00:00	AAPL	Stock	42.425	42.4475	42.3375	42.34	66028.0
2017-12-11 08:30:00	AAPL	Stock	42.3425	42.3925	42.3375	42.355	41304.0
2017-12-11 09:00:00	AAPL	Stock	42.38	42.38	42.26	42.2925	117968.0
2017-12-11 09:30:00	AAPL	Stock	42.2925	42.5455	42.1975	42.46	12566620.0
2017-12-11 10:00:00	AAPL	Stock	42.4575	42.695	42.385	42.6805	9714616.0
2017-12-11 10:30:00	AAPL	Stock	42.6805	43.045	42.6525	42.9675	16170344.0
2017-12-11 11:00:00	AAPL	Stock	42.9688	43.05	42.8925	42.9538	8112740.0
2017-12-11 11:30:00	AAPL	Stock	42.9525	43.0075	42.911	42.9475	4900688.0
2017-12-11 12:00:00	AAPL	Stock	42.9475	43.1175	42.9475	43.11	5230284.0
2017-12-11 12:30:00	AAPL	Stock	43.1123	43.2225	43.1	43.1975	5633164.0
2017-12-11 13:00:00	AAPL	Stock	43.2	43.2175	43.0788	43.085	5016432.0
2017-12-11 13:30:00	AAPL	Stock	43.085	43.11	43.0575	43.08	3855492.0
2017-12-11 14:00:00	AAPL	Stock	43.0825	43.1225	43.02	43.0325	4544152.0
2017-12-11 14:30:00	AAPL	Stock	43.0322	43.1225	43.0262	43.115	3581420.0
2017-12-11 15:00:00	AAPL	Stock	43.1138	43.135	43.0525	43.1012	4646004.0
2017-12-11 15:30:00	AAPL	Stock	43.1	43.185	43.0925	43.165	10534764.0
2017-12-11 16:00:00	AAPL	Stock	43.1675	43.1675	43.1375	43.1675	26881632.0
2017-12-11 16:30:00	AAPL	Stock	43.1675	43.2	43.1675	43.195	3774252.0
2017-12-11 17:00:00	AAPL	Stock	43.17	43.1975	43.17	43.1975	15500.0
2017-12-11 17:30:00	AAPL	Stock	43.1875	43.2	43.1625	43.2	20304.0
2017-12-11 18:00:00	AAPL	Stock	43.195	43.195	43.175	43.1875	8276.0
2017-12-11 18:30:00	AAPL	Stock	43.1875	43.1925	43.155	43.1675	643992.0
2017-12-11 19:00:00	AAPL	Stock	43.155	43.19	43.155	43.175	18048.0
2017-12-11 19:30:00	AAPL	Stock	43.1875	43.1975	43.1725	43.195	36816.0
2017-12-11 04:30:00	MSFT	Stock	84.17	84.17	84.17	84.17	421.0
2017-12-11 05:30:00	MSFT	Stock	84.17	84.17	84.17	84.17	115.0
2017-12-11 07:00:00	MSFT	Stock	84.29	84.3	84.29	84.3	300.0
2017-12-11 07:30:00	MSFT	Stock	84.35	84.45	84.35	84.35	5504.0
2017-12-11 08:00:00	MSFT	Stock	84.43	84.43	84.15	84.2	10801.0
2017-12-11 08:30:00	MSFT	Stock	84.1	84.34	84.09	84.26	2838.0
2017-12-11 09:00:00	MSFT	Stock	84.29	84.3	84.15	84.29	5938.0
2017-12-11 09:30:00	MSFT	Stock	84.29	84.61	84.12	84.6	2281336.0
2017-12-11 10:00:00	MSFT	Stock	84.6	84.7	84.435	84.44	1036493.0
2017-12-11 10:30:00	MSFT	Stock	84.44	84.58	84.424	84.525	917452.0
2017-12-11 11:00:00	MSFT	Stock	84.53	84.67	84.48	84.66	600834.0
2017-12-11 11:30:00	MSFT	Stock	84.66	84.87	84.635	84.836	655539.0
2017-12-11 12:00:00	MSFT	Stock	84.84	84.99	84.82	84.98	794468.0
2017-12-11 12:30:00	MSFT	Stock	84.99	85.22	84.982	85.2	1120973.0
2017-12-11 13:00:00	MSFT	Stock	85.204	85.29	85.055	85.08	761870.0
2017-12-11 13:30:00	MSFT	Stock	85.07	85.37	85.07	85.33	1032352.0
2017-12-11 14:00:00	MSFT	Stock	85.33	85.33	85.138	85.16	656458.0
2017-12-11 14:30:00	MSFT	Stock	85.154	85.16	84.94	85.035	1024869.0

> showing 50 of 83,713 rows — these rows as CSV

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