PREVIEW / stock_30min / 2019-02-06

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-02-06.parquet
  size:    1.7 MB
  rows:    82,709
  symbols: 2,661

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-06 04:00:00	AAPL	Stock	43.5475	43.5525	43.425	43.47	31268.0
2019-02-06 04:30:00	AAPL	Stock	43.4075	43.4375	43.4075	43.4375	7232.0
2019-02-06 05:00:00	AAPL	Stock	43.475	43.5475	43.475	43.5125	30712.0
2019-02-06 05:30:00	AAPL	Stock	43.55	43.555	43.5125	43.555	27388.0
2019-02-06 06:00:00	AAPL	Stock	43.57	43.57	43.57	43.57	400.0
2019-02-06 06:30:00	AAPL	Stock	43.57	43.6175	43.57	43.595	22936.0
2019-02-06 07:00:00	AAPL	Stock	43.595	43.6375	43.55	43.58	52996.0
2019-02-06 07:30:00	AAPL	Stock	43.61	43.6925	43.6075	43.6475	119396.0
2019-02-06 08:00:00	AAPL	Stock	43.6125	43.7375	43.545	43.7025	200908.0
2019-02-06 08:30:00	AAPL	Stock	43.715	43.735	43.6675	43.695	147672.0
2019-02-06 09:00:00	AAPL	Stock	43.687	43.7	43.625	43.6625	159864.0
2019-02-06 09:30:00	AAPL	Stock	43.675	43.8325	43.3825	43.4075	15093124.0
2019-02-06 10:00:00	AAPL	Stock	43.4115	43.4325	43.2132	43.3675	9284360.0
2019-02-06 10:30:00	AAPL	Stock	43.365	43.65	43.365	43.575	7797860.0
2019-02-06 11:00:00	AAPL	Stock	43.5737	43.765	43.515	43.7525	8086268.0
2019-02-06 11:30:00	AAPL	Stock	43.7575	43.8925	43.693	43.707	10255664.0
2019-02-06 12:00:00	AAPL	Stock	43.7075	43.7175	43.5275	43.565	6340612.0
2019-02-06 12:30:00	AAPL	Stock	43.5625	43.655	43.425	43.4725	5746988.0
2019-02-06 13:00:00	AAPL	Stock	43.4725	43.6025	43.4425	43.5425	4509364.0
2019-02-06 13:30:00	AAPL	Stock	43.5425	43.6175	43.5275	43.545	3531948.0
2019-02-06 14:00:00	AAPL	Stock	43.547	43.5475	43.4525	43.5225	3607076.0
2019-02-06 14:30:00	AAPL	Stock	43.5225	43.5688	43.42	43.5688	4163488.0
2019-02-06 15:00:00	AAPL	Stock	43.5675	43.585	43.515	43.5575	3759616.0
2019-02-06 15:30:00	AAPL	Stock	43.56	43.5868	43.4975	43.57	7613948.0
2019-02-06 16:00:00	AAPL	Stock	43.56	43.575	43.5002	43.5475	5905116.0
2019-02-06 16:30:00	AAPL	Stock	43.5575	43.5575	43.5275	43.55	31248.0
2019-02-06 17:00:00	AAPL	Stock	43.545	43.56	43.5125	43.5125	75276.0
2019-02-06 17:30:00	AAPL	Stock	43.5125	43.525	43.5	43.5	43128.0
2019-02-06 18:00:00	AAPL	Stock	43.5025	43.5225	43.5	43.52	19760.0
2019-02-06 18:30:00	AAPL	Stock	43.5175	43.5175	43.505	43.5175	11616.0
2019-02-06 19:00:00	AAPL	Stock	43.52	43.5225	43.5	43.5025	19300.0
2019-02-06 19:30:00	AAPL	Stock	43.5125	43.515	43.5	43.5	32156.0
2019-02-06 04:00:00	MSFT	Stock	106.94	106.94	106.94	106.94	100.0
2019-02-06 04:30:00	MSFT	Stock	106.8	106.8	106.75	106.75	549.0
2019-02-06 05:00:00	MSFT	Stock	106.88	106.93	106.88	106.93	320.0
2019-02-06 05:30:00	MSFT	Stock	106.92	106.92	106.74	106.77	8640.0
2019-02-06 06:30:00	MSFT	Stock	106.89	106.89	106.89	106.89	300.0
2019-02-06 07:00:00	MSFT	Stock	106.9	106.94	106.8	106.9	11006.0
2019-02-06 07:30:00	MSFT	Stock	106.88	107.0	106.83	106.89	10195.0
2019-02-06 08:00:00	MSFT	Stock	106.9	107.5	106.8	106.97	20274.0
2019-02-06 08:30:00	MSFT	Stock	107.0	107.15	106.9	106.97	7757.0
2019-02-06 09:00:00	MSFT	Stock	106.93	107.0	106.8	106.95	58959.0
2019-02-06 09:30:00	MSFT	Stock	106.95	107.0	106.153	106.24	2508945.0
2019-02-06 10:00:00	MSFT	Stock	106.245	106.245	105.53	105.73	1723999.0
2019-02-06 10:30:00	MSFT	Stock	105.73	106.34	105.73	106.3	1305183.0
2019-02-06 11:00:00	MSFT	Stock	106.29	106.5	105.88	106.06	1253662.0
2019-02-06 11:30:00	MSFT	Stock	106.07	106.243	105.92	106.005	793802.0
2019-02-06 12:00:00	MSFT	Stock	106.01	106.15	105.87	106.13	692723.0
2019-02-06 12:30:00	MSFT	Stock	106.135	106.197	105.96	106.069	675070.0
2019-02-06 13:00:00	MSFT	Stock	106.07	106.2	106.03	106.15	518390.0

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

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