PREVIEW / stock_30min / 2016-12-14

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-12-14.parquet
  size:    1.6 MB
  rows:    83,141
  symbols: 3,147

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-12-14 05:00:00	AAPL	Stock	28.8125	28.8125	28.8	28.8	2864.0
2016-12-14 05:30:00	AAPL	Stock	28.815	28.815	28.815	28.815	2752.0
2016-12-14 06:30:00	AAPL	Stock	28.8	28.8	28.8	28.8	820.0
2016-12-14 07:00:00	AAPL	Stock	28.8475	28.8975	28.84	28.875	17772.0
2016-12-14 07:30:00	AAPL	Stock	28.8875	28.8875	28.7575	28.8	25456.0
2016-12-14 08:00:00	AAPL	Stock	28.8125	28.8575	28.7075	28.7325	223596.0
2016-12-14 08:30:00	AAPL	Stock	28.725	28.7625	28.72	28.75	107664.0
2016-12-14 09:00:00	AAPL	Stock	28.765	28.79	28.735	28.76	193284.0
2016-12-14 09:30:00	AAPL	Stock	28.76	29.05	28.745	28.9925	19807024.0
2016-12-14 10:00:00	AAPL	Stock	28.995	29.025	28.9525	28.9875	8507244.0
2016-12-14 10:30:00	AAPL	Stock	28.99	29.015	28.8925	28.9345	7321308.0
2016-12-14 11:00:00	AAPL	Stock	28.9338	28.94	28.8312	28.89	6025528.0
2016-12-14 11:30:00	AAPL	Stock	28.8908	28.955	28.8725	28.9225	4545596.0
2016-12-14 12:00:00	AAPL	Stock	28.9225	28.95	28.8825	28.91	3514816.0
2016-12-14 12:30:00	AAPL	Stock	28.91	28.92	28.875	28.8952	3562932.0
2016-12-14 13:00:00	AAPL	Stock	28.8962	28.9675	28.8952	28.965	3302824.0
2016-12-14 13:30:00	AAPL	Stock	28.965	28.9875	28.9188	28.98	3658340.0
2016-12-14 14:00:00	AAPL	Stock	28.9825	29.0075	28.7625	28.8225	14342824.0
2016-12-14 14:30:00	AAPL	Stock	28.8208	28.9775	28.8075	28.9125	10495008.0
2016-12-14 15:00:00	AAPL	Stock	28.9125	28.9725	28.76	28.86	11314232.0
2016-12-14 15:30:00	AAPL	Stock	28.8612	28.995	28.7675	28.8	16392736.0
2016-12-14 16:00:00	AAPL	Stock	28.8	28.8325	28.7975	28.7975	12181752.0
2016-12-14 16:30:00	AAPL	Stock	28.82	28.825	28.8075	28.8075	35000.0
2016-12-14 17:00:00	AAPL	Stock	28.825	28.825	28.7625	28.795	76944.0
2016-12-14 17:30:00	AAPL	Stock	28.805	28.825	28.7875	28.825	18768.0
2016-12-14 18:00:00	AAPL	Stock	28.8125	28.8125	28.7975	28.81	14080.0
2016-12-14 18:30:00	AAPL	Stock	28.8	28.8	28.7675	28.78	18024.0
2016-12-14 19:00:00	AAPL	Stock	28.81	28.825	28.8	28.8225	10732.0
2016-12-14 19:30:00	AAPL	Stock	28.8125	28.8225	28.8125	28.8225	7440.0
2016-12-14 04:30:00	MSFT	Stock	63.05	63.05	63.05	63.05	500.0
2016-12-14 05:30:00	MSFT	Stock	63.1	63.1	63.1	63.1	400.0
2016-12-14 07:00:00	MSFT	Stock	63.2	63.2	63.2	63.2	200.0
2016-12-14 07:30:00	MSFT	Stock	63.13	63.13	63.04	63.1	10126.0
2016-12-14 08:00:00	MSFT	Stock	63.08	63.1	63.05	63.05	2358.0
2016-12-14 08:30:00	MSFT	Stock	63.04	63.05	63.0	63.05	2074.0
2016-12-14 09:00:00	MSFT	Stock	63.05	63.11	62.96	63.11	14180.0
2016-12-14 09:30:00	MSFT	Stock	63.0	63.45	62.88	63.055	2745079.0
2016-12-14 10:00:00	MSFT	Stock	63.06	63.21	63.03	63.16	1588780.0
2016-12-14 10:30:00	MSFT	Stock	63.165	63.24	62.985	62.99	1279157.0
2016-12-14 11:00:00	MSFT	Stock	62.995	63.01	62.846	62.943	1106629.0
2016-12-14 11:30:00	MSFT	Stock	62.94	63.11	62.92	63.055	1156853.0
2016-12-14 12:00:00	MSFT	Stock	63.059	63.09	63.02	63.055	893734.0
2016-12-14 12:30:00	MSFT	Stock	63.06	63.114	63.029	63.09	794230.0
2016-12-14 13:00:00	MSFT	Stock	63.09	63.125	63.04	63.065	826113.0
2016-12-14 13:30:00	MSFT	Stock	63.07	63.19	62.99	63.174	937327.0
2016-12-14 14:00:00	MSFT	Stock	63.18	63.24	62.62	62.78	2906620.0
2016-12-14 14:30:00	MSFT	Stock	62.78	63.2	62.76	62.89	2881084.0
2016-12-14 15:00:00	MSFT	Stock	62.88	63.02	62.53	62.77	2606132.0
2016-12-14 15:30:00	MSFT	Stock	62.76	63.115	62.57	62.69	4586329.0
2016-12-14 16:00:00	MSFT	Stock	62.68	62.87	62.68	62.85	2675514.0

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

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