PREVIEW / etf_30min / 2025-05-08

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-05-08.parquet
  size:    971 KB
  rows:    39,856

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
2025-05-08 04:00:00	SPY	ETF	556.5	566.49	556.5	566.44	38129.0
2025-05-08 04:30:00	SPY	ETF	566.45	567.04	566.44	567.04	12378.0
2025-05-08 05:00:00	SPY	ETF	567.0	567.36	566.74	567.2	21435.0
2025-05-08 05:30:00	SPY	ETF	567.24	567.82	567.24	567.48	25205.0
2025-05-08 06:00:00	SPY	ETF	567.4	567.61	567.28	567.6	56349.0
2025-05-08 06:30:00	SPY	ETF	567.52	567.96	567.19	567.9	144281.0
2025-05-08 07:00:00	SPY	ETF	567.91	568.0	567.02	567.07	147183.0
2025-05-08 07:30:00	SPY	ETF	567.09	567.2	566.0	566.5	152527.0
2025-05-08 08:00:00	SPY	ETF	567.56	568.0	564.8	566.3207	239513.0
2025-05-08 08:30:00	SPY	ETF	566.3	566.87	564.5	565.71	686500.0
2025-05-08 09:00:00	SPY	ETF	565.65	565.8	565.12	565.26	211807.0
2025-05-08 09:30:00	SPY	ETF	565.22	565.64	563.56	564.1298	3214328.0
2025-05-08 10:00:00	SPY	ETF	564.14	564.825	562.3006	564.43	2992301.0
2025-05-08 10:30:00	SPY	ETF	564.4652	565.16	561.7	562.6	3753329.0
2025-05-08 11:00:00	SPY	ETF	562.55	567.07	562.03	566.2	3959820.0
2025-05-08 11:30:00	SPY	ETF	566.23	569.65	565.43	568.38	6195658.0
2025-05-08 12:00:00	SPY	ETF	568.3962	569.71	568.34	568.7993	2042308.0
2025-05-08 12:30:00	SPY	ETF	568.8	570.31	568.71	570.12	1806744.0
2025-05-08 13:00:00	SPY	ETF	570.11	570.205	568.89	569.2	1489555.0
2025-05-08 13:30:00	SPY	ETF	569.2	569.39	567.6	567.6899	1293346.0
2025-05-08 14:00:00	SPY	ETF	567.68	568.69	567.42	568.03	1876970.0
2025-05-08 14:30:00	SPY	ETF	568.03	569.13	568.02	568.35	1553107.0
2025-05-08 15:00:00	SPY	ETF	568.34	569.37	567.63	569.02	4561454.0
2025-05-08 15:30:00	SPY	ETF	569.03	569.13	564.54	564.92	8258522.0
2025-05-08 16:00:00	SPY	ETF	564.92	565.61	564.6716	564.84	2854845.0
2025-05-08 16:30:00	SPY	ETF	564.84	565.15	564.67	564.7599	378343.0
2025-05-08 17:00:00	SPY	ETF	564.89	565.08	564.8502	565.0104	137683.0
2025-05-08 17:30:00	SPY	ETF	565.1	565.2	565.0005	565.19	63421.0
2025-05-08 18:00:00	SPY	ETF	565.14	565.22	564.43	564.98	87417.0
2025-05-08 18:30:00	SPY	ETF	564.92	564.95	564.53	564.8507	22715.0
2025-05-08 19:00:00	SPY	ETF	564.91	565.09	564.45	564.56	46698.0
2025-05-08 19:30:00	SPY	ETF	564.56	564.56	564.01	564.32	69375.0
2025-05-08 04:00:00	QQQ	ETF	488.15	489.84	488.0	489.57	48446.0
2025-05-08 04:30:00	QQQ	ETF	489.68	490.19	489.5	490.09	46463.0
2025-05-08 05:00:00	QQQ	ETF	490.11	490.52	489.79	490.35	31325.0
2025-05-08 05:30:00	QQQ	ETF	490.35	490.88	490.31	490.51	42597.0
2025-05-08 06:00:00	QQQ	ETF	490.55	490.7	490.34	490.47	27004.0
2025-05-08 06:30:00	QQQ	ETF	490.44	490.75	490.05	490.69	106984.0
2025-05-08 07:00:00	QQQ	ETF	490.69	490.71	489.85	489.9	140270.0
2025-05-08 07:30:00	QQQ	ETF	489.9	490.03	489.05	489.33	81814.0
2025-05-08 08:00:00	QQQ	ETF	490.7	490.7	482.938	489.6	264356.0
2025-05-08 08:30:00	QQQ	ETF	489.63	490.0794	487.83	488.83	350888.0
2025-05-08 09:00:00	QQQ	ETF	488.78	488.98	488.4	488.47	188580.0
2025-05-08 09:30:00	QQQ	ETF	488.53	488.74	486.075	486.8	2536928.0
2025-05-08 10:00:00	QQQ	ETF	486.82	487.6	485.24	486.83	1913913.0
2025-05-08 10:30:00	QQQ	ETF	486.83	487.44	484.17	485.0686	1781317.0
2025-05-08 11:00:00	QQQ	ETF	484.95	489.53	484.5	488.725	2337896.0
2025-05-08 11:30:00	QQQ	ETF	488.7201	492.17	488.05	491.12	4190128.0
2025-05-08 12:00:00	QQQ	ETF	491.12	492.41	491.04	491.381	2204819.0
2025-05-08 12:30:00	QQQ	ETF	491.3949	492.7	491.24	492.55	1234038.0

> showing 50 of 39,856 rows — these rows as CSV

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