PREVIEW / stock_30min / 2020-04-24

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-04-24.parquet
  size:    1.8 MB
  rows:    90,454
  symbols: 2,369

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-24 04:00:00	AAPL	Stock	68.2	68.325	68.2	68.3	5420.0
2020-04-24 04:30:00	AAPL	Stock	68.2875	68.3975	68.275	68.3975	4732.0
2020-04-24 05:00:00	AAPL	Stock	68.38	69.12	68.38	69.0025	2788.0
2020-04-24 05:30:00	AAPL	Stock	69.025	69.025	69.025	69.025	400.0
2020-04-24 06:00:00	AAPL	Stock	68.8925	69.0	68.75	68.9375	5036.0
2020-04-24 06:30:00	AAPL	Stock	68.9125	69.135	68.7875	69.015	25564.0
2020-04-24 07:00:00	AAPL	Stock	68.9025	69.11	68.775	69.025	87020.0
2020-04-24 07:30:00	AAPL	Stock	69.025	69.08	68.915	68.915	56756.0
2020-04-24 08:00:00	AAPL	Stock	69.075	69.1	68.875	69.0725	176180.0
2020-04-24 08:30:00	AAPL	Stock	69.09	69.3425	69.04	69.1925	179772.0
2020-04-24 09:00:00	AAPL	Stock	69.1607	69.325	69.0	69.3125	213716.0
2020-04-24 09:30:00	AAPL	Stock	69.3125	69.8725	69.25	69.3625	14106216.0
2020-04-24 10:00:00	AAPL	Stock	69.3605	70.065	69.3605	69.8725	10282508.0
2020-04-24 10:30:00	AAPL	Stock	69.875	70.1225	69.8375	69.865	7042304.0
2020-04-24 11:00:00	AAPL	Stock	69.8625	69.87	69.5018	69.745	6269860.0
2020-04-24 11:30:00	AAPL	Stock	69.745	69.88	69.5675	69.7125	4692784.0
2020-04-24 12:00:00	AAPL	Stock	69.7175	70.035	69.62	70.03	5146072.0
2020-04-24 12:30:00	AAPL	Stock	70.03	70.205	69.9225	70.1175	5869028.0
2020-04-24 13:00:00	AAPL	Stock	70.1175	70.25	70.06	70.2	5269648.0
2020-04-24 13:30:00	AAPL	Stock	70.2025	70.3425	70.17	70.3225	5126048.0
2020-04-24 14:00:00	AAPL	Stock	70.325	70.5	70.265	70.315	5749460.0
2020-04-24 14:30:00	AAPL	Stock	70.3175	70.435	70.2725	70.31	3959000.0
2020-04-24 15:00:00	AAPL	Stock	70.3025	70.495	70.1525	70.4925	6838044.0
2020-04-24 15:30:00	AAPL	Stock	70.495	70.7525	70.405	70.7375	13845840.0
2020-04-24 16:00:00	AAPL	Stock	70.74	70.7475	70.1903	70.7225	8784904.0
2020-04-24 16:30:00	AAPL	Stock	70.73	70.75	70.71	70.745	88992.0
2020-04-24 17:00:00	AAPL	Stock	70.7275	70.7425	70.625	70.625	86000.0
2020-04-24 17:30:00	AAPL	Stock	70.63	70.63	70.5075	70.61	156752.0
2020-04-24 18:00:00	AAPL	Stock	70.6	70.6	70.5	70.525	69744.0
2020-04-24 18:30:00	AAPL	Stock	70.5225	70.5975	70.515	70.515	25632.0
2020-04-24 19:00:00	AAPL	Stock	70.515	70.575	70.515	70.55	71612.0
2020-04-24 19:30:00	AAPL	Stock	70.55	70.5875	70.45	70.475	142588.0
2020-04-24 04:00:00	MSFT	Stock	170.8	170.8	170.5	170.5	1831.0
2020-04-24 04:30:00	MSFT	Stock	170.5	170.5	170.5	170.5	141.0
2020-04-24 05:00:00	MSFT	Stock	171.04	172.51	171.04	172.51	1140.0
2020-04-24 05:30:00	MSFT	Stock	172.2	172.48	171.93	172.48	1618.0
2020-04-24 06:00:00	MSFT	Stock	172.36	172.46	172.3	172.3	600.0
2020-04-24 06:30:00	MSFT	Stock	172.0	173.4	172.0	173.28	3709.0
2020-04-24 07:00:00	MSFT	Stock	172.3	173.48	172.3	172.88	19150.0
2020-04-24 07:30:00	MSFT	Stock	172.86	172.86	172.25	172.31	5080.0
2020-04-24 08:00:00	MSFT	Stock	172.51	172.9	171.84	172.6	30755.0
2020-04-24 08:30:00	MSFT	Stock	172.6	173.2	172.59	172.85	42150.0
2020-04-24 09:00:00	MSFT	Stock	172.75	172.89	172.05	172.08	36292.0
2020-04-24 09:30:00	MSFT	Stock	172.06	172.738	170.81	170.96	2953840.0
2020-04-24 10:00:00	MSFT	Stock	170.95	172.12	170.71	171.65	2191214.0
2020-04-24 10:30:00	MSFT	Stock	171.65	172.215	171.29	171.559	1273246.0
2020-04-24 11:00:00	MSFT	Stock	171.555	171.83	171.0	171.53	1228457.0
2020-04-24 11:30:00	MSFT	Stock	171.53	172.18	171.19	172.12	1088523.0
2020-04-24 12:00:00	MSFT	Stock	172.14	172.74	171.86	172.64	1382424.0
2020-04-24 12:30:00	MSFT	Stock	172.64	173.67	172.52	173.45	2801075.0

> showing 50 of 90,454 rows — these rows as CSV

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