PREVIEW / etf_30min / 2024-04-01

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-04-01.parquet
  size:    830 KB
  rows:    33,434

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-01 04:00:00	SPY	ETF	525.57	525.59	525.12	525.4	17016.0
2024-04-01 04:30:00	SPY	ETF	525.45	525.54	525.38	525.5	1877.0
2024-04-01 05:00:00	SPY	ETF	525.54	525.54	525.3	525.32	1700.0
2024-04-01 05:30:00	SPY	ETF	525.26	525.31	525.25	525.31	2462.0
2024-04-01 06:00:00	SPY	ETF	525.41	525.52	525.35	525.51	56190.0
2024-04-01 06:30:00	SPY	ETF	525.53	525.55	525.43	525.46	9427.0
2024-04-01 07:00:00	SPY	ETF	525.48	525.48	524.34	524.91	130016.0
2024-04-01 07:30:00	SPY	ETF	524.85	524.97	524.73	524.92	32672.0
2024-04-01 08:00:00	SPY	ETF	525.19	526.09	523.9	524.08	197838.0
2024-04-01 08:30:00	SPY	ETF	524.01	524.27	523.72	524.14	51409.0
2024-04-01 09:00:00	SPY	ETF	524.15	524.15	523.46	523.81	178324.0
2024-04-01 09:30:00	SPY	ETF	523.83	524.38	523.45	524.095	3685243.0
2024-04-01 10:00:00	SPY	ETF	524.09	524.18	522.83	522.99	3841295.0
2024-04-01 10:30:00	SPY	ETF	522.985	523.1	522.08	522.315	2647748.0
2024-04-01 11:00:00	SPY	ETF	522.31	522.42	521.36	522.0799	2948707.0
2024-04-01 11:30:00	SPY	ETF	522.07	522.085	521.07	521.1088	2064418.0
2024-04-01 12:00:00	SPY	ETF	521.1	522.05	520.97	521.99	2824131.0
2024-04-01 12:30:00	SPY	ETF	522.0	522.225	521.89	521.905	1174898.0
2024-04-01 13:00:00	SPY	ETF	521.91	521.91	521.06	521.61	1572470.0
2024-04-01 13:30:00	SPY	ETF	521.62	521.87	521.38	521.74	1220387.0
2024-04-01 14:00:00	SPY	ETF	521.73	522.05	521.47	521.8712	1358499.0
2024-04-01 14:30:00	SPY	ETF	521.87	522.15	521.72	521.86	1252977.0
2024-04-01 15:00:00	SPY	ETF	521.86	522.34	521.68	521.87	1992652.0
2024-04-01 15:30:00	SPY	ETF	521.875	522.8	521.61	522.22	6521551.0
2024-04-01 16:00:00	SPY	ETF	522.22	522.4069	521.94	521.95	3992265.0
2024-04-01 16:30:00	SPY	ETF	521.96	522.4362	521.8997	522.1	316476.0
2024-04-01 17:00:00	SPY	ETF	522.16	522.28	522.15	522.25	26940.0
2024-04-01 17:30:00	SPY	ETF	522.25	522.4362	522.15	522.19	396006.0
2024-04-01 18:00:00	SPY	ETF	522.19	522.19	521.78	521.78	30957.0
2024-04-01 18:30:00	SPY	ETF	521.74	521.94	521.66	521.66	22481.0
2024-04-01 19:00:00	SPY	ETF	521.68	521.82	521.66	521.79	19672.0
2024-04-01 19:30:00	SPY	ETF	521.77	521.8	521.4201	521.67	8664.0
2024-04-01 04:00:00	QQQ	ETF	447.31	447.31	446.0	446.69	40292.0
2024-04-01 04:30:00	QQQ	ETF	446.66	446.85	446.66	446.79	49655.0
2024-04-01 05:00:00	QQQ	ETF	446.76	446.8	446.45	446.5	22460.0
2024-04-01 05:30:00	QQQ	ETF	446.53	446.7	446.43	446.66	13294.0
2024-04-01 06:00:00	QQQ	ETF	446.67	446.86	446.6	446.77	11678.0
2024-04-01 06:30:00	QQQ	ETF	446.88	446.93	446.72	446.77	10329.0
2024-04-01 07:00:00	QQQ	ETF	446.88	446.88	445.71	445.84	63010.0
2024-04-01 07:30:00	QQQ	ETF	445.8	446.04	445.64	445.95	29006.0
2024-04-01 08:00:00	QQQ	ETF	446.75	447.3	444.9	445.18	144394.0
2024-04-01 08:30:00	QQQ	ETF	445.136	445.47	444.83	445.34	96872.0
2024-04-01 09:00:00	QQQ	ETF	445.25	445.25	444.45	444.92	100003.0
2024-04-01 09:30:00	QQQ	ETF	444.97	447.53	444.55	447.04	4727920.0
2024-04-01 10:00:00	QQQ	ETF	447.03	447.4694	445.35	445.8199	3553722.0
2024-04-01 10:30:00	QQQ	ETF	445.83	446.0	444.235	444.63	3188317.0
2024-04-01 11:00:00	QQQ	ETF	444.62	444.77	443.27	444.35	3028419.0
2024-04-01 11:30:00	QQQ	ETF	444.36	444.49	443.18	443.259	2094496.0
2024-04-01 12:00:00	QQQ	ETF	443.27	444.55	443.02	444.4501	1737258.0
2024-04-01 12:30:00	QQQ	ETF	444.48	444.84	444.2602	444.315	1218132.0

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

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