PREVIEW / stock_30min / 2020-04-22

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-04-22.parquet
  size:    1.8 MB
  rows:    91,155
  symbols: 2,377

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-04-22 04:00:00	AAPL	Stock	67.995	68.245	67.8725	68.165	36444.0
2020-04-22 04:30:00	AAPL	Stock	68.235	68.31	68.1575	68.1575	6660.0
2020-04-22 05:00:00	AAPL	Stock	68.325	68.475	68.28	68.4375	7064.0
2020-04-22 05:30:00	AAPL	Stock	68.4	68.4	68.4	68.4	800.0
2020-04-22 06:00:00	AAPL	Stock	68.4	68.4	68.175	68.2625	27304.0
2020-04-22 06:30:00	AAPL	Stock	68.2625	68.3625	68.125	68.225	63348.0
2020-04-22 07:00:00	AAPL	Stock	68.18	68.325	68.025	68.05	103992.0
2020-04-22 07:30:00	AAPL	Stock	68.115	68.2125	68.0275	68.18	56504.0
2020-04-22 08:00:00	AAPL	Stock	68.18	68.2725	67.95	68.195	260232.0
2020-04-22 08:30:00	AAPL	Stock	68.185	68.435	68.1725	68.4325	512540.0
2020-04-22 09:00:00	AAPL	Stock	68.4	68.45	68.325	68.38	265484.0
2020-04-22 09:30:00	AAPL	Stock	68.3875	68.72	68.1075	68.415	14231656.0
2020-04-22 10:00:00	AAPL	Stock	68.42	68.6	68.265	68.3075	7266412.0
2020-04-22 10:30:00	AAPL	Stock	68.315	68.4975	68.15	68.1725	5809148.0
2020-04-22 11:00:00	AAPL	Stock	68.18	68.46	68.05	68.3775	4778544.0
2020-04-22 11:30:00	AAPL	Stock	68.375	68.5075	68.3275	68.4	4219772.0
2020-04-22 12:00:00	AAPL	Stock	68.405	68.65	68.4025	68.5575	4684800.0
2020-04-22 12:30:00	AAPL	Stock	68.5592	68.73	68.455	68.5425	4066756.0
2020-04-22 13:00:00	AAPL	Stock	68.5475	68.7325	68.5075	68.7175	3070396.0
2020-04-22 13:30:00	AAPL	Stock	68.72	68.975	68.63	68.935	4393036.0
2020-04-22 14:00:00	AAPL	Stock	68.9412	69.025	68.7875	68.894	4389032.0
2020-04-22 14:30:00	AAPL	Stock	68.8975	69.395	68.8925	69.3475	6081376.0
2020-04-22 15:00:00	AAPL	Stock	69.3475	69.395	69.065	69.1885	7764124.0
2020-04-22 15:30:00	AAPL	Stock	69.1888	69.475	68.9275	69.025	13410380.0
2020-04-22 16:00:00	AAPL	Stock	69.025	69.025	68.86	68.86	10320956.0
2020-04-22 16:30:00	AAPL	Stock	68.88	69.025	68.875	68.9	737988.0
2020-04-22 17:00:00	AAPL	Stock	68.9	69.025	68.9	68.9125	257240.0
2020-04-22 17:30:00	AAPL	Stock	68.9125	69.0225	68.9075	69.0225	48296.0
2020-04-22 18:00:00	AAPL	Stock	69.0	69.025	68.775	68.815	39168.0
2020-04-22 18:30:00	AAPL	Stock	68.8	68.8	68.625	68.6275	25468.0
2020-04-22 19:00:00	AAPL	Stock	68.6575	68.6575	68.505	68.5725	37532.0
2020-04-22 19:30:00	AAPL	Stock	68.5375	68.5925	68.505	68.5625	60488.0
2020-04-22 04:00:00	MSFT	Stock	170.57	170.9	170.35	170.9	3428.0
2020-04-22 04:30:00	MSFT	Stock	171.0	171.15	171.0	171.15	2242.0
2020-04-22 05:00:00	MSFT	Stock	171.35	171.88	171.35	171.8	5161.0
2020-04-22 05:30:00	MSFT	Stock	171.62	171.7	171.51	171.51	2499.0
2020-04-22 06:00:00	MSFT	Stock	171.6	171.6	171.29	171.29	4378.0
2020-04-22 06:30:00	MSFT	Stock	171.48	171.5	171.1	171.26	4814.0
2020-04-22 07:00:00	MSFT	Stock	171.1	171.19	170.53	170.7	27837.0
2020-04-22 07:30:00	MSFT	Stock	170.65	170.92	170.4	170.9	31034.0
2020-04-22 08:00:00	MSFT	Stock	170.8	171.14	168.23	170.95	56568.0
2020-04-22 08:30:00	MSFT	Stock	170.85	171.63	170.8	171.55	55861.0
2020-04-22 09:00:00	MSFT	Stock	171.49	171.75	171.18	171.47	70041.0
2020-04-22 09:30:00	MSFT	Stock	171.4	172.49	170.82	171.766	4306416.0
2020-04-22 10:00:00	MSFT	Stock	171.78	172.0	171.02	171.61	1981626.0
2020-04-22 10:30:00	MSFT	Stock	171.63	172.2	171.4	171.56	1997663.0
2020-04-22 11:00:00	MSFT	Stock	171.57	172.24	171.32	172.08	1683376.0
2020-04-22 11:30:00	MSFT	Stock	172.07	172.55	171.955	172.095	1597832.0
2020-04-22 12:00:00	MSFT	Stock	172.09	172.55	171.83	171.98	1227761.0
2020-04-22 12:30:00	MSFT	Stock	171.99	172.515	171.86	172.21	1388899.0

> showing 50 of 91,155 rows — these rows as CSV

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