PREVIEW / etf_30min / 2024-03-21

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-03-21.parquet
  size:    807 KB
  rows:    32,469

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-03-21 04:00:00	SPY	ETF	523.48	523.8	522.77	522.9	50553.0
2024-03-21 04:30:00	SPY	ETF	522.93	523.02	522.75	522.79	16212.0
2024-03-21 05:00:00	SPY	ETF	522.77	522.77	522.21	522.27	18685.0
2024-03-21 05:30:00	SPY	ETF	522.28	522.66	522.26	522.59	4927.0
2024-03-21 06:00:00	SPY	ETF	522.44	522.46	522.15	522.38	17433.0
2024-03-21 06:30:00	SPY	ETF	522.45	522.45	522.14	522.27	6745.0
2024-03-21 07:00:00	SPY	ETF	522.31	522.67	522.27	522.5	92668.0
2024-03-21 07:30:00	SPY	ETF	522.5	522.95	522.46	522.76	84481.0
2024-03-21 08:00:00	SPY	ETF	522.78	523.34	522.1204	523.31	222717.0
2024-03-21 08:30:00	SPY	ETF	523.25	523.26	522.97	523.17	198512.0
2024-03-21 09:00:00	SPY	ETF	523.16	523.68	522.94	523.36	245501.0
2024-03-21 09:30:00	SPY	ETF	523.38	524.01	522.765	523.43	5782977.0
2024-03-21 10:00:00	SPY	ETF	523.43	523.98	523.1551	523.75	3104475.0
2024-03-21 10:30:00	SPY	ETF	523.77	523.98	523.165	523.6	3574747.0
2024-03-21 11:00:00	SPY	ETF	523.59	523.84	523.03	523.4	2568437.0
2024-03-21 11:30:00	SPY	ETF	523.4	523.93	523.27	523.75	2007187.0
2024-03-21 12:00:00	SPY	ETF	523.74	524.05	523.605	524.01	1948638.0
2024-03-21 12:30:00	SPY	ETF	524.0	524.11	523.43	523.76	2215123.0
2024-03-21 13:00:00	SPY	ETF	523.745	523.76	523.19	523.39	1729790.0
2024-03-21 13:30:00	SPY	ETF	523.37	523.55	522.73	522.81	2196459.0
2024-03-21 14:00:00	SPY	ETF	522.8	523.12	522.51	523.04	2679007.0
2024-03-21 14:30:00	SPY	ETF	523.04	523.04	522.03	522.32	2514433.0
2024-03-21 15:00:00	SPY	ETF	522.33	522.86	522.09	522.78	2882186.0
2024-03-21 15:30:00	SPY	ETF	522.795	523.17	521.91	522.11	7430991.0
2024-03-21 16:00:00	SPY	ETF	522.11	522.77	522.04	522.65	2229856.0
2024-03-21 16:30:00	SPY	ETF	522.64	522.66	522.51	522.6	148339.0
2024-03-21 17:00:00	SPY	ETF	522.6	522.75	522.2	522.58	81610.0
2024-03-21 17:30:00	SPY	ETF	522.58	522.65	522.49	522.49	20294.0
2024-03-21 18:00:00	SPY	ETF	522.56	522.68	522.34	522.4	24199.0
2024-03-21 18:30:00	SPY	ETF	522.45	522.81	522.45	522.77	12397.0
2024-03-21 19:00:00	SPY	ETF	522.7401	522.8	522.6502	522.78	8159.0
2024-03-21 19:30:00	SPY	ETF	522.8	522.91	522.8	522.85	19637.0
2024-03-21 04:00:00	QQQ	ETF	448.17	448.17	447.12	447.38	58312.0
2024-03-21 04:30:00	QQQ	ETF	447.27	447.56	447.01	447.23	52548.0
2024-03-21 05:00:00	QQQ	ETF	447.24	447.38	446.55	446.81	32351.0
2024-03-21 05:30:00	QQQ	ETF	446.61	447.07	446.61	446.96	13448.0
2024-03-21 06:00:00	QQQ	ETF	447.0	447.05	446.7	446.94	20225.0
2024-03-21 06:30:00	QQQ	ETF	447.01	447.01	446.75	446.92	76140.0
2024-03-21 07:00:00	QQQ	ETF	446.95	447.6	446.91	447.52	207440.0
2024-03-21 07:30:00	QQQ	ETF	447.47	447.93	447.44	447.72	35537.0
2024-03-21 08:00:00	QQQ	ETF	446.58	448.54	443.438	448.38	225538.0
2024-03-21 08:30:00	QQQ	ETF	448.34	448.5	447.94	448.2	226230.0
2024-03-21 09:00:00	QQQ	ETF	448.2	449.03	447.92	448.89	329102.0
2024-03-21 09:30:00	QQQ	ETF	448.88	449.32	447.38	447.9176	4751463.0
2024-03-21 10:00:00	QQQ	ETF	447.9	448.865	447.51	448.21	2124397.0
2024-03-21 10:30:00	QQQ	ETF	448.21	448.45	447.29	447.85	2400255.0
2024-03-21 11:00:00	QQQ	ETF	447.84	448.34	447.22	448.15	1525844.0
2024-03-21 11:30:00	QQQ	ETF	448.16	449.21	448.01	448.75	1751805.0
2024-03-21 12:00:00	QQQ	ETF	448.75	449.34	448.5812	449.25	1220698.0
2024-03-21 12:30:00	QQQ	ETF	449.25	449.34	448.65	448.92	1225930.0

> showing 50 of 32,469 rows — these rows as CSV

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