PREVIEW / etf_30min / 2024-04-29

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-04-29.parquet
  size:    785 KB
  rows:    31,890

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-04-29 04:00:00	SPY	ETF	509.67	509.9	509.6	509.77	14895.0
2024-04-29 04:30:00	SPY	ETF	509.73	509.73	509.49	509.49	1375.0
2024-04-29 05:00:00	SPY	ETF	509.48	509.53	509.09	509.21	12830.0
2024-04-29 05:30:00	SPY	ETF	509.2	509.37	508.89	508.89	3739.0
2024-04-29 06:00:00	SPY	ETF	508.82	509.36	508.82	509.3	3052.0
2024-04-29 06:30:00	SPY	ETF	509.32	509.61	509.26	509.47	20866.0
2024-04-29 07:00:00	SPY	ETF	509.5	509.81	509.01	509.77	122454.0
2024-04-29 07:30:00	SPY	ETF	509.78	509.89	509.63	509.82	44195.0
2024-04-29 08:00:00	SPY	ETF	509.75	509.93	509.1996	509.68	90412.0
2024-04-29 08:30:00	SPY	ETF	509.68	509.99	509.48	509.89	56637.0
2024-04-29 09:00:00	SPY	ETF	509.87	510.1	508.26	510.08	104576.0
2024-04-29 09:30:00	SPY	ETF	510.08	510.75	509.02	509.58	4844352.0
2024-04-29 10:00:00	SPY	ETF	509.57	510.51	509.535	510.22	2058602.0
2024-04-29 10:30:00	SPY	ETF	510.22	510.63	509.55	509.88	1988252.0
2024-04-29 11:00:00	SPY	ETF	509.88	509.935	509.435	509.57	1221116.0
2024-04-29 11:30:00	SPY	ETF	509.58	509.74	509.005	509.7	1626913.0
2024-04-29 12:00:00	SPY	ETF	509.71	510.14	509.5602	510.14	1317935.0
2024-04-29 12:30:00	SPY	ETF	510.15	510.33	509.7	509.945	1441305.0
2024-04-29 13:00:00	SPY	ETF	509.9499	510.41	509.575	510.3701	1325459.0
2024-04-29 13:30:00	SPY	ETF	510.38	510.52	510.1	510.175	1154317.0
2024-04-29 14:00:00	SPY	ETF	510.1599	510.16	509.61	509.68	1561365.0
2024-04-29 14:30:00	SPY	ETF	509.68	509.7	508.6	509.5515	2459724.0
2024-04-29 15:00:00	SPY	ETF	509.55	509.55	507.25	508.6	4920875.0
2024-04-29 15:30:00	SPY	ETF	508.61	510.2	508.48	510.05	6165492.0
2024-04-29 16:00:00	SPY	ETF	510.05	510.49	510.03	510.07	2652144.0
2024-04-29 16:30:00	SPY	ETF	510.021	510.2	509.94	510.05	222517.0
2024-04-29 17:00:00	SPY	ETF	510.07	510.25	509.95	510.18	21511.0
2024-04-29 17:30:00	SPY	ETF	510.19	510.26	510.08	510.19	27007.0
2024-04-29 18:00:00	SPY	ETF	510.06	510.06	509.8	509.85	15869.0
2024-04-29 18:30:00	SPY	ETF	509.85	509.85	509.65	509.73	16387.0
2024-04-29 19:00:00	SPY	ETF	509.79	509.86	509.73	509.8	9331.0
2024-04-29 19:30:00	SPY	ETF	509.78	509.88	509.78	509.83	9905.0
2024-04-29 04:00:00	QQQ	ETF	432.75	432.94	432.54	432.64	32282.0
2024-04-29 04:30:00	QQQ	ETF	432.72	432.72	432.35	432.49	17928.0
2024-04-29 05:00:00	QQQ	ETF	432.49	432.68	432.16	432.34	14397.0
2024-04-29 05:30:00	QQQ	ETF	432.21	432.38	431.82	431.91	26003.0
2024-04-29 06:00:00	QQQ	ETF	431.93	432.45	431.93	432.45	16368.0
2024-04-29 06:30:00	QQQ	ETF	432.44	432.79	432.3	432.54	23080.0
2024-04-29 07:00:00	QQQ	ETF	432.55	432.76	432.21	432.72	63243.0
2024-04-29 07:30:00	QQQ	ETF	432.751	433.07	432.61	432.939	46933.0
2024-04-29 08:00:00	QQQ	ETF	432.5196	433.25	432.1804	432.93	134376.0
2024-04-29 08:30:00	QQQ	ETF	432.9	433.26	432.73	433.13	91772.0
2024-04-29 09:00:00	QQQ	ETF	433.14	433.22	432.7	433.12	246309.0
2024-04-29 09:30:00	QQQ	ETF	433.12	433.76	430.9	431.8	4225846.0
2024-04-29 10:00:00	QQQ	ETF	431.8	432.76	431.71	432.4671	1979498.0
2024-04-29 10:30:00	QQQ	ETF	432.45	432.99	431.861	432.235	1545479.0
2024-04-29 11:00:00	QQQ	ETF	432.27	432.38	431.63	432.05	1050017.0
2024-04-29 11:30:00	QQQ	ETF	432.06	432.37	431.2604	432.29	964531.0
2024-04-29 12:00:00	QQQ	ETF	432.315	432.7799	432.17	432.7799	863137.0
2024-04-29 12:30:00	QQQ	ETF	432.77	432.93	432.21	432.525	1055046.0

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

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