PREVIEW / etf_30min / 2021-11-03

all etf 30-min files

  file:    by_date/etf_30min/2021/2021-11-03.parquet
  size:    640 KB
  rows:    24,582

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
2021-11-03 04:00:00	SPY	ETF	461.4	461.81	461.4	461.81	3522.0
2021-11-03 04:30:00	SPY	ETF	461.77	461.78	461.64	461.71	1113.0
2021-11-03 05:00:00	SPY	ETF	461.68	461.91	461.68	461.71	4447.0
2021-11-03 05:30:00	SPY	ETF	461.72	461.76	461.61	461.71	2869.0
2021-11-03 06:00:00	SPY	ETF	461.7	461.71	461.44	461.59	4780.0
2021-11-03 06:30:00	SPY	ETF	461.57	461.57	461.42	461.42	10841.0
2021-11-03 07:00:00	SPY	ETF	461.56	461.56	461.33	461.55	22157.0
2021-11-03 07:30:00	SPY	ETF	461.6	461.66	461.5	461.59	25189.0
2021-11-03 08:00:00	SPY	ETF	461.4	461.72	461.35	461.38	60248.0
2021-11-03 08:30:00	SPY	ETF	461.41	461.41	461.16	461.21	108644.0
2021-11-03 09:00:00	SPY	ETF	461.21	461.38	461.0	461.31	108133.0
2021-11-03 09:30:00	SPY	ETF	461.3	461.58	460.8338	461.39	3466349.0
2021-11-03 10:00:00	SPY	ETF	461.47	461.67	460.83	461.26	2125837.0
2021-11-03 10:30:00	SPY	ETF	461.25	461.56	461.08	461.45	1470101.0
2021-11-03 11:00:00	SPY	ETF	461.45	461.495	461.11	461.185	1190290.0
2021-11-03 11:30:00	SPY	ETF	461.19	461.5	461.04	461.4201	855097.0
2021-11-03 12:00:00	SPY	ETF	461.426	461.53	461.2	461.37	852826.0
2021-11-03 12:30:00	SPY	ETF	461.38	461.51	461.2	461.31	722931.0
2021-11-03 13:00:00	SPY	ETF	461.305	461.31	461.07	461.295	719169.0
2021-11-03 13:30:00	SPY	ETF	461.29	461.4196	460.96	461.135	1429568.0
2021-11-03 14:00:00	SPY	ETF	461.13	462.72	460.86	462.35	5383350.0
2021-11-03 14:30:00	SPY	ETF	462.363	464.23	462.04	463.94	4945286.0
2021-11-03 15:00:00	SPY	ETF	463.92	464.43	463.72	464.2318	3844995.0
2021-11-03 15:30:00	SPY	ETF	464.24	465.15	464.13	464.74	9105580.0
2021-11-03 16:00:00	SPY	ETF	464.74	464.75	464.41	464.62	3503898.0
2021-11-03 16:30:00	SPY	ETF	464.61	464.72	464.5	464.7	165816.0
2021-11-03 17:00:00	SPY	ETF	464.71	464.81	464.66	464.8	257119.0
2021-11-03 17:30:00	SPY	ETF	464.73	464.82	464.72	464.72	45881.0
2021-11-03 18:00:00	SPY	ETF	464.72	465.09	464.71	464.96	80168.0
2021-11-03 18:30:00	SPY	ETF	464.72	465.12	464.72	465.07	18276.0
2021-11-03 19:00:00	SPY	ETF	465.07	465.5	465.07	465.29	41697.0
2021-11-03 19:30:00	SPY	ETF	465.21	465.46	465.17	465.46	22812.0
2021-11-03 04:00:00	QQQ	ETF	389.06	389.43	389.06	389.32	22064.0
2021-11-03 04:30:00	QQQ	ETF	389.31	389.33	389.18	389.33	8579.0
2021-11-03 05:00:00	QQQ	ETF	389.32	389.7	389.32	389.44	19078.0
2021-11-03 05:30:00	QQQ	ETF	389.51	389.51	389.43	389.5	2904.0
2021-11-03 06:00:00	QQQ	ETF	389.51	389.64	389.36	389.46	4570.0
2021-11-03 06:30:00	QQQ	ETF	389.49	389.49	389.08	389.29	195406.0
2021-11-03 07:00:00	QQQ	ETF	389.27	389.39	389.17	389.37	112940.0
2021-11-03 07:30:00	QQQ	ETF	389.39	389.67	389.39	389.54	41737.0
2021-11-03 08:00:00	QQQ	ETF	389.39	389.7	388.95	389.43	56759.0
2021-11-03 08:30:00	QQQ	ETF	389.47	389.53	389.23	389.48	60722.0
2021-11-03 09:00:00	QQQ	ETF	389.46	389.7	389.34	389.52	97104.0
2021-11-03 09:30:00	QQQ	ETF	389.53	389.95	388.65	389.29	3330409.0
2021-11-03 10:00:00	QQQ	ETF	389.32	389.43	388.48	388.9979	1961722.0
2021-11-03 10:30:00	QQQ	ETF	389.01	389.23	388.55	389.0401	1099467.0
2021-11-03 11:00:00	QQQ	ETF	389.05	389.2513	388.66	389.12	718957.0
2021-11-03 11:30:00	QQQ	ETF	389.1199	389.64	388.62	389.61	765444.0
2021-11-03 12:00:00	QQQ	ETF	389.6	389.62	389.24	389.48	664690.0
2021-11-03 12:30:00	QQQ	ETF	389.49	389.71	389.34	389.46	617028.0

> showing 50 of 24,582 rows — these rows as CSV

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