PREVIEW / etf_30min / 2025-05-20

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-05-20.parquet
  size:    949 KB
  rows:    38,739

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-20 04:00:00	SPY	ETF	593.45	593.66	592.93	593.33	11586.0
2025-05-20 04:30:00	SPY	ETF	593.38	593.75	593.13	593.18	6837.0
2025-05-20 05:00:00	SPY	ETF	593.19	593.53	592.92	592.94	16030.0
2025-05-20 05:30:00	SPY	ETF	592.92	593.14	592.9	592.92	6056.0
2025-05-20 06:00:00	SPY	ETF	593.09	593.85	592.87	593.56	24789.0
2025-05-20 06:30:00	SPY	ETF	593.59	594.05	593.33	594.05	12754.0
2025-05-20 07:00:00	SPY	ETF	594.01	594.27	593.939	594.25	29572.0
2025-05-20 07:30:00	SPY	ETF	594.3	594.38	593.96	593.96	72797.0
2025-05-20 08:00:00	SPY	ETF	593.94	594.3692	592.55	593.86	76219.0
2025-05-20 08:30:00	SPY	ETF	593.85	593.88	593.17	593.51	118878.0
2025-05-20 09:00:00	SPY	ETF	593.51	594.0	593.04	593.1	199016.0
2025-05-20 09:30:00	SPY	ETF	593.11	593.63	592.04	592.84	4371655.0
2025-05-20 10:00:00	SPY	ETF	592.85	593.46	592.355	592.9	2635646.0
2025-05-20 10:30:00	SPY	ETF	592.88	594.05	592.62	592.97	2243703.0
2025-05-20 11:00:00	SPY	ETF	592.97	593.64	592.49	593.44	1715357.0
2025-05-20 11:30:00	SPY	ETF	593.44	593.54	592.47	593.2098	1730098.0
2025-05-20 12:00:00	SPY	ETF	593.1901	593.345	592.235	592.68	1701108.0
2025-05-20 12:30:00	SPY	ETF	592.69	593.57	592.63	593.38	1675182.0
2025-05-20 13:00:00	SPY	ETF	593.375	593.8	593.19	593.46	1900612.0
2025-05-20 13:30:00	SPY	ETF	593.45	593.53	592.47	592.995	2143413.0
2025-05-20 14:00:00	SPY	ETF	592.985	593.17	590.6201	590.81	3497856.0
2025-05-20 14:30:00	SPY	ETF	590.81	591.595	590.59	590.88	3368922.0
2025-05-20 15:00:00	SPY	ETF	590.88	591.65	589.6	591.32	5198252.0
2025-05-20 15:30:00	SPY	ETF	591.32	592.965	591.32	592.83	7173651.0
2025-05-20 16:00:00	SPY	ETF	592.81	592.89	592.04	592.61	4199113.0
2025-05-20 16:30:00	SPY	ETF	592.61	592.64	592.18	592.339	131690.0
2025-05-20 17:00:00	SPY	ETF	592.37	592.5	592.14	592.15	30463.0
2025-05-20 17:30:00	SPY	ETF	592.85	592.85	592.19	592.22	213852.0
2025-05-20 18:00:00	SPY	ETF	592.17	592.2	590.5	591.339	292879.0
2025-05-20 18:30:00	SPY	ETF	591.18	591.75	591.18	591.7	39262.0
2025-05-20 19:00:00	SPY	ETF	591.71	592.2	591.71	592.0004	22918.0
2025-05-20 19:30:00	SPY	ETF	592.09	592.35	591.8603	592.35	24002.0
2025-05-20 04:00:00	QQQ	ETF	520.22	520.53	519.45	520.0	36340.0
2025-05-20 04:30:00	QQQ	ETF	520.0	520.59	519.91	519.97	22288.0
2025-05-20 05:00:00	QQQ	ETF	520.01	520.39	519.55	519.57	21983.0
2025-05-20 05:30:00	QQQ	ETF	519.61	519.99	519.59	519.77	9549.0
2025-05-20 06:00:00	QQQ	ETF	519.93	520.46	519.68	520.16	24507.0
2025-05-20 06:30:00	QQQ	ETF	520.19	520.7	519.96	520.7	16227.0
2025-05-20 07:00:00	QQQ	ETF	520.69	521.15	520.56	521.1	75171.0
2025-05-20 07:30:00	QQQ	ETF	521.11	521.16	520.7	520.72	40389.0
2025-05-20 08:00:00	QQQ	ETF	520.76	521.619	519.05	520.33	159436.0
2025-05-20 08:30:00	QQQ	ETF	520.33	520.35	519.62	520.01	140114.0
2025-05-20 09:00:00	QQQ	ETF	519.991	520.54	519.28	519.41	159653.0
2025-05-20 09:30:00	QQQ	ETF	519.46	520.095	518.07	519.03	3737150.0
2025-05-20 10:00:00	QQQ	ETF	519.03	519.79	518.28	519.03	2481959.0
2025-05-20 10:30:00	QQQ	ETF	518.99	520.38	518.73	519.34	1975211.0
2025-05-20 11:00:00	QQQ	ETF	519.33	519.92	518.86	519.69	1284097.0
2025-05-20 11:30:00	QQQ	ETF	519.69	520.25	518.93	520.0	1395180.0
2025-05-20 12:00:00	QQQ	ETF	520.0	520.15	519.23	519.89	1029028.0
2025-05-20 12:30:00	QQQ	ETF	519.89	520.88	519.84	520.565	1250770.0

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

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