PREVIEW / etf_30min / 2024-01-08

all etf 30-min files

  file:    by_date/etf_30min/2024/2024-01-08.parquet
  size:    810 KB
  rows:    31,431

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-01-08 04:00:00	SPY	ETF	467.7	467.7	466.73	466.73	13652.0
2024-01-08 04:30:00	SPY	ETF	466.66	467.12	466.13	467.04	11962.0
2024-01-08 05:00:00	SPY	ETF	467.18	467.19	466.91	467.17	2711.0
2024-01-08 05:30:00	SPY	ETF	467.38	467.44	467.0	467.0	4357.0
2024-01-08 06:00:00	SPY	ETF	466.81	467.4	466.61	467.28	25738.0
2024-01-08 06:30:00	SPY	ETF	467.38	467.79	467.31	467.59	29297.0
2024-01-08 07:00:00	SPY	ETF	467.67	467.99	467.6	467.81	36631.0
2024-01-08 07:30:00	SPY	ETF	467.73	468.07	467.47	468.07	50827.0
2024-01-08 08:00:00	SPY	ETF	467.79	468.43	466.86	468.15	109362.0
2024-01-08 08:30:00	SPY	ETF	468.19	468.37	467.85	468.02	107465.0
2024-01-08 09:00:00	SPY	ETF	468.05	468.45	467.82	468.45	151484.0
2024-01-08 09:30:00	SPY	ETF	468.43	469.78	468.3	469.73	5770171.0
2024-01-08 10:00:00	SPY	ETF	469.73	470.02	469.35	469.95	4556093.0
2024-01-08 10:30:00	SPY	ETF	469.96	470.745	469.96	470.36	3578461.0
2024-01-08 11:00:00	SPY	ETF	470.38	470.62	469.97	470.41	2559870.0
2024-01-08 11:30:00	SPY	ETF	470.41	470.9	470.37	470.8799	2748273.0
2024-01-08 12:00:00	SPY	ETF	470.88	471.25	470.56	470.73	2833180.0
2024-01-08 12:30:00	SPY	ETF	470.755	471.635	470.68	471.47	2144209.0
2024-01-08 13:00:00	SPY	ETF	471.47	471.72	471.245	471.3797	1924620.0
2024-01-08 13:30:00	SPY	ETF	471.375	472.09	471.36	472.02	1982882.0
2024-01-08 14:00:00	SPY	ETF	472.03	473.015	471.91	472.97	3557476.0
2024-01-08 14:30:00	SPY	ETF	472.98	474.0	472.98	473.7599	4637132.0
2024-01-08 15:00:00	SPY	ETF	473.76	473.94	473.38	473.66	4307051.0
2024-01-08 15:30:00	SPY	ETF	473.66	474.75	473.58	474.56	14543004.0
2024-01-08 16:00:00	SPY	ETF	474.55	474.6062	470.34	474.47	3854138.0
2024-01-08 16:30:00	SPY	ETF	474.48	474.48	474.18	474.18	205962.0
2024-01-08 17:00:00	SPY	ETF	474.24	474.39	474.18	474.3	22156.0
2024-01-08 17:30:00	SPY	ETF	474.2701	474.34	474.2	474.25	6435.0
2024-01-08 18:00:00	SPY	ETF	474.21	474.21	474.07	474.15	17471.0
2024-01-08 18:30:00	SPY	ETF	474.1	474.2	474.0893	474.2	13155.0
2024-01-08 19:00:00	SPY	ETF	474.17	474.29	474.16	474.17	17905.0
2024-01-08 19:30:00	SPY	ETF	474.17	474.25	474.14	474.21	14548.0
2024-01-08 04:00:00	QQQ	ETF	396.0	396.14	395.5	395.54	13536.0
2024-01-08 04:30:00	QQQ	ETF	395.36	395.92	394.82	395.81	33868.0
2024-01-08 05:00:00	QQQ	ETF	395.79	396.16	395.79	396.16	16921.0
2024-01-08 05:30:00	QQQ	ETF	396.19	396.33	395.87	395.87	12244.0
2024-01-08 06:00:00	QQQ	ETF	395.93	396.41	395.55	396.25	39423.0
2024-01-08 06:30:00	QQQ	ETF	396.32	396.89	396.28	396.78	57204.0
2024-01-08 07:00:00	QQQ	ETF	396.73	397.16	396.66	397.07	52419.0
2024-01-08 07:30:00	QQQ	ETF	397.06	397.38	396.61	397.34	71250.0
2024-01-08 08:00:00	QQQ	ETF	396.76	397.68	394.9604	397.5	136330.0
2024-01-08 08:30:00	QQQ	ETF	397.51	397.61	397.01	397.19	109604.0
2024-01-08 09:00:00	QQQ	ETF	397.29	398.03	397.1	397.98	200460.0
2024-01-08 09:30:00	QQQ	ETF	397.99	400.92	397.8399	400.81	5086056.0
2024-01-08 10:00:00	QQQ	ETF	400.815	401.1855	400.43	401.1	2663085.0
2024-01-08 10:30:00	QQQ	ETF	401.11	401.8194	401.1	401.49	1764635.0
2024-01-08 11:00:00	QQQ	ETF	401.5	401.85	401.08	401.28	1466614.0
2024-01-08 11:30:00	QQQ	ETF	401.28	402.02	401.26	401.97	1570766.0
2024-01-08 12:00:00	QQQ	ETF	401.97	402.42	401.89	402.145	1539293.0
2024-01-08 12:30:00	QQQ	ETF	402.15	402.96	402.09	402.915	1265638.0

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

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