PREVIEW / stock_30min / 2020-06-24

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-06-24.parquet
  size:    2.0 MB
  rows:    98,822
  symbols: 2,447

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-24 04:00:00	AAPL	Stock	91.425	91.55	90.875	91.1925	44228.0
2020-06-24 04:30:00	AAPL	Stock	91.035	91.2	91.0	91.1825	4408.0
2020-06-24 05:00:00	AAPL	Stock	91.1725	91.3	90.65	90.825	42532.0
2020-06-24 05:30:00	AAPL	Stock	90.9925	91.0875	90.9925	91.0	7940.0
2020-06-24 06:00:00	AAPL	Stock	91.115	91.1225	90.9525	91.0	22624.0
2020-06-24 06:30:00	AAPL	Stock	91.01	91.1425	91.01	91.125	14380.0
2020-06-24 07:00:00	AAPL	Stock	91.0525	91.3	91.0325	91.3	151864.0
2020-06-24 07:30:00	AAPL	Stock	91.2875	91.3	91.1125	91.1375	187748.0
2020-06-24 08:00:00	AAPL	Stock	91.1725	91.6212	91.04	91.602	484228.0
2020-06-24 08:30:00	AAPL	Stock	91.6025	91.75	91.35	91.715	255476.0
2020-06-24 09:00:00	AAPL	Stock	91.7125	91.7375	91.0	91.265	630492.0
2020-06-24 09:30:00	AAPL	Stock	91.2625	92.1975	90.775	90.8675	24426580.0
2020-06-24 10:00:00	AAPL	Stock	90.8725	91.3725	90.57	91.2975	13900744.0
2020-06-24 10:30:00	AAPL	Stock	91.2875	91.3025	90.6425	90.7512	11598264.0
2020-06-24 11:00:00	AAPL	Stock	90.74	91.02	90.115	90.4825	13197892.0
2020-06-24 11:30:00	AAPL	Stock	90.4825	90.5475	89.63	89.995	12094344.0
2020-06-24 12:00:00	AAPL	Stock	89.98	90.4175	89.7925	90.395	9270908.0
2020-06-24 12:30:00	AAPL	Stock	90.3958	90.8123	90.1125	90.724	8107004.0
2020-06-24 13:00:00	AAPL	Stock	90.72	90.9555	90.4625	90.5	9363672.0
2020-06-24 13:30:00	AAPL	Stock	90.495	90.55	90.0375	90.2625	7237204.0
2020-06-24 14:00:00	AAPL	Stock	90.255	90.4775	89.8225	90.435	8580056.0
2020-06-24 14:30:00	AAPL	Stock	90.431	90.525	89.9175	89.9562	8058196.0
2020-06-24 15:00:00	AAPL	Stock	89.965	90.5925	89.965	90.305	9109812.0
2020-06-24 15:30:00	AAPL	Stock	90.3062	90.4725	89.875	90.015	12032672.0
2020-06-24 16:00:00	AAPL	Stock	90.015	90.1725	89.9875	90.1325	8138884.0
2020-06-24 16:30:00	AAPL	Stock	90.12	90.15	90.025	90.135	75100.0
2020-06-24 17:00:00	AAPL	Stock	90.1375	90.17	90.05	90.0625	32440.0
2020-06-24 17:30:00	AAPL	Stock	90.07	90.1125	90.0425	90.1125	20488.0
2020-06-24 18:00:00	AAPL	Stock	90.0625	90.2	90.0	90.0525	80108.0
2020-06-24 18:30:00	AAPL	Stock	90.075	90.075	90.0	90.0	21788.0
2020-06-24 19:00:00	AAPL	Stock	89.975	90.0	89.75	89.7625	52776.0
2020-06-24 19:30:00	AAPL	Stock	89.8175	89.8375	89.65	89.7375	95356.0
2020-06-24 04:00:00	MSFT	Stock	201.49	201.78	201.32	201.32	2077.0
2020-06-24 04:30:00	MSFT	Stock	201.04	201.21	200.86	201.2	2152.0
2020-06-24 05:00:00	MSFT	Stock	201.21	201.21	200.2	200.2	4298.0
2020-06-24 05:30:00	MSFT	Stock	200.56	200.92	200.42	200.92	1115.0
2020-06-24 06:30:00	MSFT	Stock	200.92	201.2	200.92	201.2	1996.0
2020-06-24 07:00:00	MSFT	Stock	201.0	201.5	200.95	201.0	22221.0
2020-06-24 07:30:00	MSFT	Stock	201.17	201.49	200.74	201.22	12131.0
2020-06-24 08:00:00	MSFT	Stock	201.029	202.0	200.74	201.69	35177.0
2020-06-24 08:30:00	MSFT	Stock	201.86	201.86	201.05	201.6	14345.0
2020-06-24 09:00:00	MSFT	Stock	201.6	202.0	201.5	201.91	43640.0
2020-06-24 09:30:00	MSFT	Stock	201.79	203.25	199.78	200.14	3944562.0
2020-06-24 10:00:00	MSFT	Stock	200.08	200.76	199.41	200.76	2306775.0
2020-06-24 10:30:00	MSFT	Stock	200.74	200.745	198.74	199.345	2666411.0
2020-06-24 11:00:00	MSFT	Stock	199.33	199.67	197.61	198.51	2378298.0
2020-06-24 11:30:00	MSFT	Stock	198.525	198.708	196.73	197.46	2005989.0
2020-06-24 12:00:00	MSFT	Stock	197.46	198.178	196.62	198.06	1538167.0
2020-06-24 12:30:00	MSFT	Stock	198.067	198.75	197.525	198.66	1460826.0
2020-06-24 13:00:00	MSFT	Stock	198.65	199.0	197.86	197.965	1208567.0

> showing 50 of 98,822 rows — these rows as CSV

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