PREVIEW / etf_30min / 2025-03-20

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-03-20.parquet
  size:    936 KB
  rows:    38,305

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-20 04:00:00	SPY	ETF	568.27	569.79	568.27	569.68	21388.0
2025-03-20 04:30:00	SPY	ETF	569.73	569.81	569.3	569.35	5050.0
2025-03-20 05:00:00	SPY	ETF	569.41	569.41	568.31	568.37	16850.0
2025-03-20 05:30:00	SPY	ETF	568.19	568.23	566.73	567.19	25685.0
2025-03-20 06:00:00	SPY	ETF	566.89	566.92	562.5	562.81	105447.0
2025-03-20 06:30:00	SPY	ETF	563.19	564.52	562.55	564.28	93168.0
2025-03-20 07:00:00	SPY	ETF	564.29	565.08	563.95	564.22	228968.0
2025-03-20 07:30:00	SPY	ETF	564.18	565.4	563.77	565.37	66331.0
2025-03-20 08:00:00	SPY	ETF	564.14	569.84	563.7625	564.6168	286170.0
2025-03-20 08:30:00	SPY	ETF	564.65	565.14	564.28	564.35	203591.0
2025-03-20 09:00:00	SPY	ETF	564.25	564.5592	563.19	563.3	329695.0
2025-03-20 09:30:00	SPY	ETF	563.33	566.77	562.6012	566.61	3614481.0
2025-03-20 10:00:00	SPY	ETF	566.65	570.05	566.46	569.48	3474618.0
2025-03-20 10:30:00	SPY	ETF	569.48	570.57	568.86	569.4	2000864.0
2025-03-20 11:00:00	SPY	ETF	569.43	569.88	568.7	568.94	1669569.0
2025-03-20 11:30:00	SPY	ETF	568.94	569.58	567.69	568.1698	1960575.0
2025-03-20 12:00:00	SPY	ETF	568.15	569.42	565.93	566.24	2184799.0
2025-03-20 12:30:00	SPY	ETF	566.23	567.05	565.61	565.87	1830740.0
2025-03-20 13:00:00	SPY	ETF	565.86	567.21	564.7	564.7494	1604557.0
2025-03-20 13:30:00	SPY	ETF	564.75	566.5	564.66	565.16	1627389.0
2025-03-20 14:00:00	SPY	ETF	565.19	566.2	564.04	564.12	1699594.0
2025-03-20 14:30:00	SPY	ETF	564.12	565.89	563.7703	564.45	2740407.0
2025-03-20 15:00:00	SPY	ETF	564.451	566.3188	564.38	564.67	2712652.0
2025-03-20 15:30:00	SPY	ETF	564.67	566.68	564.67	565.68	6112892.0
2025-03-20 16:00:00	SPY	ETF	565.69	566.1	565.49	566.09	4926718.0
2025-03-20 16:30:00	SPY	ETF	566.02	566.02	565.8	565.821	48821.0
2025-03-20 17:00:00	SPY	ETF	565.85	566.0	565.75	565.84	32209.0
2025-03-20 17:30:00	SPY	ETF	565.8688	565.8688	565.64	565.838	14353.0
2025-03-20 18:00:00	SPY	ETF	565.71	566.001	565.6	566.001	24586.0
2025-03-20 18:30:00	SPY	ETF	565.9406	566.17	565.68	565.69	9328.0
2025-03-20 19:00:00	SPY	ETF	565.73	565.73	564.96	565.22	29015.0
2025-03-20 19:30:00	SPY	ETF	565.1	565.77	564.98	565.68	41032.0
2025-03-20 04:00:00	QQQ	ETF	483.02	483.73	483.01	483.7	16614.0
2025-03-20 04:30:00	QQQ	ETF	483.72	483.78	483.22	483.27	23247.0
2025-03-20 05:00:00	QQQ	ETF	483.3	483.38	481.91	482.1	35286.0
2025-03-20 05:30:00	QQQ	ETF	482.0	482.05	480.41	480.95	78567.0
2025-03-20 06:00:00	QQQ	ETF	480.89	480.89	475.65	476.87	182318.0
2025-03-20 06:30:00	QQQ	ETF	476.86	477.84	476.13	477.66	137730.0
2025-03-20 07:00:00	QQQ	ETF	477.59	478.61	477.27	477.7	106463.0
2025-03-20 07:30:00	QQQ	ETF	477.7	478.61	477.14	478.42	165472.0
2025-03-20 08:00:00	QQQ	ETF	477.59	484.17	476.692	477.9222	202188.0
2025-03-20 08:30:00	QQQ	ETF	478.1	478.7	477.79	477.88	135413.0
2025-03-20 09:00:00	QQQ	ETF	477.88	477.88	476.75	476.82	261260.0
2025-03-20 09:30:00	QQQ	ETF	476.89	480.59	476.18	480.42	3141063.0
2025-03-20 10:00:00	QQQ	ETF	480.47	484.09	480.25	483.365	2440201.0
2025-03-20 10:30:00	QQQ	ETF	483.34	484.55	482.58	483.075	2076287.0
2025-03-20 11:00:00	QQQ	ETF	483.0521	483.55	482.29	482.83	1178452.0
2025-03-20 11:30:00	QQQ	ETF	482.82	483.4	481.26	481.74	1350637.0
2025-03-20 12:00:00	QQQ	ETF	481.73	483.0	478.94	479.22	1866659.0
2025-03-20 12:30:00	QQQ	ETF	479.2	480.2	478.75	479.11	1552487.0

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

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