PREVIEW / etf_1hour / 2023-12-08

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-12-08.parquet
  size:    512 KB
  rows:    18,760

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
2023-12-08 04:00:00	SPY	ETF	458.02	458.55	458.02	458.42	34999.0
2023-12-08 05:00:00	SPY	ETF	458.49	458.74	458.36	458.65	13186.0
2023-12-08 06:00:00	SPY	ETF	458.62	458.62	457.75	457.75	20620.0
2023-12-08 07:00:00	SPY	ETF	457.85	457.95	457.38	457.76	86305.0
2023-12-08 08:00:00	SPY	ETF	457.53	458.6704	455.63	457.52	1586083.0
2023-12-08 09:00:00	SPY	ETF	457.53	458.74	457.0	458.2	5813834.0
2023-12-08 10:00:00	SPY	ETF	458.6	460.42	458.22	460.01	10713485.0
2023-12-08 11:00:00	SPY	ETF	460.02	460.11	457.84	458.24	8083579.0
2023-12-08 12:00:00	SPY	ETF	458.24	459.14	457.535	459.04	4582587.0
2023-12-08 13:00:00	SPY	ETF	459.04	459.59	458.89	459.4999	4301227.0
2023-12-08 14:00:00	SPY	ETF	459.5	460.47	459.44	460.3799	5509489.0
2023-12-08 15:00:00	SPY	ETF	460.38	460.745	459.9	460.13	14850154.0
2023-12-08 16:00:00	SPY	ETF	460.13	460.24	459.8	460.11	3925626.0
2023-12-08 17:00:00	SPY	ETF	460.1897	460.35	460.0	460.35	44574.0
2023-12-08 18:00:00	SPY	ETF	460.35	460.47	460.26	460.41	49655.0
2023-12-08 19:00:00	SPY	ETF	460.45	460.7	460.4	460.59	61500.0
2023-12-08 04:00:00	QQQ	ETF	389.92	390.46	389.91	390.43	31313.0
2023-12-08 05:00:00	QQQ	ETF	390.42	390.72	390.22	390.58	14172.0
2023-12-08 06:00:00	QQQ	ETF	390.56	390.56	389.59	389.66	32103.0
2023-12-08 07:00:00	QQQ	ETF	389.73	389.81	389.05	389.45	108592.0
2023-12-08 08:00:00	QQQ	ETF	389.42	390.722	387.08	388.93	1294157.0
2023-12-08 09:00:00	QQQ	ETF	388.91	390.4	388.28	389.6428	6672075.0
2023-12-08 10:00:00	QQQ	ETF	389.67	392.51	389.665	392.325	7817655.0
2023-12-08 11:00:00	QQQ	ETF	392.34	392.47	390.0	390.41	5101282.0
2023-12-08 12:00:00	QQQ	ETF	390.4	391.45	389.5214	391.4	3468308.0
2023-12-08 13:00:00	QQQ	ETF	391.4	391.875	391.215	391.84	2080405.0
2023-12-08 14:00:00	QQQ	ETF	391.85	392.62	391.72	392.505	2587726.0
2023-12-08 15:00:00	QQQ	ETF	392.51	392.6	391.89	392.15	5829054.0
2023-12-08 16:00:00	QQQ	ETF	392.16	392.25	391.387	392.03	1457780.0
2023-12-08 17:00:00	QQQ	ETF	392.02	392.1701	391.95	392.17	21050.0
2023-12-08 18:00:00	QQQ	ETF	392.15	392.24	392.12	392.24	17880.0
2023-12-08 19:00:00	QQQ	ETF	392.25	392.55	392.19	392.52	27029.0
2023-12-08 04:00:00	IWM	ETF	185.75	186.19	185.75	185.81	15485.0
2023-12-08 05:00:00	IWM	ETF	185.94	186.31	185.94	186.28	11999.0
2023-12-08 06:00:00	IWM	ETF	186.13	186.16	185.72	185.77	14369.0
2023-12-08 07:00:00	IWM	ETF	185.82	185.9	185.52	185.85	22824.0
2023-12-08 08:00:00	IWM	ETF	185.4804	187.12	184.51	185.97	1713691.0
2023-12-08 09:00:00	IWM	ETF	186.0	187.0	184.86	186.3	5262282.0
2023-12-08 10:00:00	IWM	ETF	186.32	187.75	186.31	186.81	5753758.0
2023-12-08 11:00:00	IWM	ETF	186.83	186.88	185.64	185.9447	4357494.0
2023-12-08 12:00:00	IWM	ETF	185.94	186.19	185.31	186.13	2283109.0
2023-12-08 13:00:00	IWM	ETF	186.14	186.77	186.065	186.655	1766972.0
2023-12-08 14:00:00	IWM	ETF	186.66	187.1	186.4899	186.92	1827020.0
2023-12-08 15:00:00	IWM	ETF	186.92	187.3	186.67	186.77	4939680.0
2023-12-08 16:00:00	IWM	ETF	186.8	186.8229	186.48	186.55	1083658.0
2023-12-08 17:00:00	IWM	ETF	186.55	186.8	186.55	186.8	22048.0
2023-12-08 18:00:00	IWM	ETF	186.79	186.93	186.71	186.81	7911.0
2023-12-08 19:00:00	IWM	ETF	186.89	187.19	186.81	187.0	44818.0
2023-12-08 04:00:00	DIA	ETF	361.97	362.22	361.97	362.11	1227.0
2023-12-08 05:00:00	DIA	ETF	362.1	362.1	362.1	362.1	300.0

> showing 50 of 18,760 rows — these rows as CSV

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