PREVIEW / stock_30min / 2020-07-30

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-07-30.parquet
  size:    2.0 MB
  rows:    99,178
  symbols: 2,436

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-30 04:00:00	AAPL	Stock	94.125	94.25	94.125	94.1875	8692.0
2020-07-30 04:30:00	AAPL	Stock	93.775	93.775	93.775	93.775	400.0
2020-07-30 05:00:00	AAPL	Stock	93.775	93.9975	93.775	93.92	12704.0
2020-07-30 05:30:00	AAPL	Stock	93.975	94.5	93.975	94.395	40320.0
2020-07-30 06:00:00	AAPL	Stock	94.375	94.375	94.1325	94.1575	11548.0
2020-07-30 06:30:00	AAPL	Stock	94.1325	94.25	93.625	93.795	55416.0
2020-07-30 07:00:00	AAPL	Stock	93.915	94.2375	93.795	93.97	180984.0
2020-07-30 07:30:00	AAPL	Stock	93.945	94.4	93.9025	94.25	242780.0
2020-07-30 08:00:00	AAPL	Stock	94.17	94.425	93.8125	94.4222	261956.0
2020-07-30 08:30:00	AAPL	Stock	94.375	94.5	93.8625	93.875	385308.0
2020-07-30 09:00:00	AAPL	Stock	93.8825	94.2825	93.7275	94.2625	361836.0
2020-07-30 09:30:00	AAPL	Stock	94.185	95.045	93.815	93.99	11712952.0
2020-07-30 10:00:00	AAPL	Stock	93.9825	94.3925	93.7675	94.2	7064348.0
2020-07-30 10:30:00	AAPL	Stock	94.1975	94.675	94.1175	94.6038	6044656.0
2020-07-30 11:00:00	AAPL	Stock	94.5875	94.9575	94.5025	94.715	5671056.0
2020-07-30 11:30:00	AAPL	Stock	94.72	95.3675	94.67	95.1963	5872872.0
2020-07-30 12:00:00	AAPL	Stock	95.1975	95.965	95.1975	95.7338	7844764.0
2020-07-30 12:30:00	AAPL	Stock	95.7375	95.95	95.4075	95.4775	5303400.0
2020-07-30 13:00:00	AAPL	Stock	95.4725	95.7625	95.4125	95.6485	4822856.0
2020-07-30 13:30:00	AAPL	Stock	95.6488	95.73	95.225	95.715	4850472.0
2020-07-30 14:00:00	AAPL	Stock	95.715	95.8375	95.435	95.6875	5157536.0
2020-07-30 14:30:00	AAPL	Stock	95.685	96.1375	95.6645	96.04	6216036.0
2020-07-30 15:00:00	AAPL	Stock	96.035	96.1225	95.6225	96.0375	7696168.0
2020-07-30 15:30:00	AAPL	Stock	96.035	96.2975	95.89	96.22	12137736.0
2020-07-30 16:00:00	AAPL	Stock	96.19	97.5	96.0	97.365	5161156.0
2020-07-30 16:30:00	AAPL	Stock	97.4625	101.9625	97.4475	100.725	15626360.0
2020-07-30 17:00:00	AAPL	Stock	100.725	101.625	100.65	101.525	3953748.0
2020-07-30 17:30:00	AAPL	Stock	101.525	102.2375	101.525	102.0875	2164944.0
2020-07-30 18:00:00	AAPL	Stock	102.1125	102.21	101.63	101.835	976432.0
2020-07-30 18:30:00	AAPL	Stock	101.835	101.975	101.625	101.9375	539428.0
2020-07-30 19:00:00	AAPL	Stock	101.9375	102.1875	101.8375	102.15	512844.0
2020-07-30 19:30:00	AAPL	Stock	102.13	102.4	102.0275	102.3875	589820.0
2020-07-30 04:00:00	MSFT	Stock	202.44	202.44	202.17	202.17	1417.0
2020-07-30 04:30:00	MSFT	Stock	201.68	201.84	201.1	201.1	2585.0
2020-07-30 05:00:00	MSFT	Stock	201.1	201.59	201.0	201.59	3267.0
2020-07-30 05:30:00	MSFT	Stock	201.33	202.25	201.33	202.25	1056.0
2020-07-30 06:00:00	MSFT	Stock	202.1	202.1	201.9	202.0	3373.0
2020-07-30 06:30:00	MSFT	Stock	201.55	201.55	200.15	200.91	13867.0
2020-07-30 07:00:00	MSFT	Stock	200.9	201.87	200.9	201.55	79028.0
2020-07-30 07:30:00	MSFT	Stock	201.51	202.44	201.25	202.13	19075.0
2020-07-30 08:00:00	MSFT	Stock	201.45	204.57	201.05	202.0	37523.0
2020-07-30 08:30:00	MSFT	Stock	201.97	202.38	200.58	200.756	83574.0
2020-07-30 09:00:00	MSFT	Stock	200.85	201.49	200.5	200.98	73248.0
2020-07-30 09:30:00	MSFT	Stock	200.97	202.14	199.78	200.02	3811177.0
2020-07-30 10:00:00	MSFT	Stock	200.06	200.57	199.57	200.28	2443080.0
2020-07-30 10:30:00	MSFT	Stock	200.27	201.27	200.12	201.23	1568319.0
2020-07-30 11:00:00	MSFT	Stock	201.2	202.19	200.94	201.96	1405550.0
2020-07-30 11:30:00	MSFT	Stock	201.94	203.07	201.9	202.88	1275740.0
2020-07-30 12:00:00	MSFT	Stock	202.87	204.01	202.62	203.285	1570368.0
2020-07-30 12:30:00	MSFT	Stock	203.33	203.63	203.07	203.457	578742.0

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

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