PREVIEW / etf_30min / 2024-12-26

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-12-26.parquet
  size:    885 KB
  rows:    35,730

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
2024-12-26 04:00:00	SPY	ETF	600.5	600.5	599.36	599.5	32991.0
2024-12-26 04:30:00	SPY	ETF	599.59	599.9	599.0	599.18	6917.0
2024-12-26 05:00:00	SPY	ETF	598.93	598.93	598.54	598.68	5917.0
2024-12-26 05:30:00	SPY	ETF	598.77	599.05	598.76	598.95	9473.0
2024-12-26 06:00:00	SPY	ETF	598.72	598.87	598.35	598.84	7009.0
2024-12-26 06:30:00	SPY	ETF	598.99	599.21	598.96	599.21	5937.0
2024-12-26 07:00:00	SPY	ETF	599.19	599.48	599.12	599.48	28090.0
2024-12-26 07:30:00	SPY	ETF	599.35	599.45	599.0	599.33	14117.0
2024-12-26 08:00:00	SPY	ETF	599.39	601.69	598.8096	599.3	100466.0
2024-12-26 08:30:00	SPY	ETF	599.32	599.46	598.69	599.13	83970.0
2024-12-26 09:00:00	SPY	ETF	599.12	599.49	598.97	599.46	154342.0
2024-12-26 09:30:00	SPY	ETF	599.46	600.27	598.0825	599.9	2535357.0
2024-12-26 10:00:00	SPY	ETF	599.92	600.4	599.41	600.29	1571651.0
2024-12-26 10:30:00	SPY	ETF	600.285	600.91	599.79	600.88	1343208.0
2024-12-26 11:00:00	SPY	ETF	600.89	601.2785	600.53	600.83	954376.0
2024-12-26 11:30:00	SPY	ETF	600.84	601.91	600.8	601.81	953677.0
2024-12-26 12:00:00	SPY	ETF	601.84	602.48	601.4825	601.51	627527.0
2024-12-26 12:30:00	SPY	ETF	601.51	602.05	600.35	600.99	1043142.0
2024-12-26 13:00:00	SPY	ETF	600.9596	601.82	600.89	601.67	730866.0
2024-12-26 13:30:00	SPY	ETF	601.68	601.77	600.75	601.32	740672.0
2024-12-26 14:00:00	SPY	ETF	601.265	601.27	600.66	600.9	923455.0
2024-12-26 14:30:00	SPY	ETF	600.97	601.81	600.8402	601.745	660907.0
2024-12-26 15:00:00	SPY	ETF	601.74	602.1	601.42	601.79	1040437.0
2024-12-26 15:30:00	SPY	ETF	601.79	602.025	601.06	601.25	3139618.0
2024-12-26 16:00:00	SPY	ETF	601.23	601.56	600.93	601.09	8201250.0
2024-12-26 16:30:00	SPY	ETF	601.05	601.2151	600.93	600.99	400879.0
2024-12-26 17:00:00	SPY	ETF	600.99	601.07	600.99	601.0	35049.0
2024-12-26 17:30:00	SPY	ETF	601.04	601.09	600.87	600.91	26656.0
2024-12-26 18:00:00	SPY	ETF	600.91	601.09	600.8	601.05	21770.0
2024-12-26 18:30:00	SPY	ETF	601.0	601.23	600.93	601.15	17465.0
2024-12-26 19:00:00	SPY	ETF	601.17	601.3	600.25	600.45	13897.0
2024-12-26 19:30:00	SPY	ETF	600.54	600.6	600.33	600.41	37780.0
2024-12-26 04:00:00	QQQ	ETF	529.88	529.95	527.81	528.15	57525.0
2024-12-26 04:30:00	QQQ	ETF	528.19	528.79	527.48	527.7	33550.0
2024-12-26 05:00:00	QQQ	ETF	527.49	527.49	526.77	527.39	23506.0
2024-12-26 05:30:00	QQQ	ETF	527.4	527.8	527.2	527.73	22062.0
2024-12-26 06:00:00	QQQ	ETF	527.68	527.98	527.32	527.87	17006.0
2024-12-26 06:30:00	QQQ	ETF	527.96	528.34	527.81	528.31	47587.0
2024-12-26 07:00:00	QQQ	ETF	528.34	528.65	528.03	528.42	46830.0
2024-12-26 07:30:00	QQQ	ETF	528.4	528.4	527.63	528.05	118346.0
2024-12-26 08:00:00	QQQ	ETF	528.5	531.52	526.876	528.0	161513.0
2024-12-26 08:30:00	QQQ	ETF	527.8	528.33	527.37	528.1	141931.0
2024-12-26 09:00:00	QQQ	ETF	527.96	528.37	527.81	528.26	150260.0
2024-12-26 09:30:00	QQQ	ETF	528.34	529.54	526.31	528.3701	2039097.0
2024-12-26 10:00:00	QQQ	ETF	528.37	529.28	527.7	529.26	1124896.0
2024-12-26 10:30:00	QQQ	ETF	529.24	529.7119	528.7	529.66	770090.0
2024-12-26 11:00:00	QQQ	ETF	529.63	529.94	528.9	529.28	792349.0
2024-12-26 11:30:00	QQQ	ETF	529.28	530.455	529.24	530.44	719908.0
2024-12-26 12:00:00	QQQ	ETF	530.42	531.24	530.07	530.1	1029381.0
2024-12-26 12:30:00	QQQ	ETF	530.14	530.71	528.83	529.615	856279.0

> showing 50 of 35,730 rows — these rows as CSV

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