PREVIEW / etf_30min / 2025-03-19

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-03-19.parquet
  size:    947 KB
  rows:    38,240

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-19 04:00:00	SPY	ETF	562.09	562.09	560.13	561.2	21767.0
2025-03-19 04:30:00	SPY	ETF	561.5	561.95	561.39	561.55	5601.0
2025-03-19 05:00:00	SPY	ETF	561.26	561.75	560.87	561.7	4206.0
2025-03-19 05:30:00	SPY	ETF	561.99	562.5	561.89	562.5	9448.0
2025-03-19 06:00:00	SPY	ETF	562.5	562.6	562.28	562.55	9368.0
2025-03-19 06:30:00	SPY	ETF	562.67	562.8	562.18	562.34	16745.0
2025-03-19 07:00:00	SPY	ETF	562.35	562.64	562.2	562.5	51484.0
2025-03-19 07:30:00	SPY	ETF	562.45	562.86	561.88	562.55	64840.0
2025-03-19 08:00:00	SPY	ETF	562.3255	562.8686	560.26	561.78	172568.0
2025-03-19 08:30:00	SPY	ETF	561.8	562.35	561.5896	562.1	64499.0
2025-03-19 09:00:00	SPY	ETF	562.08	562.79	561.76	562.73	171132.0
2025-03-19 09:30:00	SPY	ETF	562.83	564.45	561.63	563.92	2841335.0
2025-03-19 10:00:00	SPY	ETF	563.94	565.38	563.94	564.48	2085964.0
2025-03-19 10:30:00	SPY	ETF	564.5	564.8698	563.3009	563.52	1526181.0
2025-03-19 11:00:00	SPY	ETF	563.4997	564.78	563.35	564.57	1239415.0
2025-03-19 11:30:00	SPY	ETF	564.57	566.29	564.34	565.78	1563749.0
2025-03-19 12:00:00	SPY	ETF	565.77	566.21	565.04	565.5598	1160713.0
2025-03-19 12:30:00	SPY	ETF	565.54	565.65	564.67	564.955	923480.0
2025-03-19 13:00:00	SPY	ETF	564.95	565.166	563.28	563.35	1245810.0
2025-03-19 13:30:00	SPY	ETF	563.38	564.25	562.72	563.18	1245087.0
2025-03-19 14:00:00	SPY	ETF	563.18	565.88	562.0	564.61	3565078.0
2025-03-19 14:30:00	SPY	ETF	564.57	568.53	564.57	568.25	3948915.0
2025-03-19 15:00:00	SPY	ETF	568.24	570.95	566.5749	567.2301	6502048.0
2025-03-19 15:30:00	SPY	ETF	567.2	569.38	566.68	567.01	7731963.0
2025-03-19 16:00:00	SPY	ETF	567.02	567.73	566.8495	567.17	10071983.0
2025-03-19 16:30:00	SPY	ETF	567.14	567.24	566.96	566.99	61054.0
2025-03-19 17:00:00	SPY	ETF	567.0999	567.23	567.04	567.23	53462.0
2025-03-19 17:30:00	SPY	ETF	567.23	567.31	567.15	567.31	21843.0
2025-03-19 18:00:00	SPY	ETF	567.21	568.18	567.04	568.1	88134.0
2025-03-19 18:30:00	SPY	ETF	568.02	568.68	568.0	568.3	27467.0
2025-03-19 19:00:00	SPY	ETF	568.35	568.43	568.17	568.39	7883.0
2025-03-19 19:30:00	SPY	ETF	568.27	568.77	568.27	568.7	65545.0
2025-03-19 04:00:00	QQQ	ETF	474.77	475.18	474.01	475.17	32967.0
2025-03-19 04:30:00	QQQ	ETF	475.13	475.78	475.13	475.35	21819.0
2025-03-19 05:00:00	QQQ	ETF	475.23	475.75	474.82	475.75	18071.0
2025-03-19 05:30:00	QQQ	ETF	475.65	476.23	475.65	476.14	29697.0
2025-03-19 06:00:00	QQQ	ETF	476.25	476.63	476.12	476.29	33130.0
2025-03-19 06:30:00	QQQ	ETF	476.5	476.68	475.81	476.02	31287.0
2025-03-19 07:00:00	QQQ	ETF	475.96	476.55	475.91	476.36	39698.0
2025-03-19 07:30:00	QQQ	ETF	476.32	476.83	475.88	476.46	112099.0
2025-03-19 08:00:00	QQQ	ETF	476.46	476.78	473.98	475.98	125116.0
2025-03-19 08:30:00	QQQ	ETF	476.03	476.44	475.75	476.25	64103.0
2025-03-19 09:00:00	QQQ	ETF	476.22	476.89	475.9	476.82	124487.0
2025-03-19 09:30:00	QQQ	ETF	476.81	478.13	474.87	477.62	2553141.0
2025-03-19 10:00:00	QQQ	ETF	477.62	479.5	477.62	478.27	1571925.0
2025-03-19 10:30:00	QQQ	ETF	478.3	478.65	476.88	477.0515	1020443.0
2025-03-19 11:00:00	QQQ	ETF	477.05	479.0785	476.89	478.881	989175.0
2025-03-19 11:30:00	QQQ	ETF	478.8988	480.4	478.58	479.961	1041942.0
2025-03-19 12:00:00	QQQ	ETF	479.98	480.3026	479.1099	479.67	946581.0
2025-03-19 12:30:00	QQQ	ETF	479.65	479.73	478.46	478.9208	649559.0

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

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