PREVIEW / etf_30min / 2024-09-11

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-09-11.parquet
  size:    812 KB
  rows:    32,940

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
2024-09-11 04:00:00	SPY	ETF	546.52	547.92	546.52	547.77	7539.0
2024-09-11 04:30:00	SPY	ETF	547.64	547.64	546.73	546.75	19095.0
2024-09-11 05:00:00	SPY	ETF	546.85	547.3	546.55	546.76	34682.0
2024-09-11 05:30:00	SPY	ETF	546.89	547.55	546.89	547.55	6694.0
2024-09-11 06:00:00	SPY	ETF	547.59	547.69	547.14	547.29	2046.0
2024-09-11 06:30:00	SPY	ETF	547.32	547.69	547.32	547.69	2847.0
2024-09-11 07:00:00	SPY	ETF	547.61	547.75	547.4	547.71	41475.0
2024-09-11 07:30:00	SPY	ETF	547.73	548.35	547.72	548.24	60050.0
2024-09-11 08:00:00	SPY	ETF	547.53	548.54	546.1	548.54	107804.0
2024-09-11 08:30:00	SPY	ETF	548.58	548.58	545.53	548.06	852386.0
2024-09-11 09:00:00	SPY	ETF	548.14	549.34	548.14	548.7	381820.0
2024-09-11 09:30:00	SPY	ETF	548.7	548.76	544.51	544.69	4181327.0
2024-09-11 10:00:00	SPY	ETF	544.69	544.78	541.14	541.2425	4539864.0
2024-09-11 10:30:00	SPY	ETF	541.235	541.37	539.96	541.16	3927006.0
2024-09-11 11:00:00	SPY	ETF	541.12	542.9	540.56	542.43	3278706.0
2024-09-11 11:30:00	SPY	ETF	542.43	545.28	542.31	544.5	3311046.0
2024-09-11 12:00:00	SPY	ETF	544.48	546.82	544.27	546.78	3070491.0
2024-09-11 12:30:00	SPY	ETF	546.7801	547.55	546.51	547.3113	1747829.0
2024-09-11 13:00:00	SPY	ETF	547.34	549.19	547.34	548.89	2574964.0
2024-09-11 13:30:00	SPY	ETF	548.9	550.82	548.8202	550.0	2782743.0
2024-09-11 14:00:00	SPY	ETF	549.98	551.14	549.7	551.0075	2120200.0
2024-09-11 14:30:00	SPY	ETF	551.0	552.69	550.98	551.67	3672362.0
2024-09-11 15:00:00	SPY	ETF	551.65	553.41	551.24	553.33	3148789.0
2024-09-11 15:30:00	SPY	ETF	553.325	555.36	552.08	554.36	8517522.0
2024-09-11 16:00:00	SPY	ETF	554.35	555.07	554.04	554.42	3324263.0
2024-09-11 16:30:00	SPY	ETF	554.47	554.58	554.36	554.41	68065.0
2024-09-11 17:00:00	SPY	ETF	554.49	554.5	554.29	554.32	27578.0
2024-09-11 17:30:00	SPY	ETF	554.3	554.42	554.27	554.38	20398.0
2024-09-11 18:00:00	SPY	ETF	554.42	554.42	554.2	554.25	34559.0
2024-09-11 18:30:00	SPY	ETF	554.42	554.43	554.28	554.36	11437.0
2024-09-11 19:00:00	SPY	ETF	554.39	554.43	554.28	554.31	8722.0
2024-09-11 19:30:00	SPY	ETF	554.29	554.34	554.2	554.31	34650.0
2024-09-11 04:00:00	QQQ	ETF	457.71	457.91	457.3	457.91	9054.0
2024-09-11 04:30:00	QQQ	ETF	457.43	457.43	456.51	456.83	31711.0
2024-09-11 05:00:00	QQQ	ETF	456.9	457.28	456.67	456.9	9078.0
2024-09-11 05:30:00	QQQ	ETF	457.0	457.65	456.9	457.59	15007.0
2024-09-11 06:00:00	QQQ	ETF	457.57	457.68	457.15	457.28	5705.0
2024-09-11 06:30:00	QQQ	ETF	457.26	457.65	457.26	457.42	9529.0
2024-09-11 07:00:00	QQQ	ETF	457.44	457.78	457.25	457.56	124216.0
2024-09-11 07:30:00	QQQ	ETF	457.58	458.35	457.55	458.18	88117.0
2024-09-11 08:00:00	QQQ	ETF	457.71	459.003	455.19	458.68	330099.0
2024-09-11 08:30:00	QQQ	ETF	458.7	459.18	455.74	458.95	872196.0
2024-09-11 09:00:00	QQQ	ETF	459.0118	460.52	458.94	459.74	611628.0
2024-09-11 09:30:00	QQQ	ETF	459.86	459.94	456.76	457.21	3807445.0
2024-09-11 10:00:00	QQQ	ETF	457.21	457.77	453.63	453.89	3366293.0
2024-09-11 10:30:00	QQQ	ETF	453.89	453.91	451.28	452.67	3481120.0
2024-09-11 11:00:00	QQQ	ETF	452.65	455.06	451.81	454.6961	2592790.0
2024-09-11 11:30:00	QQQ	ETF	454.655	457.83	454.48	457.115	2842907.0
2024-09-11 12:00:00	QQQ	ETF	457.15	460.14	456.99	460.1	2905721.0
2024-09-11 12:30:00	QQQ	ETF	460.11	460.74	459.11	460.06	2088475.0

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

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