PREVIEW / etf_30min / 2025-03-27

all etf 30-min files

  file:    by_date/etf_30min/2025/2025-03-27.parquet
  size:    927 KB
  rows:    37,733

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-27 04:00:00	SPY	ETF	568.46	568.83	567.27	568.42	46130.0
2025-03-27 04:30:00	SPY	ETF	568.48	569.25	568.26	569.22	25638.0
2025-03-27 05:00:00	SPY	ETF	569.17	569.47	568.87	569.45	12030.0
2025-03-27 05:30:00	SPY	ETF	569.46	569.62	569.09	569.5	18557.0
2025-03-27 06:00:00	SPY	ETF	569.53	569.82	569.22	569.3	30248.0
2025-03-27 06:30:00	SPY	ETF	569.28	569.46	568.4	568.44	24706.0
2025-03-27 07:00:00	SPY	ETF	568.3	568.87	567.4	567.47	85125.0
2025-03-27 07:30:00	SPY	ETF	567.59	568.83	567.5	568.71	67997.0
2025-03-27 08:00:00	SPY	ETF	567.91	570.0	567.41	567.96	197735.0
2025-03-27 08:30:00	SPY	ETF	568.19	568.96	567.92	568.25	128816.0
2025-03-27 09:00:00	SPY	ETF	568.0	568.3	566.85	567.17	174361.0
2025-03-27 09:30:00	SPY	ETF	567.2	568.43	564.94	568.33	4690807.0
2025-03-27 10:00:00	SPY	ETF	568.31	569.58	567.53	569.52	2396400.0
2025-03-27 10:30:00	SPY	ETF	569.52	570.8	569.25	570.8	2356356.0
2025-03-27 11:00:00	SPY	ETF	570.8	570.9	569.81	569.86	1342099.0
2025-03-27 11:30:00	SPY	ETF	569.88	569.88	567.85	567.94	1923328.0
2025-03-27 12:00:00	SPY	ETF	567.96	569.9102	567.79	568.645	1301738.0
2025-03-27 12:30:00	SPY	ETF	568.65	569.3	566.6001	566.66	1328855.0
2025-03-27 13:00:00	SPY	ETF	566.66	568.19	566.38	566.76	1586417.0
2025-03-27 13:30:00	SPY	ETF	566.79	567.7676	566.423	566.635	1139957.0
2025-03-27 14:00:00	SPY	ETF	566.65	568.68	566.56	567.96	1375432.0
2025-03-27 14:30:00	SPY	ETF	567.92	569.1875	567.42	567.56	1296076.0
2025-03-27 15:00:00	SPY	ETF	567.54	570.03	567.43	569.78	2346096.0
2025-03-27 15:30:00	SPY	ETF	569.76	569.81	566.72	567.0	6582567.0
2025-03-27 16:00:00	SPY	ETF	567.02	567.51	566.92	567.29	2099461.0
2025-03-27 16:30:00	SPY	ETF	567.3	567.5	567.0	567.0	70522.0
2025-03-27 17:00:00	SPY	ETF	567.14	567.14	566.871	566.97	70278.0
2025-03-27 17:30:00	SPY	ETF	567.02	567.05	567.0	567.05	23388.0
2025-03-27 18:00:00	SPY	ETF	566.99	567.34	566.85	567.06	62530.0
2025-03-27 18:30:00	SPY	ETF	567.02	567.22	566.9	566.93	16256.0
2025-03-27 19:00:00	SPY	ETF	566.9	566.9	566.2	566.4799	25820.0
2025-03-27 19:30:00	SPY	ETF	566.41	566.65	566.17	566.57	36463.0
2025-03-27 04:00:00	QQQ	ETF	483.54	483.91	482.3	483.42	87957.0
2025-03-27 04:30:00	QQQ	ETF	483.47	484.45	483.36	484.41	67402.0
2025-03-27 05:00:00	QQQ	ETF	484.45	484.73	484.04	484.66	78347.0
2025-03-27 05:30:00	QQQ	ETF	484.6	484.8	484.09	484.53	11040.0
2025-03-27 06:00:00	QQQ	ETF	484.63	485.1	484.36	484.47	29237.0
2025-03-27 06:30:00	QQQ	ETF	484.54	484.66	483.55	483.55	43384.0
2025-03-27 07:00:00	QQQ	ETF	483.59	484.09	482.52	482.64	143074.0
2025-03-27 07:30:00	QQQ	ETF	482.63	484.0	482.53	483.86	121671.0
2025-03-27 08:00:00	QQQ	ETF	483.45	485.21	482.61	483.13	332436.0
2025-03-27 08:30:00	QQQ	ETF	483.33	484.23	483.15	483.35	224731.0
2025-03-27 09:00:00	QQQ	ETF	483.35	483.66	482.07	482.39	251275.0
2025-03-27 09:30:00	QQQ	ETF	482.41	483.91	480.25	483.59	4453202.0
2025-03-27 10:00:00	QQQ	ETF	483.57	484.69	482.41	484.69	2049931.0
2025-03-27 10:30:00	QQQ	ETF	484.69	486.5799	484.3417	486.35	2056173.0
2025-03-27 11:00:00	QQQ	ETF	486.385	486.45	484.92	484.97	1235134.0
2025-03-27 11:30:00	QQQ	ETF	484.99	484.99	482.78	482.91	1696059.0
2025-03-27 12:00:00	QQQ	ETF	482.92	485.48	482.69	483.665	1659606.0
2025-03-27 12:30:00	QQQ	ETF	483.71	484.42	481.91	481.97	1134089.0

> showing 50 of 37,733 rows — these rows as CSV

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