PREVIEW / stock_30min / 2017-08-31

all stock 30-min files

  file:    by_date/stock_30min/2017/2017-08-31.parquet
  size:    1.6 MB
  rows:    82,901
  symbols: 3,006

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-31 04:00:00	AAPL	Stock	40.875	40.875	40.8125	40.875	8976.0
2017-08-31 04:30:00	AAPL	Stock	40.875	40.92	40.875	40.92	4592.0
2017-08-31 05:00:00	AAPL	Stock	40.9275	40.94	40.925	40.9375	11120.0
2017-08-31 05:30:00	AAPL	Stock	40.9375	40.975	40.925	40.975	1780.0
2017-08-31 06:00:00	AAPL	Stock	40.95	40.95	40.9375	40.9375	13844.0
2017-08-31 06:30:00	AAPL	Stock	40.9125	40.9125	40.9	40.9	21380.0
2017-08-31 07:00:00	AAPL	Stock	40.9	40.9175	40.895	40.895	36216.0
2017-08-31 07:30:00	AAPL	Stock	40.905	40.91	40.8775	40.8775	41720.0
2017-08-31 08:00:00	AAPL	Stock	40.9	40.9175	40.8525	40.9	197156.0
2017-08-31 08:30:00	AAPL	Stock	40.9	40.9175	40.8775	40.89	114768.0
2017-08-31 09:00:00	AAPL	Stock	40.8875	40.91	40.865	40.9075	180100.0
2017-08-31 09:30:00	AAPL	Stock	40.91	41.02	40.89	40.9875	13967524.0
2017-08-31 10:00:00	AAPL	Stock	40.985	41.025	40.925	40.945	7952232.0
2017-08-31 10:30:00	AAPL	Stock	40.945	40.9502	40.87	40.9365	5869908.0
2017-08-31 11:00:00	AAPL	Stock	40.9375	40.9903	40.8975	40.9525	3966444.0
2017-08-31 11:30:00	AAPL	Stock	40.9525	40.9975	40.9025	40.984	4293484.0
2017-08-31 12:00:00	AAPL	Stock	40.9825	41.13	40.98	41.0965	10436692.0
2017-08-31 12:30:00	AAPL	Stock	41.0975	41.0975	41.01	41.0138	4609244.0
2017-08-31 13:00:00	AAPL	Stock	41.0138	41.05	40.9625	40.99	3751768.0
2017-08-31 13:30:00	AAPL	Stock	40.9938	41.01	40.945	40.9838	3600912.0
2017-08-31 14:00:00	AAPL	Stock	40.9838	40.985	40.925	40.965	3570428.0
2017-08-31 14:30:00	AAPL	Stock	40.9675	41.0465	40.9575	41.025	4619184.0
2017-08-31 15:00:00	AAPL	Stock	41.025	41.0375	40.98	41.0165	4005440.0
2017-08-31 15:30:00	AAPL	Stock	41.0175	41.0775	40.9575	40.9925	12955344.0
2017-08-31 16:00:00	AAPL	Stock	41.0175	41.0225	40.985	41.0	12574876.0
2017-08-31 16:30:00	AAPL	Stock	41.0025	41.035	41.0	41.035	39704.0
2017-08-31 17:00:00	AAPL	Stock	41.0175	41.02	41.0	41.02	81212.0
2017-08-31 17:30:00	AAPL	Stock	41.02	41.03	41.0	41.025	122580.0
2017-08-31 18:00:00	AAPL	Stock	41.025	41.035	41.0175	41.035	15716.0
2017-08-31 18:30:00	AAPL	Stock	41.035	41.035	41.01	41.025	16832.0
2017-08-31 19:00:00	AAPL	Stock	41.025	41.025	41.015	41.0225	13336.0
2017-08-31 19:30:00	AAPL	Stock	41.035	41.05	41.0225	41.05	43576.0
2017-08-31 04:30:00	MSFT	Stock	73.9	73.9	73.9	73.9	3900.0
2017-08-31 05:00:00	MSFT	Stock	74.1	74.1	74.1	74.1	300.0
2017-08-31 05:30:00	MSFT	Stock	74.11	74.11	74.11	74.11	100.0
2017-08-31 06:00:00	MSFT	Stock	74.2	74.2	74.2	74.2	345.0
2017-08-31 07:30:00	MSFT	Stock	74.15	74.15	74.15	74.15	200.0
2017-08-31 08:00:00	MSFT	Stock	74.1	74.15	74.1	74.15	2025.0
2017-08-31 08:30:00	MSFT	Stock	74.18	74.18	74.09	74.1	1160.0
2017-08-31 09:00:00	MSFT	Stock	74.16	74.18	74.0	74.0	28695.0
2017-08-31 09:30:00	MSFT	Stock	74.03	74.59	73.8	74.565	2799418.0
2017-08-31 10:00:00	MSFT	Stock	74.565	74.75	74.49	74.699	2038436.0
2017-08-31 10:30:00	MSFT	Stock	74.695	74.74	74.49	74.565	1565479.0
2017-08-31 11:00:00	MSFT	Stock	74.565	74.62	74.46	74.59	985430.0
2017-08-31 11:30:00	MSFT	Stock	74.58	74.75	74.53	74.75	933574.0
2017-08-31 12:00:00	MSFT	Stock	74.75	74.78	74.68	74.74	831880.0
2017-08-31 12:30:00	MSFT	Stock	74.74	74.76	74.65	74.725	566330.0
2017-08-31 13:00:00	MSFT	Stock	74.725	74.79	74.72	74.735	762837.0
2017-08-31 13:30:00	MSFT	Stock	74.735	74.92	74.72	74.905	960898.0
2017-08-31 14:00:00	MSFT	Stock	74.9	74.96	74.695	74.78	1069590.0

> showing 50 of 82,901 rows — these rows as CSV

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