PREVIEW / etf_30min / 2025-05-02

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-05-02.parquet
  size:    972 KB
  rows:    39,845

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-02 04:00:00	SPY	ETF	560.98	561.43	560.43	561.43	18943.0
2025-05-02 04:30:00	SPY	ETF	561.4	561.74	559.79	559.79	18186.0
2025-05-02 05:00:00	SPY	ETF	559.65	560.69	559.4	560.44	9913.0
2025-05-02 05:30:00	SPY	ETF	560.33	561.2	560.25	560.9	12216.0
2025-05-02 06:00:00	SPY	ETF	560.73	561.3	560.73	561.0	19059.0
2025-05-02 06:30:00	SPY	ETF	561.25	561.4	560.66	560.99	32922.0
2025-05-02 07:00:00	SPY	ETF	561.0	561.38	560.5	560.69	90123.0
2025-05-02 07:30:00	SPY	ETF	560.83	560.83	560.07	560.43	164647.0
2025-05-02 08:00:00	SPY	ETF	561.04	563.25	560.2	560.95	240377.0
2025-05-02 08:30:00	SPY	ETF	561.6	565.29	561.21	565.1	839538.0
2025-05-02 09:00:00	SPY	ETF	565.15	565.93	564.5	564.69	560666.0
2025-05-02 09:30:00	SPY	ETF	564.69	565.48	562.38	563.62	4613119.0
2025-05-02 10:00:00	SPY	ETF	563.6449	566.32	563.27	566.3	2691939.0
2025-05-02 10:30:00	SPY	ETF	566.3	566.31	564.75	565.8	2082243.0
2025-05-02 11:00:00	SPY	ETF	565.8	566.13	564.51	564.65	2058409.0
2025-05-02 11:30:00	SPY	ETF	564.67	566.39	564.46	566.2299	1489749.0
2025-05-02 12:00:00	SPY	ETF	566.23	567.94	566.16	567.2	3645700.0
2025-05-02 12:30:00	SPY	ETF	567.2	568.0796	567.15	567.5	1667514.0
2025-05-02 13:00:00	SPY	ETF	567.5	567.77	566.36	566.78	1500803.0
2025-05-02 13:30:00	SPY	ETF	566.78	567.61	566.5	567.25	1147223.0
2025-05-02 14:00:00	SPY	ETF	567.25	567.9588	567.15	567.65	1507729.0
2025-05-02 14:30:00	SPY	ETF	567.68	568.38	566.45	567.1	2325074.0
2025-05-02 15:00:00	SPY	ETF	567.08	567.93	566.15	567.67	3473291.0
2025-05-02 15:30:00	SPY	ETF	567.64	567.83	566.02	566.62	7631152.0
2025-05-02 16:00:00	SPY	ETF	566.63	567.49	566.54	567.0	3339588.0
2025-05-02 16:30:00	SPY	ETF	567.0	567.19	566.6	567.06	319844.0
2025-05-02 17:00:00	SPY	ETF	567.07	567.25	566.95	567.0	134246.0
2025-05-02 17:30:00	SPY	ETF	566.95	567.04	566.86	566.9	21067.0
2025-05-02 18:00:00	SPY	ETF	566.88	566.88	566.7498	566.7498	7336.0
2025-05-02 18:30:00	SPY	ETF	566.73	566.9	566.69	566.72	10318.0
2025-05-02 19:00:00	SPY	ETF	566.6722	566.7	566.57	566.66	12364.0
2025-05-02 19:30:00	SPY	ETF	566.6	566.95	566.5522	566.83	9258.0
2025-05-02 04:00:00	QQQ	ETF	481.99	482.96	481.39	482.8	73846.0
2025-05-02 04:30:00	QQQ	ETF	482.72	483.11	481.2	481.2	39214.0
2025-05-02 05:00:00	QQQ	ETF	481.2	482.2	481.08	481.86	20712.0
2025-05-02 05:30:00	QQQ	ETF	482.0	482.68	481.91	482.34	10032.0
2025-05-02 06:00:00	QQQ	ETF	482.29	483.21	482.23	483.09	29321.0
2025-05-02 06:30:00	QQQ	ETF	483.2	483.3	482.6	482.77	40459.0
2025-05-02 07:00:00	QQQ	ETF	482.75	483.28	482.55	482.67	54798.0
2025-05-02 07:30:00	QQQ	ETF	482.72	482.78	482.0	482.49	53325.0
2025-05-02 08:00:00	QQQ	ETF	482.93	484.3	481.2996	482.9	205300.0
2025-05-02 08:30:00	QQQ	ETF	483.19	486.89	483.0	486.6	552141.0
2025-05-02 09:00:00	QQQ	ETF	486.71	487.7	486.27	486.48	328284.0
2025-05-02 09:30:00	QQQ	ETF	486.54	487.64	484.83	486.05	3542853.0
2025-05-02 10:00:00	QQQ	ETF	486.09	488.66	485.84	488.645	2338442.0
2025-05-02 10:30:00	QQQ	ETF	488.63	488.67	487.28	488.2812	1487554.0
2025-05-02 11:00:00	QQQ	ETF	488.3	488.97	487.58	487.67	1479783.0
2025-05-02 11:30:00	QQQ	ETF	487.69	489.24	487.35	489.0	1070700.0
2025-05-02 12:00:00	QQQ	ETF	489.02	490.55	488.92	489.66	2894800.0
2025-05-02 12:30:00	QQQ	ETF	489.6724	490.67	489.625	490.08	1025232.0

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

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