PREVIEW / stock_30min / 2019-02-04

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-02-04.parquet
  size:    1.7 MB
  rows:    83,745
  symbols: 2,657

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
2019-02-04 04:30:00	AAPL	Stock	41.725	41.74	41.725	41.74	1008.0
2019-02-04 05:00:00	AAPL	Stock	41.7575	41.79	41.75	41.75	7928.0
2019-02-04 06:00:00	AAPL	Stock	41.76	41.79	41.76	41.79	2000.0
2019-02-04 06:30:00	AAPL	Stock	41.7625	41.7675	41.7575	41.7675	4800.0
2019-02-04 07:00:00	AAPL	Stock	41.7875	41.7875	41.7275	41.7625	38880.0
2019-02-04 07:30:00	AAPL	Stock	41.765	41.7775	41.73	41.775	64936.0
2019-02-04 08:00:00	AAPL	Stock	41.76	41.8	41.7375	41.775	175872.0
2019-02-04 08:30:00	AAPL	Stock	41.7525	41.83	41.6875	41.825	124216.0
2019-02-04 09:00:00	AAPL	Stock	41.825	41.875	41.7975	41.87	270604.0
2019-02-04 09:30:00	AAPL	Stock	41.87	42.455	41.82	42.4425	17740364.0
2019-02-04 10:00:00	AAPL	Stock	42.4457	42.6262	42.34	42.5	15766328.0
2019-02-04 10:30:00	AAPL	Stock	42.5	42.675	42.4925	42.5575	9739808.0
2019-02-04 11:00:00	AAPL	Stock	42.5625	42.74	42.515	42.6725	8228764.0
2019-02-04 11:30:00	AAPL	Stock	42.6725	42.8425	42.6512	42.7675	8034860.0
2019-02-04 12:00:00	AAPL	Stock	42.7725	42.795	42.6425	42.6725	5626264.0
2019-02-04 12:30:00	AAPL	Stock	42.6675	42.7375	42.6425	42.715	3637424.0
2019-02-04 13:00:00	AAPL	Stock	42.715	42.785	42.7038	42.715	3923332.0
2019-02-04 13:30:00	AAPL	Stock	42.715	42.8825	42.7125	42.8625	4710712.0
2019-02-04 14:00:00	AAPL	Stock	42.87	42.9138	42.8075	42.8125	3564172.0
2019-02-04 14:30:00	AAPL	Stock	42.8125	42.845	42.7375	42.8103	4059880.0
2019-02-04 15:00:00	AAPL	Stock	42.81	42.8375	42.75	42.7567	4010772.0
2019-02-04 15:30:00	AAPL	Stock	42.755	42.8175	42.6815	42.8175	10192056.0
2019-02-04 16:00:00	AAPL	Stock	42.8125	42.8225	42.7075	42.75	12485004.0
2019-02-04 16:30:00	AAPL	Stock	42.7525	42.8025	42.75	42.7975	59824.0
2019-02-04 17:00:00	AAPL	Stock	42.78	42.8125	42.7375	42.7375	114536.0
2019-02-04 17:30:00	AAPL	Stock	42.75	42.75	42.7125	42.745	65048.0
2019-02-04 18:00:00	AAPL	Stock	42.7425	42.76	42.7175	42.76	18820.0
2019-02-04 18:30:00	AAPL	Stock	42.75	42.775	42.75	42.75	26600.0
2019-02-04 19:00:00	AAPL	Stock	42.73	42.8	42.73	42.79	39236.0
2019-02-04 19:30:00	AAPL	Stock	42.7875	42.7875	42.725	42.725	59592.0
2019-02-04 04:00:00	MSFT	Stock	102.92	103.1	102.92	103.1	787.0
2019-02-04 04:30:00	MSFT	Stock	103.1	103.1	103.1	103.1	100.0
2019-02-04 05:30:00	MSFT	Stock	103.06	103.06	103.06	103.06	100.0
2019-02-04 06:00:00	MSFT	Stock	103.06	103.2	103.0	103.0	1169.0
2019-02-04 06:30:00	MSFT	Stock	103.0	103.0	103.0	103.0	775.0
2019-02-04 07:00:00	MSFT	Stock	103.0	103.12	102.92	103.0	5430.0
2019-02-04 07:30:00	MSFT	Stock	103.0	103.0	102.88	102.9	9965.0
2019-02-04 08:00:00	MSFT	Stock	103.0	103.2	102.69	102.69	26600.0
2019-02-04 08:30:00	MSFT	Stock	102.69	102.85	102.61	102.82	11046.0
2019-02-04 09:00:00	MSFT	Stock	102.95	103.35	102.75	103.25	31462.0
2019-02-04 09:30:00	MSFT	Stock	103.16	104.29	102.77	104.215	3803936.0
2019-02-04 10:00:00	MSFT	Stock	104.22	105.066	104.06	104.8	3410402.0
2019-02-04 10:30:00	MSFT	Stock	104.8	105.36	104.78	105.36	1945560.0
2019-02-04 11:00:00	MSFT	Stock	105.36	105.67	105.33	105.52	2050699.0
2019-02-04 11:30:00	MSFT	Stock	105.52	105.585	105.18	105.5	1355027.0
2019-02-04 12:00:00	MSFT	Stock	105.504	105.64	105.4	105.58	1091438.0
2019-02-04 12:30:00	MSFT	Stock	105.57	105.585	105.29	105.36	782389.0
2019-02-04 13:00:00	MSFT	Stock	105.36	105.39	105.09	105.175	770813.0
2019-02-04 13:30:00	MSFT	Stock	105.175	105.43	105.09	105.42	900945.0
2019-02-04 14:00:00	MSFT	Stock	105.418	105.625	105.37	105.51	848784.0

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

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