PREVIEW / etf_30min / 2024-05-21

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-05-21.parquet
  size:    788 KB
  rows:    31,295

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-21 04:00:00	SPY	ETF	530.12	530.3	530.0	530.0	7533.0
2024-05-21 04:30:00	SPY	ETF	529.98	530.0	529.89	529.96	3026.0
2024-05-21 05:00:00	SPY	ETF	529.92	530.06	529.91	529.93	2627.0
2024-05-21 05:30:00	SPY	ETF	529.89	529.89	529.82	529.82	1290.0
2024-05-21 06:00:00	SPY	ETF	529.94	530.0	529.89	530.0	4300.0
2024-05-21 06:30:00	SPY	ETF	530.0	530.18	530.0	530.14	2186.0
2024-05-21 07:00:00	SPY	ETF	530.16	530.27	530.09	530.16	20986.0
2024-05-21 07:30:00	SPY	ETF	530.19	530.24	530.1	530.15	6342.0
2024-05-21 08:00:00	SPY	ETF	530.22	530.3	529.86	529.86	50842.0
2024-05-21 08:30:00	SPY	ETF	529.8	529.89	529.51	529.61	87240.0
2024-05-21 09:00:00	SPY	ETF	529.63	529.7809	529.13	529.27	251568.0
2024-05-21 09:30:00	SPY	ETF	529.28	529.71	529.07	529.52	2189291.0
2024-05-21 10:00:00	SPY	ETF	529.53	530.03	529.52	530.015	1152808.0
2024-05-21 10:30:00	SPY	ETF	530.02	530.59	529.93	530.36	1284488.0
2024-05-21 11:00:00	SPY	ETF	530.35	530.73	530.1901	530.5001	1113735.0
2024-05-21 11:30:00	SPY	ETF	530.51	530.5197	529.82	529.97	1131231.0
2024-05-21 12:00:00	SPY	ETF	529.97	530.3	529.82	530.195	1662388.0
2024-05-21 12:30:00	SPY	ETF	530.19	530.28	529.8	529.95	1072457.0
2024-05-21 13:00:00	SPY	ETF	529.945	530.145	529.64	530.135	761298.0
2024-05-21 13:30:00	SPY	ETF	530.14	530.78	530.07	530.76	1123950.0
2024-05-21 14:00:00	SPY	ETF	530.77	530.79	530.35	530.39	963949.0
2024-05-21 14:30:00	SPY	ETF	530.395	530.68	530.1658	530.4099	937196.0
2024-05-21 15:00:00	SPY	ETF	530.4	530.96	530.24	530.825	1262367.0
2024-05-21 15:30:00	SPY	ETF	530.81	531.52	530.78	531.32	5462700.0
2024-05-21 16:00:00	SPY	ETF	531.33	531.43	531.03	531.26	2090596.0
2024-05-21 16:30:00	SPY	ETF	531.23	531.28	531.15	531.15	88191.0
2024-05-21 17:00:00	SPY	ETF	531.23	531.25	531.14	531.2	15788.0
2024-05-21 17:30:00	SPY	ETF	531.16	531.2	531.16	531.2	5257.0
2024-05-21 18:00:00	SPY	ETF	531.16	531.3	531.15	531.29	22810.0
2024-05-21 18:30:00	SPY	ETF	531.26	531.4	531.26	531.37	10791.0
2024-05-21 19:00:00	SPY	ETF	531.41	531.45	531.34	531.43	6316.0
2024-05-21 19:30:00	SPY	ETF	531.45	531.46	531.39	531.4	7716.0
2024-05-21 04:00:00	QQQ	ETF	454.61	454.73	454.39	454.4	11766.0
2024-05-21 04:30:00	QQQ	ETF	454.46	454.47	454.28	454.4	4098.0
2024-05-21 05:00:00	QQQ	ETF	454.4	454.4	454.23	454.23	6341.0
2024-05-21 05:30:00	QQQ	ETF	454.2	454.3	454.16	454.3	1459.0
2024-05-21 06:00:00	QQQ	ETF	454.44	454.48	454.35	454.42	5716.0
2024-05-21 06:30:00	QQQ	ETF	454.59	454.67	454.56	454.62	3387.0
2024-05-21 07:00:00	QQQ	ETF	454.67	454.83	454.57	454.68	118774.0
2024-05-21 07:30:00	QQQ	ETF	454.73	454.74	454.55	454.6	145178.0
2024-05-21 08:00:00	QQQ	ETF	454.8283	454.8283	454.14	454.15	111643.0
2024-05-21 08:30:00	QQQ	ETF	454.13	454.19	453.78	453.81	133911.0
2024-05-21 09:00:00	QQQ	ETF	453.77	453.86	452.92	452.98	547231.0
2024-05-21 09:30:00	QQQ	ETF	453.02	453.87	452.84	453.558	2339327.0
2024-05-21 10:00:00	QQQ	ETF	453.55	454.15	453.44	454.125	1020763.0
2024-05-21 10:30:00	QQQ	ETF	454.14	454.785	454.04	454.71	1367850.0
2024-05-21 11:00:00	QQQ	ETF	454.71	454.92	454.4713	454.6806	751518.0
2024-05-21 11:30:00	QQQ	ETF	454.7	454.7	454.14	454.47	673275.0
2024-05-21 12:00:00	QQQ	ETF	454.46	455.11	454.34	454.9499	721138.0
2024-05-21 12:30:00	QQQ	ETF	454.93	454.98	454.31	454.51	520558.0

> showing 50 of 31,295 rows — these rows as CSV

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