PREVIEW / etf_30min / 2025-05-16

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-05-16.parquet
  size:    962 KB
  rows:    39,321

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-16 04:00:00	SPY	ETF	591.13	591.64	590.53	591.61	17368.0
2025-05-16 04:30:00	SPY	ETF	591.59	591.95	591.4	591.64	18241.0
2025-05-16 05:00:00	SPY	ETF	591.68	591.79	591.46	591.68	6463.0
2025-05-16 05:30:00	SPY	ETF	591.54	591.54	591.28	591.31	12681.0
2025-05-16 06:00:00	SPY	ETF	591.22	591.73	591.17	591.58	13374.0
2025-05-16 06:30:00	SPY	ETF	591.77	591.96	591.58	591.63	16062.0
2025-05-16 07:00:00	SPY	ETF	591.65	592.19	591.47	592.17	55952.0
2025-05-16 07:30:00	SPY	ETF	592.14	592.34	591.8	592.23	93495.0
2025-05-16 08:00:00	SPY	ETF	591.97	592.53	589.57	592.5094	211678.0
2025-05-16 08:30:00	SPY	ETF	592.49	592.57	589.42	591.27	193575.0
2025-05-16 09:00:00	SPY	ETF	591.26	591.82	590.81	591.22	392107.0
2025-05-16 09:30:00	SPY	ETF	591.25	591.42	590.01	591.36	4236682.0
2025-05-16 10:00:00	SPY	ETF	591.31	591.63	590.2	590.89	3096900.0
2025-05-16 10:30:00	SPY	ETF	590.89	590.91	589.28	590.46	3246314.0
2025-05-16 11:00:00	SPY	ETF	590.46	591.08	590.385	590.9	1837002.0
2025-05-16 11:30:00	SPY	ETF	590.89	591.62	590.88	591.045	1939918.0
2025-05-16 12:00:00	SPY	ETF	591.04	592.28	590.92	592.06	2112811.0
2025-05-16 12:30:00	SPY	ETF	592.07	592.51	591.7799	592.23	1979363.0
2025-05-16 13:00:00	SPY	ETF	592.25	593.29	592.0949	593.09	2086460.0
2025-05-16 13:30:00	SPY	ETF	593.1	593.48	592.58	592.82	2279451.0
2025-05-16 14:00:00	SPY	ETF	592.82	593.43	592.66	593.26	1875741.0
2025-05-16 14:30:00	SPY	ETF	593.26	594.0299	593.0507	593.57	2514774.0
2025-05-16 15:00:00	SPY	ETF	593.565	594.3493	593.53	593.855	2645460.0
2025-05-16 15:30:00	SPY	ETF	593.85	594.5	593.19	594.29	7605481.0
2025-05-16 16:00:00	SPY	ETF	594.29	594.3897	593.89	594.1	3396725.0
2025-05-16 16:30:00	SPY	ETF	594.1	594.12	590.7	591.55	911551.0
2025-05-16 17:00:00	SPY	ETF	591.7	592.16	591.5995	591.95	361794.0
2025-05-16 17:30:00	SPY	ETF	591.92	592.2	590.35	590.72	378007.0
2025-05-16 18:00:00	SPY	ETF	590.72	591.0	589.4004	589.49	136061.0
2025-05-16 18:30:00	SPY	ETF	589.4489	594.4197	588.43	588.87	833695.0
2025-05-16 19:00:00	SPY	ETF	588.87	589.5	588.43	588.46	66617.0
2025-05-16 19:30:00	SPY	ETF	588.43	588.76	588.2	588.25	77052.0
2025-05-16 04:00:00	QQQ	ETF	519.02	520.67	519.02	520.6	26119.0
2025-05-16 04:30:00	QQQ	ETF	520.57	520.95	520.22	520.55	38298.0
2025-05-16 05:00:00	QQQ	ETF	520.6	520.65	520.26	520.52	19306.0
2025-05-16 05:30:00	QQQ	ETF	520.5	520.5	520.0	520.0	25652.0
2025-05-16 06:00:00	QQQ	ETF	519.98	520.45	519.81	520.24	35041.0
2025-05-16 06:30:00	QQQ	ETF	520.35	520.76	520.29	520.45	26838.0
2025-05-16 07:00:00	QQQ	ETF	520.48	521.13	520.24	521.02	72354.0
2025-05-16 07:30:00	QQQ	ETF	521.04	521.07	520.62	520.93	43239.0
2025-05-16 08:00:00	QQQ	ETF	520.56	521.5	518.15	521.36	147143.0
2025-05-16 08:30:00	QQQ	ETF	521.33	521.44	519.9	519.99	269033.0
2025-05-16 09:00:00	QQQ	ETF	520.0	522.0	519.63	520.7	1039971.0
2025-05-16 09:30:00	QQQ	ETF	520.69	520.73	518.79	519.97	3534986.0
2025-05-16 10:00:00	QQQ	ETF	520.0	520.37	518.86	519.335	3011369.0
2025-05-16 10:30:00	QQQ	ETF	519.35	519.36	517.1	518.7868	2856597.0
2025-05-16 11:00:00	QQQ	ETF	518.79	519.18	518.39	518.98	1360042.0
2025-05-16 11:30:00	QQQ	ETF	518.99	520.02	518.96	519.295	1557388.0
2025-05-16 12:00:00	QQQ	ETF	519.295	520.24	519.14	519.84	1509099.0
2025-05-16 12:30:00	QQQ	ETF	519.85	520.13	519.4	519.66	1199659.0

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

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