PREVIEW / etf_30min / 2024-06-26

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-06-26.parquet
  size:    802 KB
  rows:    31,750

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-26 04:00:00	SPY	ETF	546.19	546.45	546.1	546.19	20187.0
2024-06-26 04:30:00	SPY	ETF	546.22	546.55	546.18	546.25	3684.0
2024-06-26 05:00:00	SPY	ETF	546.06	546.17	546.01	546.11	4369.0
2024-06-26 05:30:00	SPY	ETF	546.08	546.08	545.68	545.68	2920.0
2024-06-26 06:00:00	SPY	ETF	545.55	545.61	545.19	545.2	10686.0
2024-06-26 06:30:00	SPY	ETF	545.2	545.4	545.13	545.2	5502.0
2024-06-26 07:00:00	SPY	ETF	545.08	545.17	544.71	544.82	21596.0
2024-06-26 07:30:00	SPY	ETF	544.83	544.99	544.64	544.98	23647.0
2024-06-26 08:00:00	SPY	ETF	545.05	546.01	544.34	544.3804	60943.0
2024-06-26 08:30:00	SPY	ETF	544.37	544.45	543.73	543.8	158837.0
2024-06-26 09:00:00	SPY	ETF	543.74	543.79	543.22	543.67	164133.0
2024-06-26 09:30:00	SPY	ETF	543.69	544.39	543.17	544.115	2493823.0
2024-06-26 10:00:00	SPY	ETF	544.11	544.8	543.62	543.805	1771096.0
2024-06-26 10:30:00	SPY	ETF	543.8	544.56	543.75	544.21	2004612.0
2024-06-26 11:00:00	SPY	ETF	544.2	544.4	543.03	543.96	1446372.0
2024-06-26 11:30:00	SPY	ETF	543.95	545.45	543.655	545.32	1312263.0
2024-06-26 12:00:00	SPY	ETF	545.32	545.42	544.89	545.19	1197565.0
2024-06-26 12:30:00	SPY	ETF	545.18	545.34	544.26	544.76	1176203.0
2024-06-26 13:00:00	SPY	ETF	544.75	545.02	544.01	544.51	907211.0
2024-06-26 13:30:00	SPY	ETF	544.53	544.94	544.27	544.865	626420.0
2024-06-26 14:00:00	SPY	ETF	544.87	544.91	544.48	544.735	777798.0
2024-06-26 14:30:00	SPY	ETF	544.74	545.115	544.3	544.545	1071414.0
2024-06-26 15:00:00	SPY	ETF	544.55	544.69	544.13	544.6398	987570.0
2024-06-26 15:30:00	SPY	ETF	544.63	546.24	544.45	545.52	4988937.0
2024-06-26 16:00:00	SPY	ETF	545.52	545.649	544.33	544.85	3533917.0
2024-06-26 16:30:00	SPY	ETF	544.85	544.89	544.58	544.82	296483.0
2024-06-26 17:00:00	SPY	ETF	544.75	544.85	544.6	544.6	36656.0
2024-06-26 17:30:00	SPY	ETF	544.71	544.87	544.6	544.6	2955.0
2024-06-26 18:00:00	SPY	ETF	544.76	544.96	544.61	544.66	27483.0
2024-06-26 18:30:00	SPY	ETF	544.55	544.55	544.3	544.42	11056.0
2024-06-26 19:00:00	SPY	ETF	544.36	544.4	543.86	543.94	11478.0
2024-06-26 19:30:00	SPY	ETF	543.93	544.01	543.79	543.98	31293.0
2024-06-26 04:00:00	QQQ	ETF	480.52	481.95	480.51	481.47	50899.0
2024-06-26 04:30:00	QQQ	ETF	481.42	481.88	481.4	481.4	14024.0
2024-06-26 05:00:00	QQQ	ETF	481.33	481.41	481.05	481.32	24119.0
2024-06-26 05:30:00	QQQ	ETF	481.15	481.17	480.81	480.86	6889.0
2024-06-26 06:00:00	QQQ	ETF	480.76	480.84	480.32	480.46	13644.0
2024-06-26 06:30:00	QQQ	ETF	480.45	480.73	480.14	480.14	15900.0
2024-06-26 07:00:00	QQQ	ETF	480.17	480.43	479.93	480.11	35482.0
2024-06-26 07:30:00	QQQ	ETF	480.09	480.25	479.81	480.25	28754.0
2024-06-26 08:00:00	QQQ	ETF	480.37	481.71	479.41	479.44	92203.0
2024-06-26 08:30:00	QQQ	ETF	479.41	479.47	478.6	478.67	123949.0
2024-06-26 09:00:00	QQQ	ETF	478.56	478.62	477.89	478.58	286168.0
2024-06-26 09:30:00	QQQ	ETF	478.55	480.27	478.33	479.61	2075740.0
2024-06-26 10:00:00	QQQ	ETF	479.59	480.83	478.95	479.2901	1278522.0
2024-06-26 10:30:00	QQQ	ETF	479.32	480.47	479.3	479.6385	1199637.0
2024-06-26 11:00:00	QQQ	ETF	479.66	479.87	478.13	479.2499	1375053.0
2024-06-26 11:30:00	QQQ	ETF	479.22	480.88	478.859	480.66	1090463.0
2024-06-26 12:00:00	QQQ	ETF	480.67	480.73	480.02	480.3301	626713.0
2024-06-26 12:30:00	QQQ	ETF	480.32	480.44	478.93	479.66	832917.0

> showing 50 of 31,750 rows — these rows as CSV

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