PREVIEW / etf_30min / 2023-12-20

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-12-20.parquet
  size:    814 KB
  rows:    32,829

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
2023-12-20 04:00:00	SPY	ETF	474.89	474.89	474.0	474.2	7202.0
2023-12-20 04:30:00	SPY	ETF	474.15	474.19	474.02	474.19	7214.0
2023-12-20 05:00:00	SPY	ETF	474.17	474.31	474.05	474.05	5949.0
2023-12-20 05:30:00	SPY	ETF	474.1	474.23	474.0	474.05	3209.0
2023-12-20 06:00:00	SPY	ETF	474.03	474.15	474.03	474.09	725.0
2023-12-20 06:30:00	SPY	ETF	474.06	474.19	473.84	473.96	17547.0
2023-12-20 07:00:00	SPY	ETF	474.01	474.05	473.74	474.05	22186.0
2023-12-20 07:30:00	SPY	ETF	474.03	474.14	473.8	473.84	39988.0
2023-12-20 08:00:00	SPY	ETF	473.83	475.2	473.78	474.08	75362.0
2023-12-20 08:30:00	SPY	ETF	474.0603	474.18	473.96	473.99	32942.0
2023-12-20 09:00:00	SPY	ETF	474.01	474.01	473.65	473.95	121197.0
2023-12-20 09:30:00	SPY	ETF	473.96	474.66	473.77	474.6201	4423959.0
2023-12-20 10:00:00	SPY	ETF	474.62	475.23	474.56	475.1301	2980515.0
2023-12-20 10:30:00	SPY	ETF	475.135	475.59	475.135	475.3599	2407518.0
2023-12-20 11:00:00	SPY	ETF	475.345	475.46	475.07	475.3018	1901543.0
2023-12-20 11:30:00	SPY	ETF	475.31	475.35	475.03	475.1719	1834466.0
2023-12-20 12:00:00	SPY	ETF	475.17	475.555	475.17	475.465	1398899.0
2023-12-20 12:30:00	SPY	ETF	475.47	475.895	475.091	475.795	1936039.0
2023-12-20 13:00:00	SPY	ETF	475.8	475.815	475.4997	475.57	1600602.0
2023-12-20 13:30:00	SPY	ETF	475.57	475.76	474.98	475.06	2393554.0
2023-12-20 14:00:00	SPY	ETF	475.06	475.1	474.535	474.571	3017675.0
2023-12-20 14:30:00	SPY	ETF	474.58	474.59	470.28	470.495	9946297.0
2023-12-20 15:00:00	SPY	ETF	470.49	471.1701	469.05	469.28	13984611.0
2023-12-20 15:30:00	SPY	ETF	469.28	470.14	467.82	467.97	19553620.0
2023-12-20 16:00:00	SPY	ETF	467.97	475.7201	467.36	468.1	5821113.0
2023-12-20 16:30:00	SPY	ETF	468.04	468.3	467.83	468.3	971570.0
2023-12-20 17:00:00	SPY	ETF	468.3	472.5085	468.26	468.37	2450575.0
2023-12-20 17:30:00	SPY	ETF	468.43	468.44	468.09	468.21	62144.0
2023-12-20 18:00:00	SPY	ETF	468.21	468.6535	468.21	468.63	89000.0
2023-12-20 18:30:00	SPY	ETF	468.591	468.94	468.591	468.86	30915.0
2023-12-20 19:00:00	SPY	ETF	468.9	468.9	467.91	468.74	259100.0
2023-12-20 19:30:00	SPY	ETF	468.66	468.87	468.66	468.73	61072.0
2023-12-20 04:00:00	QQQ	ETF	408.8	408.8	407.87	408.0	28025.0
2023-12-20 04:30:00	QQQ	ETF	407.97	408.18	407.88	408.16	12016.0
2023-12-20 05:00:00	QQQ	ETF	408.1	408.28	407.99	407.99	10805.0
2023-12-20 05:30:00	QQQ	ETF	408.1	408.23	408.0	408.15	6989.0
2023-12-20 06:00:00	QQQ	ETF	408.1	408.22	408.03	408.1	8819.0
2023-12-20 06:30:00	QQQ	ETF	408.13	408.25	407.86	408.12	12626.0
2023-12-20 07:00:00	QQQ	ETF	408.14	408.38	407.96	408.31	23930.0
2023-12-20 07:30:00	QQQ	ETF	408.34	408.34	408.04	408.05	48292.0
2023-12-20 08:00:00	QQQ	ETF	408.88	409.77	407.8996	408.21	93412.0
2023-12-20 08:30:00	QQQ	ETF	408.21	408.4	408.1	408.28	347111.0
2023-12-20 09:00:00	QQQ	ETF	408.28	408.4	408.12	408.35	181284.0
2023-12-20 09:30:00	QQQ	ETF	408.35	409.28	407.97	409.1101	2910994.0
2023-12-20 10:00:00	QQQ	ETF	409.12	410.0	408.98	409.96	2396961.0
2023-12-20 10:30:00	QQQ	ETF	409.95	410.4699	409.6	409.95	2517399.0
2023-12-20 11:00:00	QQQ	ETF	409.94	410.03	409.44	409.688	1549562.0
2023-12-20 11:30:00	QQQ	ETF	409.69	409.93	409.3801	409.67	1170600.0
2023-12-20 12:00:00	QQQ	ETF	409.68	410.03	409.67	409.74	991207.0
2023-12-20 12:30:00	QQQ	ETF	409.74	410.22	409.23	410.16	1261520.0

> showing 50 of 32,829 rows — these rows as CSV

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