PREVIEW / etf_30min / 2025-03-17

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-03-17.parquet
  size:    981 KB
  rows:    39,861

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-17 04:00:00	SPY	ETF	559.83	560.39	559.41	560.39	26916.0
2025-03-17 04:30:00	SPY	ETF	559.89	560.56	559.8	560.56	3808.0
2025-03-17 05:00:00	SPY	ETF	560.35	560.67	560.13	560.44	21644.0
2025-03-17 05:30:00	SPY	ETF	560.59	560.9	560.45	560.52	32906.0
2025-03-17 06:00:00	SPY	ETF	560.35	561.17	560.35	561.09	15134.0
2025-03-17 06:30:00	SPY	ETF	561.17	561.96	561.07	561.91	10234.0
2025-03-17 07:00:00	SPY	ETF	561.95	562.55	561.94	562.06	57723.0
2025-03-17 07:30:00	SPY	ETF	562.09	562.34	561.49	561.49	85379.0
2025-03-17 08:00:00	SPY	ETF	562.27	562.4496	559.18	561.0	189359.0
2025-03-17 08:30:00	SPY	ETF	561.38	563.9	560.66	563.2	468510.0
2025-03-17 09:00:00	SPY	ETF	563.16	563.29	562.27	562.7	156058.0
2025-03-17 09:30:00	SPY	ETF	562.77	566.36	562.35	565.65	4583623.0
2025-03-17 10:00:00	SPY	ETF	565.7	566.2863	564.3224	564.64	2262168.0
2025-03-17 10:30:00	SPY	ETF	564.63	565.69	563.67	563.98	1914762.0
2025-03-17 11:00:00	SPY	ETF	564.02	565.23	563.5	564.15	1616903.0
2025-03-17 11:30:00	SPY	ETF	564.13	564.47	562.8	563.8142	1512838.0
2025-03-17 12:00:00	SPY	ETF	563.83	565.27	563.29	563.8499	1069755.0
2025-03-17 12:30:00	SPY	ETF	563.84	564.95	563.4503	564.6	1171753.0
2025-03-17 13:00:00	SPY	ETF	564.595	566.0	563.9616	565.81	1202866.0
2025-03-17 13:30:00	SPY	ETF	565.82	567.37	565.61	567.115	1633521.0
2025-03-17 14:00:00	SPY	ETF	567.1	568.909	567.085	568.6524	2723875.0
2025-03-17 14:30:00	SPY	ETF	568.655	569.71	568.495	569.2	2220864.0
2025-03-17 15:00:00	SPY	ETF	569.17	569.31	568.38	569.045	2237128.0
2025-03-17 15:30:00	SPY	ETF	569.03	569.3	566.82	567.02	6177790.0
2025-03-17 16:00:00	SPY	ETF	567.02	567.15	566.39	566.9702	3470514.0
2025-03-17 16:30:00	SPY	ETF	566.96	567.12	566.78	566.98	138028.0
2025-03-17 17:00:00	SPY	ETF	567.03	567.07	566.6499	566.65	151258.0
2025-03-17 17:30:00	SPY	ETF	566.65	566.97	566.65	566.89	22886.0
2025-03-17 18:00:00	SPY	ETF	566.89	567.45	566.89	567.32	87601.0
2025-03-17 18:30:00	SPY	ETF	567.35	567.58	567.35	567.46	19922.0
2025-03-17 19:00:00	SPY	ETF	567.49	567.49	566.8	566.97	20502.0
2025-03-17 19:30:00	SPY	ETF	567.02	567.1801	566.95	566.98	23869.0
2025-03-17 04:00:00	QQQ	ETF	476.99	477.6	476.64	477.52	41564.0
2025-03-17 04:30:00	QQQ	ETF	477.44	477.85	477.09	477.63	20119.0
2025-03-17 05:00:00	QQQ	ETF	477.58	477.87	477.28	477.63	15196.0
2025-03-17 05:30:00	QQQ	ETF	477.49	478.04	477.49	477.74	19931.0
2025-03-17 06:00:00	QQQ	ETF	477.77	478.48	477.73	478.41	33743.0
2025-03-17 06:30:00	QQQ	ETF	478.36	479.32	478.31	479.17	50021.0
2025-03-17 07:00:00	QQQ	ETF	479.06	479.9	478.98	479.5	58560.0
2025-03-17 07:30:00	QQQ	ETF	479.6	479.93	479.13	479.21	72515.0
2025-03-17 08:00:00	QQQ	ETF	479.22	479.96	476.12	478.82	246138.0
2025-03-17 08:30:00	QQQ	ETF	479.28	481.46	478.76	480.83	365256.0
2025-03-17 09:00:00	QQQ	ETF	480.8	480.8	479.31	479.5	234191.0
2025-03-17 09:30:00	QQQ	ETF	479.6	483.14	479.18	481.6954	3723820.0
2025-03-17 10:00:00	QQQ	ETF	481.71	482.36	479.88	479.96	1971413.0
2025-03-17 10:30:00	QQQ	ETF	479.95	480.96	478.83	479.19	1565982.0
2025-03-17 11:00:00	QQQ	ETF	479.23	480.34	478.42	479.105	1372929.0
2025-03-17 11:30:00	QQQ	ETF	479.08	479.54	477.8	479.06	1178450.0
2025-03-17 12:00:00	QQQ	ETF	479.07	480.61	478.49	478.74	971922.0
2025-03-17 12:30:00	QQQ	ETF	478.78	479.87	478.44	479.51	918625.0

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

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