PREVIEW / stock_30min / 2017-01-11

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-01-11.parquet
  size:    1.6 MB
  rows:    81,012
  symbols: 3,128

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-01-11 04:00:00	AAPL	Stock	29.7775	29.7775	29.7175	29.7175	2000.0
2017-01-11 06:30:00	AAPL	Stock	29.695	29.7375	29.695	29.7375	4284.0
2017-01-11 07:00:00	AAPL	Stock	29.7125	29.7225	29.7125	29.7225	5704.0
2017-01-11 07:30:00	AAPL	Stock	29.72	29.72	29.6875	29.6875	59872.0
2017-01-11 08:00:00	AAPL	Stock	29.715	29.745	29.6875	29.725	95336.0
2017-01-11 08:30:00	AAPL	Stock	29.725	29.725	29.7	29.705	28608.0
2017-01-11 09:00:00	AAPL	Stock	29.7025	29.73	29.655	29.6625	151832.0
2017-01-11 09:30:00	AAPL	Stock	29.68	29.84	29.6575	29.7888	14623200.0
2017-01-11 10:00:00	AAPL	Stock	29.7882	29.79	29.7075	29.745	5655464.0
2017-01-11 10:30:00	AAPL	Stock	29.745	29.78	29.73	29.7425	4418604.0
2017-01-11 11:00:00	AAPL	Stock	29.7425	29.7875	29.69	29.7075	5295472.0
2017-01-11 11:30:00	AAPL	Stock	29.7075	29.77	29.6525	29.7638	6473788.0
2017-01-11 12:00:00	AAPL	Stock	29.765	29.7725	29.66	29.7425	5405160.0
2017-01-11 12:30:00	AAPL	Stock	29.745	29.7525	29.6875	29.74	3661864.0
2017-01-11 13:00:00	AAPL	Stock	29.7375	29.7425	29.654	29.665	4791632.0
2017-01-11 13:30:00	AAPL	Stock	29.665	29.75	29.65	29.73	4587080.0
2017-01-11 14:00:00	AAPL	Stock	29.7318	29.82	29.7275	29.8075	6035120.0
2017-01-11 14:30:00	AAPL	Stock	29.8072	29.9595	29.805	29.956	12336940.0
2017-01-11 15:00:00	AAPL	Stock	29.9555	29.9825	29.9062	29.9585	9209756.0
2017-01-11 15:30:00	AAPL	Stock	29.9588	29.9725	29.9125	29.9325	9811916.0
2017-01-11 16:00:00	AAPL	Stock	29.9375	29.95	29.925	29.9325	9730408.0
2017-01-11 16:30:00	AAPL	Stock	29.945	29.945	29.9425	29.9425	49420.0
2017-01-11 17:00:00	AAPL	Stock	29.945	29.9475	29.9425	29.945	14216.0
2017-01-11 17:30:00	AAPL	Stock	29.9375	29.9425	29.9375	29.9425	8000.0
2017-01-11 18:00:00	AAPL	Stock	29.9375	29.9375	29.925	29.9325	10000.0
2017-01-11 18:30:00	AAPL	Stock	29.925	29.94	29.925	29.935	11896.0
2017-01-11 19:00:00	AAPL	Stock	29.925	29.93	29.925	29.93	12972.0
2017-01-11 19:30:00	AAPL	Stock	29.925	29.9375	29.925	29.9375	21168.0
2017-01-11 04:00:00	MSFT	Stock	62.7	62.7	62.7	62.7	100.0
2017-01-11 05:30:00	MSFT	Stock	62.61	62.61	62.61	62.61	162.0
2017-01-11 08:00:00	MSFT	Stock	62.77	62.77	62.63	62.63	863.0
2017-01-11 08:30:00	MSFT	Stock	62.62	62.78	62.62	62.78	1015.0
2017-01-11 09:00:00	MSFT	Stock	62.78	62.78	62.59	62.64	11747.0
2017-01-11 09:30:00	MSFT	Stock	62.61	62.95	62.43	62.925	2017731.0
2017-01-11 10:00:00	MSFT	Stock	62.925	62.94	62.76	62.89	1315739.0
2017-01-11 10:30:00	MSFT	Stock	62.89	63.11	62.86	63.09	1490098.0
2017-01-11 11:00:00	MSFT	Stock	63.1	63.145	62.93	62.931	1318343.0
2017-01-11 11:30:00	MSFT	Stock	62.93	63.13	62.73	63.105	1451438.0
2017-01-11 12:00:00	MSFT	Stock	63.11	63.19	62.98	63.085	1000649.0
2017-01-11 12:30:00	MSFT	Stock	63.08	63.1	62.92	63.03	846229.0
2017-01-11 13:00:00	MSFT	Stock	63.035	63.036	62.72	62.79	896863.0
2017-01-11 13:30:00	MSFT	Stock	62.79	62.98	62.715	62.94	1243727.0
2017-01-11 14:00:00	MSFT	Stock	62.94	63.09	62.92	63.06	793569.0
2017-01-11 14:30:00	MSFT	Stock	63.06	63.23	63.05	63.15	827927.0
2017-01-11 15:00:00	MSFT	Stock	63.14	63.19	63.09	63.112	908028.0
2017-01-11 15:30:00	MSFT	Stock	63.11	63.19	63.08	63.16	3112562.0
2017-01-11 16:00:00	MSFT	Stock	63.19	63.19	63.12	63.19	2915583.0
2017-01-11 16:30:00	MSFT	Stock	63.17	63.17	63.12	63.12	1130.0
2017-01-11 17:00:00	MSFT	Stock	63.12	63.19	63.12	63.19	19500.0
2017-01-11 18:00:00	MSFT	Stock	63.1	63.1	63.1	63.1	1600.0

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

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