PREVIEW / etf_30min / 2025-03-18

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-03-18.parquet
  size:    952 KB
  rows:    39,139

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-03-18 04:00:00	SPY	ETF	565.93	566.84	565.72	566.65	4876.0
2025-03-18 04:30:00	SPY	ETF	566.95	567.3	566.59	566.89	5823.0
2025-03-18 05:00:00	SPY	ETF	567.13	567.27	566.82	566.88	5015.0
2025-03-18 05:30:00	SPY	ETF	567.08	567.08	566.18	566.18	3573.0
2025-03-18 06:00:00	SPY	ETF	566.21	566.24	564.48	565.52	20802.0
2025-03-18 06:30:00	SPY	ETF	565.45	565.88	564.98	565.87	11477.0
2025-03-18 07:00:00	SPY	ETF	565.9	566.36	565.51	565.51	71448.0
2025-03-18 07:30:00	SPY	ETF	565.45	566.22	564.85	566.2	111521.0
2025-03-18 08:00:00	SPY	ETF	565.98	566.8267	564.7	565.78	228644.0
2025-03-18 08:30:00	SPY	ETF	565.79	566.15	564.45	564.55	155123.0
2025-03-18 09:00:00	SPY	ETF	564.5	565.0598	564.15	564.8	578278.0
2025-03-18 09:30:00	SPY	ETF	564.8	565.02	560.635	560.77	4833535.0
2025-03-18 10:00:00	SPY	ETF	560.78	561.6617	560.15	561.306	3047072.0
2025-03-18 10:30:00	SPY	ETF	561.29	562.07	560.33	560.79	2208511.0
2025-03-18 11:00:00	SPY	ETF	560.79	560.93	559.34	559.97	2145375.0
2025-03-18 11:30:00	SPY	ETF	559.94	560.82	559.06	559.61	1592515.0
2025-03-18 12:00:00	SPY	ETF	559.61	561.68	559.41	561.678	1794255.0
2025-03-18 12:30:00	SPY	ETF	561.66	561.81	559.33	560.8509	1576433.0
2025-03-18 13:00:00	SPY	ETF	560.86	561.24	559.22	560.56	1716875.0
2025-03-18 13:30:00	SPY	ETF	560.57	561.5587	560.03	560.82	1290481.0
2025-03-18 14:00:00	SPY	ETF	560.82	561.35	559.73	560.48	1169444.0
2025-03-18 14:30:00	SPY	ETF	560.49	562.215	560.41	561.3991	1448349.0
2025-03-18 15:00:00	SPY	ETF	561.37	561.7113	560.58	561.11	1459781.0
2025-03-18 15:30:00	SPY	ETF	561.12	561.45	559.84	561.05	5414309.0
2025-03-18 16:00:00	SPY	ETF	561.07	561.74	560.8007	561.06	12422619.0
2025-03-18 16:30:00	SPY	ETF	561.03	561.15	560.773	560.9	162643.0
2025-03-18 17:00:00	SPY	ETF	560.9	561.03	560.78	560.93	38213.0
2025-03-18 17:30:00	SPY	ETF	560.95	561.04	560.9	561.04	37118.0
2025-03-18 18:00:00	SPY	ETF	561.02	561.02	560.1	560.1	89153.0
2025-03-18 18:30:00	SPY	ETF	560.09	561.2292	560.09	561.03	47913.0
2025-03-18 19:00:00	SPY	ETF	561.19	561.2396	560.76	560.83	14069.0
2025-03-18 19:30:00	SPY	ETF	560.78	561.29	560.69	561.1999	37903.0
2025-03-18 04:00:00	QQQ	ETF	481.43	482.27	481.18	482.11	29357.0
2025-03-18 04:30:00	QQQ	ETF	482.2	482.69	482.0	482.21	22559.0
2025-03-18 05:00:00	QQQ	ETF	482.54	482.72	482.2	482.39	15687.0
2025-03-18 05:30:00	QQQ	ETF	482.43	482.43	481.35	481.35	32060.0
2025-03-18 06:00:00	QQQ	ETF	481.4	481.47	480.05	481.15	46688.0
2025-03-18 06:30:00	QQQ	ETF	481.0	481.44	480.37	481.44	15896.0
2025-03-18 07:00:00	QQQ	ETF	481.37	482.2	480.83	480.83	73160.0
2025-03-18 07:30:00	QQQ	ETF	480.8	481.35	480.16	481.12	70478.0
2025-03-18 08:00:00	QQQ	ETF	481.26	482.5104	480.0	480.96	152938.0
2025-03-18 08:30:00	QQQ	ETF	480.9	481.3	479.53	479.6388	160049.0
2025-03-18 09:00:00	QQQ	ETF	479.55	480.14	479.17	479.44	239187.0
2025-03-18 09:30:00	QQQ	ETF	479.41	479.61	473.63	474.02	4422089.0
2025-03-18 10:00:00	QQQ	ETF	474.02	475.07	473.17	474.67	2570056.0
2025-03-18 10:30:00	QQQ	ETF	474.66	475.4891	473.556	474.19	1606418.0
2025-03-18 11:00:00	QQQ	ETF	474.21	474.57	472.41	473.94	1563885.0
2025-03-18 11:30:00	QQQ	ETF	473.96	474.73	473.0	473.69	920036.0
2025-03-18 12:00:00	QQQ	ETF	473.7	475.88	473.48	475.8485	1225744.0
2025-03-18 12:30:00	QQQ	ETF	475.81	475.96	473.58	475.48	1258520.0

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

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