PREVIEW / stock_30min / 2020-07-20

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-07-20.parquet
  size:    1.9 MB
  rows:    97,448
  symbols: 2,443

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-07-20 04:00:00	AAPL	Stock	95.8	95.8	95.75	95.75	3156.0
2020-07-20 04:30:00	AAPL	Stock	95.75	96.12	95.75	96.095	18168.0
2020-07-20 05:00:00	AAPL	Stock	96.1975	96.3775	96.055	96.2375	22700.0
2020-07-20 05:30:00	AAPL	Stock	96.24	96.25	96.24	96.25	1008.0
2020-07-20 06:00:00	AAPL	Stock	96.185	96.1925	96.185	96.1925	1376.0
2020-07-20 06:30:00	AAPL	Stock	96.22	96.22	96.22	96.22	800.0
2020-07-20 07:00:00	AAPL	Stock	96.25	96.4225	96.2125	96.4175	62092.0
2020-07-20 07:30:00	AAPL	Stock	96.405	96.475	96.2525	96.38	46400.0
2020-07-20 08:00:00	AAPL	Stock	96.2505	96.4625	96.195	96.34	158916.0
2020-07-20 08:30:00	AAPL	Stock	96.34	96.64	96.3375	96.5	141656.0
2020-07-20 09:00:00	AAPL	Stock	96.48	96.6418	96.355	96.3975	176616.0
2020-07-20 09:30:00	AAPL	Stock	96.4162	96.5575	96.0625	96.37	8355392.0
2020-07-20 10:00:00	AAPL	Stock	96.3625	97.1075	96.205	96.9375	7750504.0
2020-07-20 10:30:00	AAPL	Stock	96.945	97.06	96.83	96.9625	4858672.0
2020-07-20 11:00:00	AAPL	Stock	96.97	97.43	96.9075	97.3425	5900732.0
2020-07-20 11:30:00	AAPL	Stock	97.3525	97.645	97.2675	97.4578	4338440.0
2020-07-20 12:00:00	AAPL	Stock	97.4575	97.5275	97.18	97.1933	3077124.0
2020-07-20 12:30:00	AAPL	Stock	97.1925	97.565	97.19	97.485	2924748.0
2020-07-20 13:00:00	AAPL	Stock	97.4842	97.5625	97.3675	97.5387	1850796.0
2020-07-20 13:30:00	AAPL	Stock	97.5425	97.7125	97.435	97.5805	3273168.0
2020-07-20 14:00:00	AAPL	Stock	97.5805	97.725	97.565	97.7	2281656.0
2020-07-20 14:30:00	AAPL	Stock	97.7	97.76	97.5575	97.7432	3078112.0
2020-07-20 15:00:00	AAPL	Stock	97.745	98.125	97.745	98.12	5158412.0
2020-07-20 15:30:00	AAPL	Stock	98.1162	98.5	98.1125	98.3575	9329124.0
2020-07-20 16:00:00	AAPL	Stock	98.3575	98.3875	98.3325	98.36	8024880.0
2020-07-20 16:30:00	AAPL	Stock	98.3575	98.37	98.25	98.37	60776.0
2020-07-20 17:00:00	AAPL	Stock	98.375	98.375	98.3	98.325	27628.0
2020-07-20 17:30:00	AAPL	Stock	98.325	98.385	98.275	98.35	34484.0
2020-07-20 18:00:00	AAPL	Stock	98.385	98.4625	98.375	98.425	21816.0
2020-07-20 18:30:00	AAPL	Stock	98.425	98.425	98.2775	98.28	39872.0
2020-07-20 19:00:00	AAPL	Stock	98.2875	98.3625	98.28	98.3375	27072.0
2020-07-20 19:30:00	AAPL	Stock	98.375	98.5	98.375	98.45	61276.0
2020-07-20 04:00:00	MSFT	Stock	202.7	202.7	202.35	202.58	1991.0
2020-07-20 04:30:00	MSFT	Stock	202.63	203.85	202.63	203.85	3056.0
2020-07-20 05:00:00	MSFT	Stock	203.85	204.6	203.85	203.96	9298.0
2020-07-20 05:30:00	MSFT	Stock	203.96	204.41	203.89	204.36	5438.0
2020-07-20 06:00:00	MSFT	Stock	204.36	204.39	204.15	204.3	4539.0
2020-07-20 06:30:00	MSFT	Stock	204.22	204.5	203.99	204.5	6683.0
2020-07-20 07:00:00	MSFT	Stock	204.49	204.66	204.05	204.62	64179.0
2020-07-20 07:30:00	MSFT	Stock	204.64	205.21	204.53	205.02	43343.0
2020-07-20 08:00:00	MSFT	Stock	205.13	205.22	203.38	204.95	91612.0
2020-07-20 08:30:00	MSFT	Stock	204.911	205.22	204.85	205.22	39234.0
2020-07-20 09:00:00	MSFT	Stock	205.22	205.38	205.0	205.01	62959.0
2020-07-20 09:30:00	MSFT	Stock	205.0	206.03	203.01	205.77	4453710.0
2020-07-20 10:00:00	MSFT	Stock	205.78	207.16	205.05	206.94	2933158.0
2020-07-20 10:30:00	MSFT	Stock	206.95	207.01	205.87	206.78	1757165.0
2020-07-20 11:00:00	MSFT	Stock	206.775	207.66	206.41	207.54	1294836.0
2020-07-20 11:30:00	MSFT	Stock	207.57	208.57	207.46	208.56	1746094.0
2020-07-20 12:00:00	MSFT	Stock	208.57	208.74	207.84	208.073	1641171.0
2020-07-20 12:30:00	MSFT	Stock	208.07	208.67	207.8	208.49	1123271.0

> showing 50 of 97,448 rows — these rows as CSV

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