PREVIEW / etf_30min / 2024-11-05

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-11-05.parquet
  size:    864 KB
  rows:    34,353

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-11-05 04:00:00	SPY	ETF	570.77	571.08	570.67	570.92	6178.0
2024-11-05 04:30:00	SPY	ETF	570.86	571.06	570.82	570.91	8571.0
2024-11-05 05:00:00	SPY	ETF	570.66	570.82	570.15	570.75	4301.0
2024-11-05 05:30:00	SPY	ETF	570.68	570.75	570.61	570.75	807.0
2024-11-05 06:00:00	SPY	ETF	570.96	571.19	570.96	571.19	8823.0
2024-11-05 06:30:00	SPY	ETF	571.17	571.35	571.13	571.16	11191.0
2024-11-05 07:00:00	SPY	ETF	570.9	571.21	570.49	570.49	61555.0
2024-11-05 07:30:00	SPY	ETF	570.54	570.85	570.34	570.69	45396.0
2024-11-05 08:00:00	SPY	ETF	571.01	571.15	569.93	570.94	68261.0
2024-11-05 08:30:00	SPY	ETF	570.95	571.1	570.55	570.55	49168.0
2024-11-05 09:00:00	SPY	ETF	570.53	570.85	570.2701	570.82	80390.0
2024-11-05 09:30:00	SPY	ETF	570.73	574.02	570.52	573.98	2656274.0
2024-11-05 10:00:00	SPY	ETF	574.01	574.78	573.51	574.01	2533838.0
2024-11-05 10:30:00	SPY	ETF	574.05	575.21	573.75	574.005	1648879.0
2024-11-05 11:00:00	SPY	ETF	573.98	575.09	573.5454	574.71	1274803.0
2024-11-05 11:30:00	SPY	ETF	574.71	575.6	574.71	575.45	1102514.0
2024-11-05 12:00:00	SPY	ETF	575.46	576.21	575.15	575.67	1105706.0
2024-11-05 12:30:00	SPY	ETF	575.664	576.43	575.664	576.03	1020899.0
2024-11-05 13:00:00	SPY	ETF	576.04	576.4	575.3301	575.38	1179627.0
2024-11-05 13:30:00	SPY	ETF	575.4	575.64	574.6	575.2348	1080224.0
2024-11-05 14:00:00	SPY	ETF	575.23	575.87	575.1263	575.43	1015970.0
2024-11-05 14:30:00	SPY	ETF	575.44	575.87	574.7	575.0	1507360.0
2024-11-05 15:00:00	SPY	ETF	575.0	575.76	574.7437	575.6899	1699270.0
2024-11-05 15:30:00	SPY	ETF	575.67	576.71	575.26	576.68	5164741.0
2024-11-05 16:00:00	SPY	ETF	576.68	577.55	576.55	577.39	2087813.0
2024-11-05 16:30:00	SPY	ETF	577.33	577.63	576.7	577.56	183142.0
2024-11-05 17:00:00	SPY	ETF	577.5	577.5	577.29	577.35	50613.0
2024-11-05 17:30:00	SPY	ETF	577.33	577.48	577.33	577.39	14019.0
2024-11-05 18:00:00	SPY	ETF	577.41	577.71	576.91	577.22	88967.0
2024-11-05 18:30:00	SPY	ETF	577.24	577.42	576.9	577.01	19138.0
2024-11-05 19:00:00	SPY	ETF	576.97	579.06	576.9412	578.91	182778.0
2024-11-05 19:30:00	SPY	ETF	578.92	579.93	578.92	579.0901	153568.0
2024-11-05 04:00:00	QQQ	ETF	487.49	488.0	487.28	487.88	20904.0
2024-11-05 04:30:00	QQQ	ETF	487.8	487.94	487.58	487.62	14015.0
2024-11-05 05:00:00	QQQ	ETF	487.5	487.55	486.75	487.35	18003.0
2024-11-05 05:30:00	QQQ	ETF	487.33	487.49	487.13	487.43	8359.0
2024-11-05 06:00:00	QQQ	ETF	487.54	487.9	487.54	487.9	18078.0
2024-11-05 06:30:00	QQQ	ETF	487.8	488.09	487.7	487.7	17006.0
2024-11-05 07:00:00	QQQ	ETF	487.68	488.0	487.25	487.28	49405.0
2024-11-05 07:30:00	QQQ	ETF	487.31	487.58	487.07	487.58	22055.0
2024-11-05 08:00:00	QQQ	ETF	488.01	488.01	485.646	487.7	37189.0
2024-11-05 08:30:00	QQQ	ETF	487.7	487.9	487.0	487.03	52366.0
2024-11-05 09:00:00	QQQ	ETF	486.98	487.66	486.59	487.6	117195.0
2024-11-05 09:30:00	QQQ	ETF	487.61	491.13	487.52	490.9451	2399067.0
2024-11-05 10:00:00	QQQ	ETF	490.88	491.61	490.17	490.33	1398124.0
2024-11-05 10:30:00	QQQ	ETF	490.35	491.32	489.77	490.15	1163383.0
2024-11-05 11:00:00	QQQ	ETF	490.1	491.48	489.56	491.12	790757.0
2024-11-05 11:30:00	QQQ	ETF	491.19	492.29	491.16	492.14	865755.0
2024-11-05 12:00:00	QQQ	ETF	492.15	492.88	491.83	492.32	826634.0
2024-11-05 12:30:00	QQQ	ETF	492.37	492.88	492.19	492.4	707110.0

> showing 50 of 34,353 rows — these rows as CSV

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