PREVIEW / etf_30min / 2022-07-26

all etf 30-min files

  file:    by_date/etf_30min/2022/2022-07-26.parquet
  size:    634 KB
  rows:    24,555

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
2022-07-26 04:00:00	SPY	ETF	394.88	394.88	394.21	394.5	32061.0
2022-07-26 04:30:00	SPY	ETF	394.5	394.72	394.5	394.62	7207.0
2022-07-26 05:00:00	SPY	ETF	394.63	395.0	394.41	394.41	36057.0
2022-07-26 05:30:00	SPY	ETF	394.38	394.8	394.2	394.74	47255.0
2022-07-26 06:00:00	SPY	ETF	394.65	394.86	393.73	394.0	128397.0
2022-07-26 06:30:00	SPY	ETF	393.95	394.27	393.65	394.09	88380.0
2022-07-26 07:00:00	SPY	ETF	394.1	394.31	393.78	394.25	158613.0
2022-07-26 07:30:00	SPY	ETF	394.19	394.41	394.0	394.0	94663.0
2022-07-26 08:00:00	SPY	ETF	394.2	394.54	393.6904	394.17	104713.0
2022-07-26 08:30:00	SPY	ETF	394.2	394.51	393.55	394.0	255430.0
2022-07-26 09:00:00	SPY	ETF	393.97	394.23	393.08	393.87	767376.0
2022-07-26 09:30:00	SPY	ETF	393.84	394.06	392.42	393.24	4613352.0
2022-07-26 10:00:00	SPY	ETF	393.24	393.75	392.29	392.5574	2800866.0
2022-07-26 10:30:00	SPY	ETF	392.53	392.94	392.13	392.8724	2401597.0
2022-07-26 11:00:00	SPY	ETF	392.88	393.09	391.28	391.36	2475822.0
2022-07-26 11:30:00	SPY	ETF	391.36	391.51	390.51	390.62	3090057.0
2022-07-26 12:00:00	SPY	ETF	390.61	391.35	390.42	391.2318	2479694.0
2022-07-26 12:30:00	SPY	ETF	391.26	391.79	390.89	391.6	2160307.0
2022-07-26 13:00:00	SPY	ETF	391.62	392.38	391.45	392.19	2396484.0
2022-07-26 13:30:00	SPY	ETF	392.19	392.28	391.23	391.27	1306435.0
2022-07-26 14:00:00	SPY	ETF	391.275	392.34	390.53	390.575	2217506.0
2022-07-26 14:30:00	SPY	ETF	390.58	390.8	390.22	390.7301	2070858.0
2022-07-26 15:00:00	SPY	ETF	390.74	390.96	389.95	390.775	2965715.0
2022-07-26 15:30:00	SPY	ETF	390.78	391.51	390.29	390.91	6519120.0
2022-07-26 16:00:00	SPY	ETF	390.91	392.71	390.14	391.8	2775163.0
2022-07-26 16:30:00	SPY	ETF	391.9	392.51	390.89	392.51	329842.0
2022-07-26 17:00:00	SPY	ETF	392.51	392.58	392.07	392.3	77536.0
2022-07-26 17:30:00	SPY	ETF	392.3	392.52	392.1	392.5	44391.0
2022-07-26 18:00:00	SPY	ETF	392.5	394.42	392.5	393.62	236171.0
2022-07-26 18:30:00	SPY	ETF	393.62	393.89	393.05	393.25	76867.0
2022-07-26 19:00:00	SPY	ETF	393.27	393.6	393.17	393.6	48687.0
2022-07-26 19:30:00	SPY	ETF	393.75	395.23	393.65	394.06	58710.0
2022-07-26 04:00:00	QQQ	ETF	298.9	299.68	298.9	299.34	38138.0
2022-07-26 04:30:00	QQQ	ETF	299.34	299.5	299.32	299.41	15933.0
2022-07-26 05:00:00	QQQ	ETF	299.45	299.67	299.45	299.47	19018.0
2022-07-26 05:30:00	QQQ	ETF	299.31	299.68	299.29	299.63	10849.0
2022-07-26 06:00:00	QQQ	ETF	299.66	299.72	298.64	298.8	41414.0
2022-07-26 06:30:00	QQQ	ETF	298.9	299.14	298.5	298.99	29778.0
2022-07-26 07:00:00	QQQ	ETF	298.76	299.11	298.6	299.0	61506.0
2022-07-26 07:30:00	QQQ	ETF	298.95	299.34	298.76	298.8	103361.0
2022-07-26 08:00:00	QQQ	ETF	298.97	300.495	298.5796	299.0	107634.0
2022-07-26 08:30:00	QQQ	ETF	299.07	299.33	298.13	298.53	396963.0
2022-07-26 09:00:00	QQQ	ETF	298.55	298.91	297.82	298.51	357024.0
2022-07-26 09:30:00	QQQ	ETF	298.52	298.77	296.46	297.43	5629977.0
2022-07-26 10:00:00	QQQ	ETF	297.4	298.03	296.08	296.25	3102312.0
2022-07-26 10:30:00	QQQ	ETF	296.24	296.53	295.57	296.48	2122597.0
2022-07-26 11:00:00	QQQ	ETF	296.4899	296.66	295.23	295.29	1727465.0
2022-07-26 11:30:00	QQQ	ETF	295.28	295.37	294.385	294.4737	2158881.0
2022-07-26 12:00:00	QQQ	ETF	294.47	295.045	294.3	294.9982	1750039.0
2022-07-26 12:30:00	QQQ	ETF	294.995	295.402	294.44	295.11	1813920.0

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

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