PREVIEW / etf_30min / 2025-02-07

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-02-07.parquet
  size:    941 KB
  rows:    38,438

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-02-07 04:00:00	SPY	ETF	605.6	606.15	605.6	605.81	3040.0
2025-02-07 04:30:00	SPY	ETF	606.0	606.32	606.0	606.23	1616.0
2025-02-07 05:00:00	SPY	ETF	606.33	606.49	606.28	606.49	660.0
2025-02-07 05:30:00	SPY	ETF	606.19	606.25	606.19	606.24	1166.0
2025-02-07 06:00:00	SPY	ETF	606.32	606.32	606.09	606.13	2641.0
2025-02-07 06:30:00	SPY	ETF	606.22	606.69	606.22	606.6	11173.0
2025-02-07 07:00:00	SPY	ETF	606.61	606.65	606.44	606.48	10887.0
2025-02-07 07:30:00	SPY	ETF	606.47	606.49	606.28	606.31	31098.0
2025-02-07 08:00:00	SPY	ETF	606.63	606.66	605.32	605.9	108271.0
2025-02-07 08:30:00	SPY	ETF	606.0	607.22	604.4	606.77	810413.0
2025-02-07 09:00:00	SPY	ETF	606.79	607.01	606.38	606.86	104096.0
2025-02-07 09:30:00	SPY	ETF	606.89	608.13	606.56	607.8103	2625542.0
2025-02-07 10:00:00	SPY	ETF	607.77	607.81	603.77	604.583	4084204.0
2025-02-07 10:30:00	SPY	ETF	604.5	605.54	601.18	603.41	3457361.0
2025-02-07 11:00:00	SPY	ETF	603.45	604.5395	601.54	602.0004	2657828.0
2025-02-07 11:30:00	SPY	ETF	602.05	602.91	601.29	601.5988	4126436.0
2025-02-07 12:00:00	SPY	ETF	601.57	602.83	600.64	601.7	2527024.0
2025-02-07 12:30:00	SPY	ETF	601.61	602.85	601.3	602.16	671783.0
2025-02-07 13:00:00	SPY	ETF	602.17	603.75	602.04	603.3142	855211.0
2025-02-07 13:30:00	SPY	ETF	603.33	603.65	601.13	601.235	883123.0
2025-02-07 14:00:00	SPY	ETF	601.226	601.59	600.42	600.5893	1153672.0
2025-02-07 14:30:00	SPY	ETF	600.609	601.6	600.34	601.12	1242099.0
2025-02-07 15:00:00	SPY	ETF	601.11	601.11	600.05	600.4	1447597.0
2025-02-07 15:30:00	SPY	ETF	600.39	601.26	600.37	600.78	4102785.0
2025-02-07 16:00:00	SPY	ETF	600.78	606.4184	600.77	601.07	2163266.0
2025-02-07 16:30:00	SPY	ETF	601.07	601.09	600.82	600.87	101349.0
2025-02-07 17:00:00	SPY	ETF	600.96	601.06	600.87	601.06	47545.0
2025-02-07 17:30:00	SPY	ETF	601.1	601.1	600.7	600.7	521624.0
2025-02-07 18:00:00	SPY	ETF	600.7	600.72	600.5	600.7	33552.0
2025-02-07 18:30:00	SPY	ETF	600.7	601.1	600.55	600.5999	39528.0
2025-02-07 19:00:00	SPY	ETF	600.6	600.6	600.3727	600.3727	26231.0
2025-02-07 19:30:00	SPY	ETF	600.43	600.5	600.21	600.2299	18416.0
2025-02-07 04:00:00	QQQ	ETF	529.0	529.54	528.73	529.06	17076.0
2025-02-07 04:30:00	QQQ	ETF	529.16	529.58	529.14	529.45	8432.0
2025-02-07 05:00:00	QQQ	ETF	529.39	529.68	529.29	529.68	10973.0
2025-02-07 05:30:00	QQQ	ETF	529.63	529.63	529.28	529.32	22403.0
2025-02-07 06:00:00	QQQ	ETF	529.54	529.55	529.02	529.27	35217.0
2025-02-07 06:30:00	QQQ	ETF	529.25	529.81	529.24	529.77	38295.0
2025-02-07 07:00:00	QQQ	ETF	529.74	529.88	529.7	529.71	16118.0
2025-02-07 07:30:00	QQQ	ETF	529.7	529.81	529.46	529.66	32685.0
2025-02-07 08:00:00	QQQ	ETF	529.72	529.997	528.8	529.2	98662.0
2025-02-07 08:30:00	QQQ	ETF	529.85	531.0	527.9	529.85	562745.0
2025-02-07 09:00:00	QQQ	ETF	529.95	530.32	529.63	530.19	142645.0
2025-02-07 09:30:00	QQQ	ETF	530.14	532.1	529.79	530.64	1726171.0
2025-02-07 10:00:00	QQQ	ETF	530.57	530.58	525.35	526.8	3398740.0
2025-02-07 10:30:00	QQQ	ETF	526.77	528.1687	523.68	526.21	2348607.0
2025-02-07 11:00:00	QQQ	ETF	526.18	527.03	523.91	524.5825	1647062.0
2025-02-07 11:30:00	QQQ	ETF	524.7	525.3499	523.49	523.91	1034470.0
2025-02-07 12:00:00	QQQ	ETF	523.95	525.031	522.91	523.89	1564469.0
2025-02-07 12:30:00	QQQ	ETF	523.85	525.27	523.45	524.55	755870.0

> showing 50 of 38,438 rows — these rows as CSV

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