PREVIEW / stock_30min / 2018-02-15

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-02-15.parquet
  size:    1.7 MB
  rows:    83,495
  symbols: 2,884

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
2018-02-15 04:00:00	AAPL	Stock	42.4	42.495	42.38	42.495	22268.0
2018-02-15 04:30:00	AAPL	Stock	42.49	42.4925	42.45	42.4875	21388.0
2018-02-15 05:00:00	AAPL	Stock	42.4875	42.49	42.415	42.4475	42896.0
2018-02-15 05:30:00	AAPL	Stock	42.435	42.45	42.3825	42.3825	53980.0
2018-02-15 06:00:00	AAPL	Stock	42.3875	42.3925	42.25	42.375	67032.0
2018-02-15 06:30:00	AAPL	Stock	42.325	42.375	42.265	42.375	85080.0
2018-02-15 07:00:00	AAPL	Stock	42.3575	42.475	42.3075	42.38	251240.0
2018-02-15 07:30:00	AAPL	Stock	42.3825	42.3825	42.245	42.3	334700.0
2018-02-15 08:00:00	AAPL	Stock	42.315	42.47	42.245	42.305	536152.0
2018-02-15 08:30:00	AAPL	Stock	42.305	42.4125	42.2175	42.35	552296.0
2018-02-15 09:00:00	AAPL	Stock	42.3525	42.475	42.35	42.4475	693192.0
2018-02-15 09:30:00	AAPL	Stock	42.4475	43.015	42.25	42.84	37946396.0
2018-02-15 10:00:00	AAPL	Stock	42.8425	42.8725	42.63	42.8375	20272664.0
2018-02-15 10:30:00	AAPL	Stock	42.84	42.8675	42.406	42.4175	14449356.0
2018-02-15 11:00:00	AAPL	Stock	42.4225	42.795	42.3	42.78	13129144.0
2018-02-15 11:30:00	AAPL	Stock	42.7825	42.92	42.7425	42.8375	9537928.0
2018-02-15 12:00:00	AAPL	Stock	42.8325	42.9125	42.76	42.905	6096628.0
2018-02-15 12:30:00	AAPL	Stock	42.9075	43.0175	42.8975	43.0	8621256.0
2018-02-15 13:00:00	AAPL	Stock	43.0025	43.1925	42.9625	42.9878	12384572.0
2018-02-15 13:30:00	AAPL	Stock	42.99	43.065	42.91	42.9975	7679360.0
2018-02-15 14:00:00	AAPL	Stock	42.9975	43.235	42.9925	43.223	8405996.0
2018-02-15 14:30:00	AAPL	Stock	43.22	43.2575	43.1275	43.2125	8789724.0
2018-02-15 15:00:00	AAPL	Stock	43.215	43.2725	43.17	43.1825	9407824.0
2018-02-15 15:30:00	AAPL	Stock	43.185	43.25	43.0825	43.25	17313244.0
2018-02-15 16:00:00	AAPL	Stock	43.2475	43.275	43.095	43.2575	9482284.0
2018-02-15 16:30:00	AAPL	Stock	43.275	43.2975	43.26	43.28	59976.0
2018-02-15 17:00:00	AAPL	Stock	43.275	43.285	43.2725	43.285	76196.0
2018-02-15 17:30:00	AAPL	Stock	43.275	43.2875	43.2725	43.2875	43348.0
2018-02-15 18:00:00	AAPL	Stock	43.2875	43.31	43.28	43.31	41964.0
2018-02-15 18:30:00	AAPL	Stock	43.31	43.3125	43.2475	43.3	21964.0
2018-02-15 19:00:00	AAPL	Stock	43.3025	43.3175	43.3	43.3	22624.0
2018-02-15 19:30:00	AAPL	Stock	43.305	43.325	43.285	43.325	60120.0
2018-02-15 04:00:00	MSFT	Stock	91.0	91.12	91.0	91.12	624.0
2018-02-15 04:30:00	MSFT	Stock	91.25	91.25	91.25	91.25	100.0
2018-02-15 05:00:00	MSFT	Stock	91.44	91.44	91.44	91.44	500.0
2018-02-15 05:30:00	MSFT	Stock	91.35	91.35	91.35	91.35	100.0
2018-02-15 06:00:00	MSFT	Stock	91.25	91.25	91.08	91.08	1209.0
2018-02-15 06:30:00	MSFT	Stock	91.13	91.19	91.13	91.19	400.0
2018-02-15 07:00:00	MSFT	Stock	91.29	91.29	91.11	91.11	7488.0
2018-02-15 07:30:00	MSFT	Stock	91.15	91.25	91.15	91.25	4584.0
2018-02-15 08:00:00	MSFT	Stock	91.195	91.29	91.195	91.24	8927.0
2018-02-15 08:30:00	MSFT	Stock	91.17	91.3	91.1	91.3	11080.0
2018-02-15 09:00:00	MSFT	Stock	91.27	91.35	91.02	91.15	18113.0
2018-02-15 09:30:00	MSFT	Stock	91.21	91.91	90.82	91.845	2806018.0
2018-02-15 10:00:00	MSFT	Stock	91.84	92.08	91.42	92.01	2279769.0
2018-02-15 10:30:00	MSFT	Stock	92.01	92.06	90.85	90.88	2007410.0
2018-02-15 11:00:00	MSFT	Stock	90.89	91.49	90.62	91.48	1600832.0
2018-02-15 11:30:00	MSFT	Stock	91.48	91.76	91.32	91.7	1161248.0
2018-02-15 12:00:00	MSFT	Stock	91.7	91.83	91.45	91.56	1097553.0
2018-02-15 12:30:00	MSFT	Stock	91.56	91.965	91.555	91.95	861706.0

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

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