PREVIEW / stock_30min / 2017-08-25

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-08-25.parquet
  size:    1.5 MB
  rows:    79,106
  symbols: 2,963

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-08-25 05:30:00	AAPL	Stock	39.875	39.875	39.875	39.875	4000.0
2017-08-25 06:00:00	AAPL	Stock	39.9225	39.9475	39.9225	39.9475	1600.0
2017-08-25 06:30:00	AAPL	Stock	39.9625	39.9925	39.9625	39.9925	8272.0
2017-08-25 07:00:00	AAPL	Stock	39.965	40.05	39.965	40.025	33148.0
2017-08-25 07:30:00	AAPL	Stock	40.025	40.0975	40.025	40.075	49652.0
2017-08-25 08:00:00	AAPL	Stock	40.0	40.075	39.9975	40.02	113396.0
2017-08-25 08:30:00	AAPL	Stock	40.0225	40.0225	39.9625	40.0075	158752.0
2017-08-25 09:00:00	AAPL	Stock	40.0	40.0025	39.88	39.9075	164152.0
2017-08-25 09:30:00	AAPL	Stock	39.9125	40.0975	39.895	40.0375	11367936.0
2017-08-25 10:00:00	AAPL	Stock	40.0375	40.135	40.0075	40.105	6433272.0
2017-08-25 10:30:00	AAPL	Stock	40.107	40.14	39.935	39.9475	6494736.0
2017-08-25 11:00:00	AAPL	Stock	39.9475	39.9475	39.8225	39.8725	6832668.0
2017-08-25 11:30:00	AAPL	Stock	39.8775	39.981	39.8325	39.9125	3900724.0
2017-08-25 12:00:00	AAPL	Stock	39.9125	39.9372	39.8175	39.895	3484648.0
2017-08-25 12:30:00	AAPL	Stock	39.8885	39.9725	39.86	39.9575	3362968.0
2017-08-25 13:00:00	AAPL	Stock	39.96	40.03	39.9525	39.9875	3682844.0
2017-08-25 13:30:00	AAPL	Stock	39.985	40.0125	39.95	40.0075	2987936.0
2017-08-25 14:00:00	AAPL	Stock	40.01	40.085	39.99	40.0475	3495108.0
2017-08-25 14:30:00	AAPL	Stock	40.0475	40.0625	40.006	40.0132	2381468.0
2017-08-25 15:00:00	AAPL	Stock	40.015	40.0875	39.985	40.0248	4625996.0
2017-08-25 15:30:00	AAPL	Stock	40.0225	40.0312	39.9475	39.965	8536212.0
2017-08-25 16:00:00	AAPL	Stock	39.965	39.9825	39.9575	39.975	4999936.0
2017-08-25 16:30:00	AAPL	Stock	39.975	39.985	39.9625	39.9625	52028.0
2017-08-25 17:00:00	AAPL	Stock	39.96	39.975	39.955	39.975	60348.0
2017-08-25 17:30:00	AAPL	Stock	39.9525	39.955	39.9375	39.9375	4800.0
2017-08-25 18:00:00	AAPL	Stock	39.9375	39.9625	39.9325	39.9325	4672.0
2017-08-25 18:30:00	AAPL	Stock	39.9325	39.95	39.895	39.9125	13036.0
2017-08-25 19:00:00	AAPL	Stock	39.9075	39.93	39.895	39.915	8232.0
2017-08-25 19:30:00	AAPL	Stock	39.93	39.9325	39.895	39.9	16928.0
2017-08-25 06:30:00	MSFT	Stock	72.9	72.91	72.9	72.91	2100.0
2017-08-25 07:30:00	MSFT	Stock	72.99	72.99	72.9	72.9	400.0
2017-08-25 08:00:00	MSFT	Stock	72.98	72.98	72.91	72.91	2730.0
2017-08-25 08:30:00	MSFT	Stock	72.82	72.82	72.82	72.82	100.0
2017-08-25 09:00:00	MSFT	Stock	72.94	72.94	72.78	72.83	9531.0
2017-08-25 09:30:00	MSFT	Stock	72.84	73.275	72.84	73.16	1408131.0
2017-08-25 10:00:00	MSFT	Stock	73.165	73.35	73.01	73.05	784116.0
2017-08-25 10:30:00	MSFT	Stock	73.055	73.17	72.77	72.79	833696.0
2017-08-25 11:00:00	MSFT	Stock	72.78	72.79	72.49	72.58	828348.0
2017-08-25 11:30:00	MSFT	Stock	72.58	72.68	72.48	72.564	493224.0
2017-08-25 12:00:00	MSFT	Stock	72.56	72.715	72.555	72.665	439020.0
2017-08-25 12:30:00	MSFT	Stock	72.665	72.715	72.61	72.644	405066.0
2017-08-25 13:00:00	MSFT	Stock	72.65	72.84	72.644	72.78	406310.0
2017-08-25 13:30:00	MSFT	Stock	72.79	72.86	72.75	72.8	401184.0
2017-08-25 14:00:00	MSFT	Stock	72.79	72.94	72.79	72.86	513628.0
2017-08-25 14:30:00	MSFT	Stock	72.87	72.92	72.84	72.89	538083.0
2017-08-25 15:00:00	MSFT	Stock	72.89	73.05	72.82	72.98	1076794.0
2017-08-25 15:30:00	MSFT	Stock	72.975	73.03	72.76	72.83	2351923.0
2017-08-25 16:00:00	MSFT	Stock	72.82	72.82	72.75	72.82	1368937.0
2017-08-25 16:30:00	MSFT	Stock	72.83	72.83	72.75	72.75	2085.0
2017-08-25 17:00:00	MSFT	Stock	72.75	72.75	72.75	72.75	100.0

> showing 50 of 79,106 rows — these rows as CSV

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