PREVIEW / stock_30min / 2018-03-21

all stock 30-min files

  file:    by_date/stock_30min/2018/2018-03-21.parquet
  size:    1.6 MB
  rows:    81,776
  symbols: 2,873

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-03-21 05:00:00	AAPL	Stock	43.75	43.75	43.75	43.75	1944.0
2018-03-21 06:00:00	AAPL	Stock	43.7475	43.7475	43.7475	43.7475	856.0
2018-03-21 06:30:00	AAPL	Stock	43.8075	43.8075	43.8075	43.8075	5660.0
2018-03-21 07:00:00	AAPL	Stock	43.8075	43.8725	43.8	43.8725	40912.0
2018-03-21 07:30:00	AAPL	Stock	43.8625	43.865	43.6375	43.725	146024.0
2018-03-21 08:00:00	AAPL	Stock	43.7125	43.8775	43.7125	43.775	93316.0
2018-03-21 08:30:00	AAPL	Stock	43.7925	43.81	43.7625	43.81	17444.0
2018-03-21 09:00:00	AAPL	Stock	43.81	43.8125	43.7225	43.76	101120.0
2018-03-21 09:30:00	AAPL	Stock	43.7525	43.7725	43.5025	43.6078	10125820.0
2018-03-21 10:00:00	AAPL	Stock	43.61	43.645	43.46	43.4825	7734984.0
2018-03-21 10:30:00	AAPL	Stock	43.4825	43.5775	43.4288	43.5238	7190240.0
2018-03-21 11:00:00	AAPL	Stock	43.525	43.54	43.4785	43.5075	5003084.0
2018-03-21 11:30:00	AAPL	Stock	43.5075	43.5775	43.4825	43.555	6602616.0
2018-03-21 12:00:00	AAPL	Stock	43.555	43.565	43.485	43.4988	4332616.0
2018-03-21 12:30:00	AAPL	Stock	43.5	43.5175	43.47	43.4725	4308980.0
2018-03-21 13:00:00	AAPL	Stock	43.475	43.475	43.35	43.3738	8370812.0
2018-03-21 13:30:00	AAPL	Stock	43.3725	43.3962	43.265	43.3713	7501388.0
2018-03-21 14:00:00	AAPL	Stock	43.3713	43.55	43.2275	43.2668	15760960.0
2018-03-21 14:30:00	AAPL	Stock	43.265	43.2925	42.83	42.984	15183844.0
2018-03-21 15:00:00	AAPL	Stock	42.9873	43.145	42.915	43.0012	10388068.0
2018-03-21 15:30:00	AAPL	Stock	43.0	43.1	42.815	42.8175	17013380.0
2018-03-21 16:00:00	AAPL	Stock	42.8625	43.5012	42.8175	42.8175	11811684.0
2018-03-21 16:30:00	AAPL	Stock	42.85	42.86	42.8175	42.8575	91896.0
2018-03-21 17:00:00	AAPL	Stock	42.8575	42.915	42.8575	42.89	79692.0
2018-03-21 17:30:00	AAPL	Stock	42.9125	42.93	42.9	42.9125	28052.0
2018-03-21 18:00:00	AAPL	Stock	42.9	42.925	42.9	42.9	39936.0
2018-03-21 18:30:00	AAPL	Stock	42.9275	42.9375	42.895	42.9375	29760.0
2018-03-21 19:00:00	AAPL	Stock	42.94	42.95	42.925	42.95	24192.0
2018-03-21 19:30:00	AAPL	Stock	42.96	42.96	42.9075	42.9425	31140.0
2018-03-21 07:00:00	MSFT	Stock	93.04	93.14	92.9	93.14	783.0
2018-03-21 07:30:00	MSFT	Stock	93.02	93.13	92.91	93.0	2809.0
2018-03-21 08:00:00	MSFT	Stock	93.02	93.08	92.97	92.97	5676.0
2018-03-21 08:30:00	MSFT	Stock	93.02	93.1	93.02	93.1	1867.0
2018-03-21 09:00:00	MSFT	Stock	93.12	93.24	92.91	92.95	10439.0
2018-03-21 09:30:00	MSFT	Stock	92.93	93.28	92.68	93.115	1755955.0
2018-03-21 10:00:00	MSFT	Stock	93.115	93.37	92.92	92.96	1118697.0
2018-03-21 10:30:00	MSFT	Stock	92.96	92.96	92.58	92.6	1212453.0
2018-03-21 11:00:00	MSFT	Stock	92.61	92.837	92.55	92.76	868565.0
2018-03-21 11:30:00	MSFT	Stock	92.76	93.2	92.75	93.04	1259447.0
2018-03-21 12:00:00	MSFT	Stock	93.04	93.11	92.92	93.085	810748.0
2018-03-21 12:30:00	MSFT	Stock	93.09	93.2	93.02	93.2	657702.0
2018-03-21 13:00:00	MSFT	Stock	93.195	93.39	93.14	93.355	1004300.0
2018-03-21 13:30:00	MSFT	Stock	93.36	93.48	93.32	93.34	775713.0
2018-03-21 14:00:00	MSFT	Stock	93.35	94.05	93.19	93.374	2513925.0
2018-03-21 14:30:00	MSFT	Stock	93.38	93.4	92.21	92.55	2218681.0
2018-03-21 15:00:00	MSFT	Stock	92.55	93.21	92.49	92.89	2021107.0
2018-03-21 15:30:00	MSFT	Stock	92.9	93.14	92.43	92.48	3157980.0
2018-03-21 16:00:00	MSFT	Stock	92.48	92.96	92.4	92.96	2506293.0
2018-03-21 16:30:00	MSFT	Stock	92.5	92.57	92.48	92.48	6472.0
2018-03-21 17:00:00	MSFT	Stock	92.57	92.58	92.5	92.58	1128.0

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

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