PREVIEW / stock_30min / 2020-06-12

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-06-12.parquet
  size:    1.9 MB
  rows:    99,494
  symbols: 2,412

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-06-12 04:00:00	AAPL	Stock	85.25	85.725	85.245	85.725	35848.0
2020-06-12 04:30:00	AAPL	Stock	85.67	85.9775	85.67	85.9	15816.0
2020-06-12 05:00:00	AAPL	Stock	85.9	85.9475	85.7175	85.7175	24960.0
2020-06-12 05:30:00	AAPL	Stock	85.66	85.8875	85.66	85.8875	9460.0
2020-06-12 06:00:00	AAPL	Stock	85.91	85.95	85.8125	85.8275	20836.0
2020-06-12 06:30:00	AAPL	Stock	85.8425	85.8425	85.2925	85.625	56524.0
2020-06-12 07:00:00	AAPL	Stock	85.5875	85.9375	85.5	85.8	326180.0
2020-06-12 07:30:00	AAPL	Stock	85.795	85.9175	85.675	85.7375	111432.0
2020-06-12 08:00:00	AAPL	Stock	85.675	85.9325	85.2857	85.53	405984.0
2020-06-12 08:30:00	AAPL	Stock	85.57	86.0625	85.57	85.9175	277800.0
2020-06-12 09:00:00	AAPL	Stock	85.875	86.25	85.875	86.1875	786304.0
2020-06-12 09:30:00	AAPL	Stock	86.175	86.95	85.805	86.6288	20301952.0
2020-06-12 10:00:00	AAPL	Stock	86.6275	86.8	85.58	85.585	9948052.0
2020-06-12 10:30:00	AAPL	Stock	85.5825	85.6975	84.2952	84.3075	12082460.0
2020-06-12 11:00:00	AAPL	Stock	84.315	84.855	83.7977	84.44	14702728.0
2020-06-12 11:30:00	AAPL	Stock	84.4425	85.595	84.29	85.57	12706584.0
2020-06-12 12:00:00	AAPL	Stock	85.5725	85.8625	85.2728	85.354	9564196.0
2020-06-12 12:30:00	AAPL	Stock	85.3425	85.3875	84.715	85.1928	7480072.0
2020-06-12 13:00:00	AAPL	Stock	85.2	85.2325	84.435	84.5375	6656420.0
2020-06-12 13:30:00	AAPL	Stock	84.5325	84.645	83.5558	83.6925	11958696.0
2020-06-12 14:00:00	AAPL	Stock	83.6875	84.2725	83.5775	84.215	9263824.0
2020-06-12 14:30:00	AAPL	Stock	84.2278	84.825	84.1792	84.7775	10977588.0
2020-06-12 15:00:00	AAPL	Stock	84.755	85.0	84.155	84.245	10192640.0
2020-06-12 15:30:00	AAPL	Stock	84.2425	85.25	84.055	84.6325	14479376.0
2020-06-12 16:00:00	AAPL	Stock	84.635	85.0138	84.5025	84.67	9608008.0
2020-06-12 16:30:00	AAPL	Stock	84.675	84.7	84.575	84.5825	80968.0
2020-06-12 17:00:00	AAPL	Stock	84.6425	84.6425	84.5	84.56	23420.0
2020-06-12 17:30:00	AAPL	Stock	84.5575	84.6875	84.5075	84.55	14148.0
2020-06-12 18:00:00	AAPL	Stock	84.575	84.645	84.54	84.58	37572.0
2020-06-12 18:30:00	AAPL	Stock	84.6	84.645	84.58	84.6175	55856.0
2020-06-12 19:00:00	AAPL	Stock	84.6175	84.685	84.6025	84.685	3396.0
2020-06-12 19:30:00	AAPL	Stock	84.6875	84.7	84.5325	84.6	32568.0
2020-06-12 04:00:00	MSFT	Stock	189.38	189.58	189.22	189.22	1995.0
2020-06-12 04:30:00	MSFT	Stock	189.55	190.0	189.3	190.0	4571.0
2020-06-12 05:00:00	MSFT	Stock	190.14	190.2	189.7	190.03	2133.0
2020-06-12 05:30:00	MSFT	Stock	190.34	190.97	190.17	190.92	2959.0
2020-06-12 06:00:00	MSFT	Stock	190.6	191.0	190.6	190.85	4283.0
2020-06-12 06:30:00	MSFT	Stock	190.43	190.43	190.0	190.08	3088.0
2020-06-12 07:00:00	MSFT	Stock	190.27	190.72	189.68	190.1	47617.0
2020-06-12 07:30:00	MSFT	Stock	190.0	190.28	189.63	189.93	34524.0
2020-06-12 08:00:00	MSFT	Stock	190.0	190.5	189.0	189.5	124349.0
2020-06-12 08:30:00	MSFT	Stock	189.55	189.94	187.3	189.83	122078.0
2020-06-12 09:00:00	MSFT	Stock	189.773	190.74	189.77	190.49	99078.0
2020-06-12 09:30:00	MSFT	Stock	190.5	191.72	189.86	190.93	4554263.0
2020-06-12 10:00:00	MSFT	Stock	190.94	191.27	189.82	190.07	2098806.0
2020-06-12 10:30:00	MSFT	Stock	190.068	190.48	187.96	188.065	2329608.0
2020-06-12 11:00:00	MSFT	Stock	188.04	188.5	187.0	188.08	2684600.0
2020-06-12 11:30:00	MSFT	Stock	188.1	189.98	187.75	189.83	2114888.0
2020-06-12 12:00:00	MSFT	Stock	189.838	190.19	188.44	189.0	1776761.0
2020-06-12 12:30:00	MSFT	Stock	188.98	189.05	188.06	188.939	1532433.0

> showing 50 of 99,494 rows — these rows as CSV

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