PREVIEW / etf_30min / 2024-05-28

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-05-28.parquet
  size:    817 KB
  rows:    33,009

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-05-28 04:00:00	SPY	ETF	530.28	531.08	530.27	530.98	23763.0
2024-05-28 04:30:00	SPY	ETF	531.12	531.24	531.11	531.13	1400.0
2024-05-28 05:00:00	SPY	ETF	531.16	531.24	531.12	531.24	4967.0
2024-05-28 05:30:00	SPY	ETF	531.05	531.19	531.01	531.17	7060.0
2024-05-28 06:00:00	SPY	ETF	531.05	531.06	529.91	530.01	17482.0
2024-05-28 06:30:00	SPY	ETF	529.9	530.28	529.9	530.05	17333.0
2024-05-28 07:00:00	SPY	ETF	529.93	530.33	529.93	530.11	75633.0
2024-05-28 07:30:00	SPY	ETF	530.13	530.36	530.09	530.22	50820.0
2024-05-28 08:00:00	SPY	ETF	530.1	530.57	529.9	530.4	74682.0
2024-05-28 08:30:00	SPY	ETF	530.37	530.49	529.86	530.26	52252.0
2024-05-28 09:00:00	SPY	ETF	530.26	530.45	529.92	530.25	132916.0
2024-05-28 09:30:00	SPY	ETF	530.26	530.51	529.12	529.355	3251851.0
2024-05-28 10:00:00	SPY	ETF	529.35	529.86	529.0	529.56	1804580.0
2024-05-28 10:30:00	SPY	ETF	529.54	530.16	529.16	529.9179	1199591.0
2024-05-28 11:00:00	SPY	ETF	529.91	529.96	529.361	529.86	975392.0
2024-05-28 11:30:00	SPY	ETF	529.87	530.1	529.64	530.0004	618121.0
2024-05-28 12:00:00	SPY	ETF	530.0	530.295	529.65	529.805	668743.0
2024-05-28 12:30:00	SPY	ETF	529.805	530.25	529.64	529.7375	859185.0
2024-05-28 13:00:00	SPY	ETF	529.7574	529.93	529.15	529.48	1131930.0
2024-05-28 13:30:00	SPY	ETF	529.475	529.85	528.51	528.79	1504590.0
2024-05-28 14:00:00	SPY	ETF	528.78	529.35	528.21	528.27	1998423.0
2024-05-28 14:30:00	SPY	ETF	528.26	528.35	527.11	528.29	2303136.0
2024-05-28 15:00:00	SPY	ETF	528.29	528.98	528.06	528.35	1590485.0
2024-05-28 15:30:00	SPY	ETF	528.35	529.9	528.29	529.87	5147540.0
2024-05-28 16:00:00	SPY	ETF	529.87	530.38	529.57	529.79	2727670.0
2024-05-28 16:30:00	SPY	ETF	529.78	529.84	529.7	529.74	373089.0
2024-05-28 17:00:00	SPY	ETF	529.72	529.8	529.6	529.78	31194.0
2024-05-28 17:30:00	SPY	ETF	529.7721	529.8	529.63	529.66	10734.0
2024-05-28 18:00:00	SPY	ETF	529.65	529.67	529.35	529.37	22288.0
2024-05-28 18:30:00	SPY	ETF	529.419	529.5	529.419	529.5	8928.0
2024-05-28 19:00:00	SPY	ETF	529.5	529.54	529.48	529.51	4649.0
2024-05-28 19:30:00	SPY	ETF	529.49	529.49	529.17	529.27	14596.0
2024-05-28 04:00:00	QQQ	ETF	459.09	460.31	459.09	460.14	59599.0
2024-05-28 04:30:00	QQQ	ETF	460.15	460.57	460.13	460.52	15337.0
2024-05-28 05:00:00	QQQ	ETF	460.54	460.54	460.33	460.43	3507.0
2024-05-28 05:30:00	QQQ	ETF	460.3	460.5	460.21	460.35	24053.0
2024-05-28 06:00:00	QQQ	ETF	460.32	460.38	459.09	459.18	37629.0
2024-05-28 06:30:00	QQQ	ETF	459.09	459.47	459.04	459.16	84756.0
2024-05-28 07:00:00	QQQ	ETF	459.11	459.46	458.95	459.13	63776.0
2024-05-28 07:30:00	QQQ	ETF	459.15	459.36	458.92	459.28	65524.0
2024-05-28 08:00:00	QQQ	ETF	459.005	460.3404	458.293	459.22	82559.0
2024-05-28 08:30:00	QQQ	ETF	459.24	459.33	458.74	459.09	85396.0
2024-05-28 09:00:00	QQQ	ETF	459.09	459.32	458.75	459.18	95080.0
2024-05-28 09:30:00	QQQ	ETF	459.18	459.56	457.09	457.8	2871012.0
2024-05-28 10:00:00	QQQ	ETF	457.77	458.7	457.25	458.53	1568347.0
2024-05-28 10:30:00	QQQ	ETF	458.53	459.37	458.07	459.23	1183794.0
2024-05-28 11:00:00	QQQ	ETF	459.24	459.3	458.6	459.275	944459.0
2024-05-28 11:30:00	QQQ	ETF	459.28	459.54	459.0	459.18	679331.0
2024-05-28 12:00:00	QQQ	ETF	459.18	459.49	458.87	459.02	792534.0
2024-05-28 12:30:00	QQQ	ETF	459.03	459.67	458.8794	459.15	817187.0

> showing 50 of 33,009 rows — these rows as CSV

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