PREVIEW / stock_30min / 2020-08-04

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-08-04.parquet
  size:    1.9 MB
  rows:    97,717
  symbols: 2,434

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-08-04 04:00:00	AAPL	Stock	108.805	108.805	108.29	108.55	19396.0
2020-08-04 04:30:00	AAPL	Stock	108.555	108.575	108.42	108.4275	8980.0
2020-08-04 05:00:00	AAPL	Stock	108.625	108.8675	108.625	108.7	11808.0
2020-08-04 05:30:00	AAPL	Stock	108.675	108.8125	108.675	108.8125	3296.0
2020-08-04 06:00:00	AAPL	Stock	108.785	108.7925	108.7275	108.7925	2160.0
2020-08-04 06:30:00	AAPL	Stock	108.75	108.85	108.7475	108.75	9800.0
2020-08-04 07:00:00	AAPL	Stock	108.75	109.33	108.735	109.025	192936.0
2020-08-04 07:30:00	AAPL	Stock	109.04	109.0575	108.575	108.67	134424.0
2020-08-04 08:00:00	AAPL	Stock	109.0882	109.33	108.5	108.8425	398120.0
2020-08-04 08:30:00	AAPL	Stock	108.8625	109.25	108.5625	109.1325	613016.0
2020-08-04 09:00:00	AAPL	Stock	109.1578	109.475	109.0	109.1125	563096.0
2020-08-04 09:30:00	AAPL	Stock	109.1325	109.845	108.3875	109.5275	22186332.0
2020-08-04 10:00:00	AAPL	Stock	109.52	110.79	109.44	110.46	17059436.0
2020-08-04 10:30:00	AAPL	Stock	110.4712	110.766	109.696	109.7125	16350368.0
2020-08-04 11:00:00	AAPL	Stock	109.72	110.08	109.375	109.615	11201832.0
2020-08-04 11:30:00	AAPL	Stock	109.6038	110.0275	109.5	109.9925	6389848.0
2020-08-04 12:00:00	AAPL	Stock	109.9988	110.125	109.52	109.8125	7896008.0
2020-08-04 12:30:00	AAPL	Stock	109.8125	110.075	109.6175	109.725	5427624.0
2020-08-04 13:00:00	AAPL	Stock	109.7275	109.955	109.6325	109.84	5075624.0
2020-08-04 13:30:00	AAPL	Stock	109.8412	110.1775	109.7658	110.0812	5262072.0
2020-08-04 14:00:00	AAPL	Stock	110.0875	110.14	109.4375	109.4575	6221012.0
2020-08-04 14:30:00	AAPL	Stock	109.45	109.46	108.99	109.3712	10711720.0
2020-08-04 15:00:00	AAPL	Stock	109.37	109.4925	109.115	109.3312	6713616.0
2020-08-04 15:30:00	AAPL	Stock	109.3375	109.7375	109.1375	109.7025	9208112.0
2020-08-04 16:00:00	AAPL	Stock	109.665	109.73	109.6525	109.676	5927696.0
2020-08-04 16:30:00	AAPL	Stock	109.7	109.725	109.55	109.7125	74104.0
2020-08-04 17:00:00	AAPL	Stock	109.7	109.7	109.6375	109.65	6996.0
2020-08-04 17:30:00	AAPL	Stock	109.6725	109.695	109.6375	109.665	13072.0
2020-08-04 18:00:00	AAPL	Stock	109.625	109.665	109.555	109.6	26224.0
2020-08-04 18:30:00	AAPL	Stock	109.6375	109.665	109.565	109.625	14240.0
2020-08-04 19:00:00	AAPL	Stock	109.6725	109.6875	109.625	109.6875	16716.0
2020-08-04 19:30:00	AAPL	Stock	109.665	109.7175	109.6025	109.6625	32716.0
2020-08-04 04:00:00	MSFT	Stock	215.6	215.6	215.0	215.2	7211.0
2020-08-04 04:30:00	MSFT	Stock	215.07	215.07	214.53	214.9	15103.0
2020-08-04 05:00:00	MSFT	Stock	214.82	215.4	214.73	215.3	4113.0
2020-08-04 05:30:00	MSFT	Stock	215.12	215.18	215.12	215.15	2479.0
2020-08-04 06:00:00	MSFT	Stock	215.13	215.22	214.6	214.81	7123.0
2020-08-04 06:30:00	MSFT	Stock	214.6	214.65	214.1	214.37	12941.0
2020-08-04 07:00:00	MSFT	Stock	214.3	214.65	213.71	214.02	97421.0
2020-08-04 07:30:00	MSFT	Stock	214.01	214.02	213.17	213.17	112606.0
2020-08-04 08:00:00	MSFT	Stock	214.258	216.54	212.8	213.11	171184.0
2020-08-04 08:30:00	MSFT	Stock	213.08	213.473	212.46	213.12	130760.0
2020-08-04 09:00:00	MSFT	Stock	213.13	214.88	212.81	214.24	290738.0
2020-08-04 09:30:00	MSFT	Stock	214.24	214.77	212.14	212.95	5686010.0
2020-08-04 10:00:00	MSFT	Stock	212.96	214.17	211.4	211.8	3701609.0
2020-08-04 10:30:00	MSFT	Stock	211.81	213.17	211.36	211.93	4062947.0
2020-08-04 11:00:00	MSFT	Stock	211.94	212.1	210.31	210.77	2901893.0
2020-08-04 11:30:00	MSFT	Stock	210.75	211.51	210.45	211.4	2199196.0
2020-08-04 12:00:00	MSFT	Stock	211.42	212.02	210.94	211.97	2087419.0
2020-08-04 12:30:00	MSFT	Stock	211.97	212.19	211.61	212.13	1462481.0

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

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