PREVIEW / stock_30min / 2020-03-17

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-03-17.parquet
  size:    1.9 MB
  rows:    95,218
  symbols: 2,454

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-03-17 04:00:00	AAPL	Stock	63.35	64.7	63.3125	63.58	192512.0
2020-03-17 04:30:00	AAPL	Stock	63.6	63.75	62.0125	62.125	134920.0
2020-03-17 05:00:00	AAPL	Stock	62.23	62.625	61.55	61.75	100520.0
2020-03-17 05:30:00	AAPL	Stock	61.7025	61.715	60.64	61.585	47052.0
2020-03-17 06:00:00	AAPL	Stock	61.4	62.5975	61.3825	62.5	107520.0
2020-03-17 06:30:00	AAPL	Stock	62.6225	63.0625	61.8375	63.0125	57480.0
2020-03-17 07:00:00	AAPL	Stock	62.7775	63.0625	62.2525	62.325	294084.0
2020-03-17 07:30:00	AAPL	Stock	62.32	62.3975	61.5025	61.59	289692.0
2020-03-17 08:00:00	AAPL	Stock	62.515	62.9375	61.5	62.0525	526780.0
2020-03-17 08:30:00	AAPL	Stock	62.0375	62.2	61.75	62.15	331448.0
2020-03-17 09:00:00	AAPL	Stock	62.1475	62.25	61.6275	61.875	692128.0
2020-03-17 09:30:00	AAPL	Stock	61.8725	62.3725	59.7475	60.095	39057160.0
2020-03-17 10:00:00	AAPL	Stock	60.115	61.295	59.6	61.1875	25669456.0
2020-03-17 10:30:00	AAPL	Stock	61.19	62.82	61.115	62.58	23085344.0
2020-03-17 11:00:00	AAPL	Stock	62.5722	63.5475	62.4325	62.925	19680256.0
2020-03-17 11:30:00	AAPL	Stock	62.925	63.6875	62.1675	63.6175	16074180.0
2020-03-17 12:00:00	AAPL	Stock	63.6075	64.4025	63.143	63.213	20300960.0
2020-03-17 12:30:00	AAPL	Stock	63.2325	63.595	62.4025	63.147	13079096.0
2020-03-17 13:00:00	AAPL	Stock	63.17	63.4775	62.015	62.58	10781928.0
2020-03-17 13:30:00	AAPL	Stock	62.6175	63.525	62.425	63.3025	10677764.0
2020-03-17 14:00:00	AAPL	Stock	63.2975	64.0125	62.8425	63.7175	12468032.0
2020-03-17 14:30:00	AAPL	Stock	63.7375	64.0625	62.6525	63.28	12584848.0
2020-03-17 15:00:00	AAPL	Stock	63.28	63.28	62.0575	62.4512	13803852.0
2020-03-17 15:30:00	AAPL	Stock	62.4475	64.1375	62.3275	63.2125	28245356.0
2020-03-17 16:00:00	AAPL	Stock	63.2125	63.215	62.5	62.6	17487788.0
2020-03-17 16:30:00	AAPL	Stock	62.6	63.215	62.375	62.375	234092.0
2020-03-17 17:00:00	AAPL	Stock	62.3438	62.55	62.3438	62.3875	55468.0
2020-03-17 17:30:00	AAPL	Stock	62.4075	62.465	62.185	62.185	66384.0
2020-03-17 18:00:00	AAPL	Stock	63.215	63.215	62.13	62.3675	51368.0
2020-03-17 18:30:00	AAPL	Stock	62.375	62.5	61.97	62.1075	98876.0
2020-03-17 19:00:00	AAPL	Stock	62.075	62.075	61.6112	61.6525	96536.0
2020-03-17 19:30:00	AAPL	Stock	61.65	61.6738	61.0	61.0	175792.0
2020-03-17 04:00:00	MSFT	Stock	142.1	144.41	141.0	141.0	12406.0
2020-03-17 04:30:00	MSFT	Stock	141.9	142.5	139.6	139.6	4591.0
2020-03-17 05:00:00	MSFT	Stock	139.5	140.5	137.5	137.5	27804.0
2020-03-17 05:30:00	MSFT	Stock	137.28	137.51	135.8	137.19	27099.0
2020-03-17 06:00:00	MSFT	Stock	137.79	140.19	137.79	139.7	9322.0
2020-03-17 06:30:00	MSFT	Stock	140.44	141.0	138.5	140.84	6464.0
2020-03-17 07:00:00	MSFT	Stock	141.21	141.3	139.51	139.51	52685.0
2020-03-17 07:30:00	MSFT	Stock	139.5	139.51	137.42	137.76	62064.0
2020-03-17 08:00:00	MSFT	Stock	137.49	141.0	137.39	138.5	144438.0
2020-03-17 08:30:00	MSFT	Stock	138.7	138.86	137.65	138.5	87003.0
2020-03-17 09:00:00	MSFT	Stock	138.62	140.2	138.0	140.2	182786.0
2020-03-17 09:30:00	MSFT	Stock	140.0	141.46	135.42	136.305	8371416.0
2020-03-17 10:00:00	MSFT	Stock	136.34	139.31	135.0	138.95	4952472.0
2020-03-17 10:30:00	MSFT	Stock	138.98	142.98	138.71	142.11	5718061.0
2020-03-17 11:00:00	MSFT	Stock	142.08	146.0	142.0	143.17	5264760.0
2020-03-17 11:30:00	MSFT	Stock	143.174	145.69	142.235	145.52	3869508.0
2020-03-17 12:00:00	MSFT	Stock	145.5	147.5	144.22	144.32	4370345.0
2020-03-17 12:30:00	MSFT	Stock	144.37	145.68	141.39	143.269	3331961.0

> showing 50 of 95,218 rows — these rows as CSV

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