PREVIEW / etf_30min / 2023-02-22

all etf 30-min files

  file:    by_date/etf_30min/2023/2023-02-22.parquet
  size:    687 KB
  rows:    27,692

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
2023-02-22 04:00:00	SPY	ETF	399.31	399.7	399.22	399.36	16285.0
2023-02-22 04:30:00	SPY	ETF	399.29	399.74	398.72	399.49	10980.0
2023-02-22 05:00:00	SPY	ETF	399.28	399.48	398.79	399.02	14989.0
2023-02-22 05:30:00	SPY	ETF	399.14	399.48	399.06	399.25	2399.0
2023-02-22 06:00:00	SPY	ETF	399.33	399.4	398.71	398.72	11892.0
2023-02-22 06:30:00	SPY	ETF	398.74	399.02	398.22	399.02	50214.0
2023-02-22 07:00:00	SPY	ETF	399.08	400.2	399.0	400.2	182922.0
2023-02-22 07:30:00	SPY	ETF	400.15	400.66	400.03	400.25	270686.0
2023-02-22 08:00:00	SPY	ETF	398.9939	400.64	398.9939	399.71	368141.0
2023-02-22 08:30:00	SPY	ETF	399.73	400.2	399.66	399.93	339228.0
2023-02-22 09:00:00	SPY	ETF	399.94	400.12	399.45	399.52	182598.0
2023-02-22 09:30:00	SPY	ETF	399.51	400.47	399.29	399.73	6188573.0
2023-02-22 10:00:00	SPY	ETF	399.72	399.81	397.91	398.435	4831306.0
2023-02-22 10:30:00	SPY	ETF	398.41	399.41	397.621	399.106	4786830.0
2023-02-22 11:00:00	SPY	ETF	399.11	399.44	398.59	399.01	2804490.0
2023-02-22 11:30:00	SPY	ETF	399.02	399.6	398.84	399.4399	2012808.0
2023-02-22 12:00:00	SPY	ETF	399.44	400.2	399.0836	399.86	3059135.0
2023-02-22 12:30:00	SPY	ETF	399.87	400.55	399.87	400.105	2194129.0
2023-02-22 13:00:00	SPY	ETF	400.11	400.8801	399.81	400.81	2143334.0
2023-02-22 13:30:00	SPY	ETF	400.81	400.88	400.0	400.3599	2226525.0
2023-02-22 14:00:00	SPY	ETF	400.3563	401.13	398.6	399.19	8071033.0
2023-02-22 14:30:00	SPY	ETF	399.19	399.2897	397.51	397.5899	5865205.0
2023-02-22 15:00:00	SPY	ETF	397.57	398.39	397.29	397.58	5330800.0
2023-02-22 15:30:00	SPY	ETF	397.57	398.71	397.02	398.58	10705991.0
2023-02-22 16:00:00	SPY	ETF	398.6	398.81	398.39	398.53	3774646.0
2023-02-22 16:30:00	SPY	ETF	398.55	399.53	398.44	399.4	230597.0
2023-02-22 17:00:00	SPY	ETF	399.48	399.6	399.02	399.5	193361.0
2023-02-22 17:30:00	SPY	ETF	399.5	399.6	399.45	399.6	16924.0
2023-02-22 18:00:00	SPY	ETF	399.6	399.6	399.2	399.41	39576.0
2023-02-22 18:30:00	SPY	ETF	399.41	399.62	399.29	399.59	25760.0
2023-02-22 19:00:00	SPY	ETF	399.63	399.86	399.6	399.82	26503.0
2023-02-22 19:30:00	SPY	ETF	399.83	399.85	399.55	399.66	57219.0
2023-02-22 04:00:00	QQQ	ETF	294.44	294.65	294.06	294.14	31948.0
2023-02-22 04:30:00	QQQ	ETF	293.98	294.59	293.46	294.4	39031.0
2023-02-22 05:00:00	QQQ	ETF	294.25	294.31	293.73	294.06	22724.0
2023-02-22 05:30:00	QQQ	ETF	293.85	294.44	293.84	294.12	8409.0
2023-02-22 06:00:00	QQQ	ETF	294.18	294.24	293.66	293.71	20969.0
2023-02-22 06:30:00	QQQ	ETF	293.82	294.06	293.24	294.06	92567.0
2023-02-22 07:00:00	QQQ	ETF	294.07	295.25	293.91	295.25	252029.0
2023-02-22 07:30:00	QQQ	ETF	295.11	295.64	295.05	295.22	176028.0
2023-02-22 08:00:00	QQQ	ETF	293.96	295.5801	293.5504	294.65	320015.0
2023-02-22 08:30:00	QQQ	ETF	294.7	295.06	294.63	294.9	243310.0
2023-02-22 09:00:00	QQQ	ETF	294.9	295.02	294.62	294.66	193608.0
2023-02-22 09:30:00	QQQ	ETF	294.62	295.98	294.5399	294.7	5731921.0
2023-02-22 10:00:00	QQQ	ETF	294.73	294.78	292.71	293.16	3702956.0
2023-02-22 10:30:00	QQQ	ETF	293.17	294.46	292.56	294.16	2963005.0
2023-02-22 11:00:00	QQQ	ETF	294.17	294.5186	293.59	293.91	1999343.0
2023-02-22 11:30:00	QQQ	ETF	293.92	294.59	293.68	294.37	1254231.0
2023-02-22 12:00:00	QQQ	ETF	294.4	294.93	293.91	294.6	1329842.0
2023-02-22 12:30:00	QQQ	ETF	294.6101	295.36	294.6101	294.99	1223378.0

> showing 50 of 27,692 rows — these rows as CSV

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