PREVIEW / etf_1hour / 2024-12-06

all etf 1-hour files

  file:    by_date/etf_1hour/2024/2024-12-06.parquet
  size:    604 KB
  rows:    22,381

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-12-06 04:00:00	SPY	ETF	606.39	606.75	606.36	606.5	16926.0
2024-12-06 05:00:00	SPY	ETF	606.39	606.5	606.07	606.07	6306.0
2024-12-06 06:00:00	SPY	ETF	606.19	606.26	605.85	606.26	10665.0
2024-12-06 07:00:00	SPY	ETF	606.23	606.66	606.23	606.38	40740.0
2024-12-06 08:00:00	SPY	ETF	606.4	608.06	605.74	607.5	448079.0
2024-12-06 09:00:00	SPY	ETF	607.51	609.04	607.33	608.98	2547757.0
2024-12-06 10:00:00	SPY	ETF	608.975	609.07	608.235	608.7	1920118.0
2024-12-06 11:00:00	SPY	ETF	608.71	608.7499	607.56	607.815	1978162.0
2024-12-06 12:00:00	SPY	ETF	607.82	607.86	607.06	607.36	1452251.0
2024-12-06 13:00:00	SPY	ETF	607.355	608.39	607.3	608.04	1396812.0
2024-12-06 14:00:00	SPY	ETF	608.03	608.06	607.02	607.34	2569727.0
2024-12-06 15:00:00	SPY	ETF	607.32	608.12	607.14	607.88	4609930.0
2024-12-06 16:00:00	SPY	ETF	607.89	608.065	606.5454	607.6	3122177.0
2024-12-06 17:00:00	SPY	ETF	607.65	607.86	607.4	607.45	69557.0
2024-12-06 18:00:00	SPY	ETF	607.45	607.45	607.2	607.22	31441.0
2024-12-06 19:00:00	SPY	ETF	607.22	607.38	607.2004	607.37	16462.0
2024-12-06 04:00:00	QQQ	ETF	522.15	522.4	521.81	521.93	38127.0
2024-12-06 05:00:00	QQQ	ETF	521.91	522.0	521.47	521.47	21630.0
2024-12-06 06:00:00	QQQ	ETF	521.59	521.75	521.28	521.75	24052.0
2024-12-06 07:00:00	QQQ	ETF	521.69	522.28	521.61	522.15	52848.0
2024-12-06 08:00:00	QQQ	ETF	521.65	523.4	521.286	522.5	550018.0
2024-12-06 09:00:00	QQQ	ETF	522.49	525.4	522.35	525.24	2094186.0
2024-12-06 10:00:00	QQQ	ETF	525.28	526.19	524.9	525.53	2324380.0
2024-12-06 11:00:00	QQQ	ETF	525.57	525.95	524.42	525.42	1727924.0
2024-12-06 12:00:00	QQQ	ETF	525.42	525.97	524.99	525.52	1125077.0
2024-12-06 13:00:00	QQQ	ETF	525.54	526.72	525.45	526.4999	1336743.0
2024-12-06 14:00:00	QQQ	ETF	526.46	526.47	525.38	525.91	1492663.0
2024-12-06 15:00:00	QQQ	ETF	525.9	526.625	525.71	526.51	3887458.0
2024-12-06 16:00:00	QQQ	ETF	526.49	526.5	525.79	525.92	1329195.0
2024-12-06 17:00:00	QQQ	ETF	525.91	525.96	525.77	525.78	36038.0
2024-12-06 18:00:00	QQQ	ETF	525.78	525.87	525.6	525.7	4742.0
2024-12-06 19:00:00	QQQ	ETF	525.8	525.95	525.6	525.95	19768.0
2024-12-06 04:00:00	IWM	ETF	237.78	238.3	237.61	238.26	23933.0
2024-12-06 05:00:00	IWM	ETF	238.29	238.5	238.19	238.26	5615.0
2024-12-06 06:00:00	IWM	ETF	238.29	238.37	238.06	238.07	9263.0
2024-12-06 07:00:00	IWM	ETF	238.1	238.51	238.1	238.45	82699.0
2024-12-06 08:00:00	IWM	ETF	238.2092	240.41	237.7	239.99	830094.0
2024-12-06 09:00:00	IWM	ETF	240.02	240.24	238.77	239.13	2226410.0
2024-12-06 10:00:00	IWM	ETF	239.14	239.82	238.56	239.64	2610119.0
2024-12-06 11:00:00	IWM	ETF	239.65	239.6744	238.71	239.23	1173700.0
2024-12-06 12:00:00	IWM	ETF	239.2	239.22	238.38	238.57	1069016.0
2024-12-06 13:00:00	IWM	ETF	238.58	239.3	238.5	238.72	1144252.0
2024-12-06 14:00:00	IWM	ETF	238.72	238.87	238.415	238.7138	1128181.0
2024-12-06 15:00:00	IWM	ETF	238.7	239.34	238.5735	238.96	2800390.0
2024-12-06 16:00:00	IWM	ETF	238.93	239.19	238.91	239.0	1196751.0
2024-12-06 17:00:00	IWM	ETF	238.99	239.24	238.8	238.81	14023.0
2024-12-06 18:00:00	IWM	ETF	238.81	238.99	238.71	238.71	2481.0
2024-12-06 19:00:00	IWM	ETF	238.9	239.0	238.68	238.73	3260.0
2024-12-06 04:00:00	DIA	ETF	448.65	448.74	448.51	448.74	3738.0
2024-12-06 05:00:00	DIA	ETF	448.54	448.54	448.54	448.54	460.0

> showing 50 of 22,381 rows — these rows as CSV

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