PREVIEW / etf_30min / 2024-06-25

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-06-25.parquet
  size:    808 KB
  rows:    32,073

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-06-25 04:00:00	SPY	ETF	542.69	543.4	542.46	543.32	33022.0
2024-06-25 04:30:00	SPY	ETF	543.48	543.6	543.27	543.59	5288.0
2024-06-25 05:00:00	SPY	ETF	543.62	543.87	543.51	543.87	17805.0
2024-06-25 05:30:00	SPY	ETF	543.96	544.0	543.82	544.0	3650.0
2024-06-25 06:00:00	SPY	ETF	544.0	544.03	543.81	543.88	1990.0
2024-06-25 06:30:00	SPY	ETF	543.88	543.96	543.72	543.96	7039.0
2024-06-25 07:00:00	SPY	ETF	543.89	544.15	543.37	543.89	179635.0
2024-06-25 07:30:00	SPY	ETF	543.91	543.95	543.45	543.92	28227.0
2024-06-25 08:00:00	SPY	ETF	543.9996	544.15	542.8	544.09	45486.0
2024-06-25 08:30:00	SPY	ETF	544.03	544.03	543.51	543.97	113201.0
2024-06-25 09:00:00	SPY	ETF	543.92	544.32	543.82	544.02	208652.0
2024-06-25 09:30:00	SPY	ETF	543.99	544.07	543.03	543.1	2577256.0
2024-06-25 10:00:00	SPY	ETF	543.12	544.17	543.03	543.99	1415241.0
2024-06-25 10:30:00	SPY	ETF	543.98	544.26	543.4305	543.665	1195645.0
2024-06-25 11:00:00	SPY	ETF	543.67	544.48	543.5389	544.06	1455643.0
2024-06-25 11:30:00	SPY	ETF	544.05	544.4301	543.93	544.35	1088782.0
2024-06-25 12:00:00	SPY	ETF	544.34	544.35	543.42	543.62	994606.0
2024-06-25 12:30:00	SPY	ETF	543.61	543.61	542.53	542.9502	1178778.0
2024-06-25 13:00:00	SPY	ETF	542.95	543.7	542.44	543.69	1192759.0
2024-06-25 13:30:00	SPY	ETF	543.69	544.152	543.43	543.98	910622.0
2024-06-25 14:00:00	SPY	ETF	543.99	544.87	543.83	544.846	1485747.0
2024-06-25 14:30:00	SPY	ETF	544.84	544.86	543.8	544.425	1619187.0
2024-06-25 15:00:00	SPY	ETF	544.42	545.12	544.24	545.12	1551454.0
2024-06-25 15:30:00	SPY	ETF	545.12	545.2	544.17	544.78	4653508.0
2024-06-25 16:00:00	SPY	ETF	544.77	544.83	544.44	544.61	2751527.0
2024-06-25 16:30:00	SPY	ETF	544.63	544.8	544.6	544.77	329034.0
2024-06-25 17:00:00	SPY	ETF	544.65	544.88	544.65	544.75	26130.0
2024-06-25 17:30:00	SPY	ETF	544.72	544.86	544.72	544.79	16635.0
2024-06-25 18:00:00	SPY	ETF	544.75	544.98	544.6	544.91	46947.0
2024-06-25 18:30:00	SPY	ETF	544.91	544.91	544.7	544.84	280947.0
2024-06-25 19:00:00	SPY	ETF	544.87	544.88	544.72	544.7796	29770.0
2024-06-25 19:30:00	SPY	ETF	544.76	544.77	544.6898	544.6898	5351.0
2024-06-25 04:00:00	QQQ	ETF	473.88	475.23	473.71	475.22	39789.0
2024-06-25 04:30:00	QQQ	ETF	475.16	475.82	475.16	475.78	26137.0
2024-06-25 05:00:00	QQQ	ETF	475.79	476.18	475.7	476.14	32991.0
2024-06-25 05:30:00	QQQ	ETF	476.15	476.34	475.93	476.29	24966.0
2024-06-25 06:00:00	QQQ	ETF	476.34	476.43	475.96	476.2	15421.0
2024-06-25 06:30:00	QQQ	ETF	476.14	476.37	475.93	476.21	20463.0
2024-06-25 07:00:00	QQQ	ETF	476.2	476.54	475.98	476.15	63760.0
2024-06-25 07:30:00	QQQ	ETF	476.13	476.13	475.53	475.82	61482.0
2024-06-25 08:00:00	QQQ	ETF	476.2	476.53	474.06	476.11	89554.0
2024-06-25 08:30:00	QQQ	ETF	476.01	476.19	475.56	476.13	65947.0
2024-06-25 09:00:00	QQQ	ETF	476.19	476.51	475.94	476.09	140964.0
2024-06-25 09:30:00	QQQ	ETF	476.07	476.57	475.12	476.08	2272191.0
2024-06-25 10:00:00	QQQ	ETF	476.11	477.7	476.04	477.26	1397638.0
2024-06-25 10:30:00	QQQ	ETF	477.26	477.76	476.62	476.92	1153175.0
2024-06-25 11:00:00	QQQ	ETF	476.93	478.78	476.93	478.5	1374469.0
2024-06-25 11:30:00	QQQ	ETF	478.5	479.17	478.4098	479.13	1064968.0
2024-06-25 12:00:00	QQQ	ETF	479.13	479.33	478.01	478.21	1025047.0
2024-06-25 12:30:00	QQQ	ETF	478.22	478.22	476.69	477.115	1032149.0

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

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