PREVIEW / etf_1hour / 2024-01-03

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-01-03.parquet
  size:    535 KB
  rows:    19,888

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-03 04:00:00	SPY	ETF	472.07	472.18	471.56	471.57	27202.0
2024-01-03 05:00:00	SPY	ETF	471.44	471.9	471.44	471.64	19327.0
2024-01-03 06:00:00	SPY	ETF	471.72	471.75	471.1	471.29	51333.0
2024-01-03 07:00:00	SPY	ETF	471.3	471.3	470.62	470.69	137365.0
2024-01-03 08:00:00	SPY	ETF	470.99	472.53	470.54	470.63	386621.0
2024-01-03 09:00:00	SPY	ETF	470.68	470.8	469.65	469.97	7586164.0
2024-01-03 10:00:00	SPY	ETF	469.95	470.96	468.71	469.39	12294639.0
2024-01-03 11:00:00	SPY	ETF	469.39	469.93	469.1299	469.2601	7342671.0
2024-01-03 12:00:00	SPY	ETF	469.26	470.39	468.97	470.3	5312650.0
2024-01-03 13:00:00	SPY	ETF	470.29	470.77	469.86	470.0825	5026394.0
2024-01-03 14:00:00	SPY	ETF	470.08	471.19	468.95	470.2283	11036039.0
2024-01-03 15:00:00	SPY	ETF	470.23	470.29	468.17	468.73	19391761.0
2024-01-03 16:00:00	SPY	ETF	468.73	468.97	468.51	468.94	4023032.0
2024-01-03 17:00:00	SPY	ETF	468.93	469.19	468.79	469.13	83959.0
2024-01-03 18:00:00	SPY	ETF	469.14	469.34	469.0	469.06	71418.0
2024-01-03 19:00:00	SPY	ETF	469.07	469.36	468.811	469.35	96867.0
2024-01-03 04:00:00	QQQ	ETF	401.48	402.06	400.71	400.72	58737.0
2024-01-03 05:00:00	QQQ	ETF	400.6	401.45	400.6	401.1	46398.0
2024-01-03 06:00:00	QQQ	ETF	401.16	401.27	400.61	400.88	30067.0
2024-01-03 07:00:00	QQQ	ETF	400.85	400.85	399.8	399.9	356916.0
2024-01-03 08:00:00	QQQ	ETF	400.81	402.65	399.66	400.09	449695.0
2024-01-03 09:00:00	QQQ	ETF	400.14	400.76	399.26	400.07	6551841.0
2024-01-03 10:00:00	QQQ	ETF	400.03	401.0	398.4	399.6201	8145841.0
2024-01-03 11:00:00	QQQ	ETF	399.63	400.18	398.74	398.84	4224390.0
2024-01-03 12:00:00	QQQ	ETF	398.85	399.87	398.53	399.76	2952862.0
2024-01-03 13:00:00	QQQ	ETF	399.75	400.22	399.0525	399.38	2481693.0
2024-01-03 14:00:00	QQQ	ETF	399.37	400.44	398.08	399.53	5797696.0
2024-01-03 15:00:00	QQQ	ETF	399.53	399.68	397.89	398.335	6172919.0
2024-01-03 16:00:00	QQQ	ETF	398.335	398.37	398.01	398.37	1032461.0
2024-01-03 17:00:00	QQQ	ETF	398.37	398.51	398.33	398.5	47553.0
2024-01-03 18:00:00	QQQ	ETF	398.5	398.85	398.47	398.52	49837.0
2024-01-03 19:00:00	QQQ	ETF	398.42	398.89	398.2	398.79	85687.0
2024-01-03 04:00:00	IWM	ETF	198.74	198.86	198.26	198.3	34725.0
2024-01-03 05:00:00	IWM	ETF	198.23	198.42	198.17	198.19	13735.0
2024-01-03 06:00:00	IWM	ETF	198.17	198.3	197.73	197.8	87811.0
2024-01-03 07:00:00	IWM	ETF	197.81	197.81	197.42	197.44	136895.0
2024-01-03 08:00:00	IWM	ETF	197.7992	199.56	197.0	197.0	477890.0
2024-01-03 09:00:00	IWM	ETF	197.0	197.48	196.13	196.25	7146289.0
2024-01-03 10:00:00	IWM	ETF	196.23	197.67	195.35	196.42	8595012.0
2024-01-03 11:00:00	IWM	ETF	196.41	196.88	196.27	196.35	4851022.0
2024-01-03 12:00:00	IWM	ETF	196.35	196.43	195.82	196.32	3289347.0
2024-01-03 13:00:00	IWM	ETF	196.31	196.74	196.04	196.09	2469481.0
2024-01-03 14:00:00	IWM	ETF	196.11	196.85	195.32	195.65	5884523.0
2024-01-03 15:00:00	IWM	ETF	195.64	195.69	193.78	194.15	11421733.0
2024-01-03 16:00:00	IWM	ETF	194.2	194.44	194.1	194.4	1189061.0
2024-01-03 17:00:00	IWM	ETF	194.38	194.5	194.26	194.43	25426.0
2024-01-03 18:00:00	IWM	ETF	194.49	194.66	194.45	194.55	44721.0
2024-01-03 19:00:00	IWM	ETF	194.61	194.86	194.33	194.8	45424.0
2024-01-03 04:00:00	DIA	ETF	376.76	376.76	376.49	376.49	2200.0
2024-01-03 05:00:00	DIA	ETF	376.42	376.52	376.26	376.44	2356.0

> showing 50 of 19,888 rows — these rows as CSV

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