PREVIEW / stock_30min / 2020-08-20

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-08-20.parquet
  size:    1.9 MB
  rows:    96,294
  symbols: 2,459

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
2020-08-20 04:00:00	AAPL	Stock	115.675	115.675	115.25	115.25	9144.0
2020-08-20 04:30:00	AAPL	Stock	115.25	115.43	115.25	115.425	2400.0
2020-08-20 05:00:00	AAPL	Stock	115.4925	115.4925	115.4925	115.4925	1600.0
2020-08-20 05:30:00	AAPL	Stock	115.6225	115.9625	115.6225	115.95	8352.0
2020-08-20 06:00:00	AAPL	Stock	115.9825	116.1625	115.93	116.1625	10360.0
2020-08-20 06:30:00	AAPL	Stock	116.15	116.3625	116.1125	116.3625	24372.0
2020-08-20 07:00:00	AAPL	Stock	116.35	116.3775	116.0325	116.1625	198968.0
2020-08-20 07:30:00	AAPL	Stock	116.185	116.275	116.0	116.16	143364.0
2020-08-20 08:00:00	AAPL	Stock	116.16	116.35	115.995	116.1725	256276.0
2020-08-20 08:30:00	AAPL	Stock	116.15	116.1825	115.875	116.0	208552.0
2020-08-20 09:00:00	AAPL	Stock	115.976	116.02	115.75	115.75	270208.0
2020-08-20 09:30:00	AAPL	Stock	115.755	117.4225	115.7335	117.255	17653384.0
2020-08-20 10:00:00	AAPL	Stock	117.275	117.445	116.82	117.0258	8816136.0
2020-08-20 10:30:00	AAPL	Stock	117.0162	117.44	116.8	117.165	7509076.0
2020-08-20 11:00:00	AAPL	Stock	117.175	117.2375	116.8575	117.196	4314132.0
2020-08-20 11:30:00	AAPL	Stock	117.1925	117.4125	117.115	117.3162	4663696.0
2020-08-20 12:00:00	AAPL	Stock	117.32	117.625	117.21	117.349	6434508.0
2020-08-20 12:30:00	AAPL	Stock	117.35	117.465	117.0925	117.1525	3564504.0
2020-08-20 13:00:00	AAPL	Stock	117.1505	117.5	117.025	117.4918	3779668.0
2020-08-20 13:30:00	AAPL	Stock	117.4938	117.5	117.1575	117.3425	3810668.0
2020-08-20 14:00:00	AAPL	Stock	117.3325	117.5775	117.225	117.42	3775676.0
2020-08-20 14:30:00	AAPL	Stock	117.4125	117.675	117.3425	117.6462	4550376.0
2020-08-20 15:00:00	AAPL	Stock	117.6425	118.07	117.4388	117.9688	7785664.0
2020-08-20 15:30:00	AAPL	Stock	117.9625	118.392	117.8725	118.2075	12562964.0
2020-08-20 16:00:00	AAPL	Stock	118.275	118.425	117.285	118.425	6978756.0
2020-08-20 16:30:00	AAPL	Stock	118.4225	118.685	115.7075	118.63	263872.0
2020-08-20 17:00:00	AAPL	Stock	118.6375	118.75	115.7075	118.745	179160.0
2020-08-20 17:30:00	AAPL	Stock	118.725	119.0	118.6525	118.9225	150896.0
2020-08-20 18:00:00	AAPL	Stock	118.9	118.9925	118.8125	118.875	123596.0
2020-08-20 18:30:00	AAPL	Stock	118.875	118.9725	118.85	118.9725	79768.0
2020-08-20 19:00:00	AAPL	Stock	118.9625	118.9875	118.9525	118.955	42300.0
2020-08-20 19:30:00	AAPL	Stock	118.97	119.22	118.9575	119.1375	276196.0
2020-08-20 04:00:00	MSFT	Stock	209.3	209.3	208.94	208.94	2295.0
2020-08-20 04:30:00	MSFT	Stock	209.1	209.4	209.1	209.4	299.0
2020-08-20 05:00:00	MSFT	Stock	209.35	209.35	209.35	209.35	474.0
2020-08-20 05:30:00	MSFT	Stock	209.71	210.1	209.58	210.09	2619.0
2020-08-20 06:00:00	MSFT	Stock	209.95	210.17	209.95	210.17	249.0
2020-08-20 06:30:00	MSFT	Stock	210.25	210.57	210.18	210.49	768.0
2020-08-20 07:00:00	MSFT	Stock	210.05	210.21	209.74	209.74	6435.0
2020-08-20 07:30:00	MSFT	Stock	209.8	209.9	209.78	209.78	836.0
2020-08-20 08:00:00	MSFT	Stock	209.787	210.2	209.59	209.65	12110.0
2020-08-20 08:30:00	MSFT	Stock	209.65	209.69	209.42	209.52	13067.0
2020-08-20 09:00:00	MSFT	Stock	209.55	209.63	209.32	209.63	32899.0
2020-08-20 09:30:00	MSFT	Stock	209.55	210.72	208.91	210.49	1806249.0
2020-08-20 10:00:00	MSFT	Stock	210.53	211.02	210.17	210.89	1138773.0
2020-08-20 10:30:00	MSFT	Stock	210.885	211.99	210.885	211.96	1281664.0
2020-08-20 11:00:00	MSFT	Stock	211.96	212.02	210.96	211.24	966128.0
2020-08-20 11:30:00	MSFT	Stock	211.24	212.092	211.09	211.98	872318.0
2020-08-20 12:00:00	MSFT	Stock	211.99	212.36	211.83	211.84	986199.0
2020-08-20 12:30:00	MSFT	Stock	211.86	212.22	211.58	211.75	762319.0

> showing 50 of 96,294 rows — these rows as CSV

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