PREVIEW / etf_1hour / 2005-09-22

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-09-22.parquet
  size:    34 KB
  rows:    1,022

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
2005-09-22 04:00:00	SPY	ETF	120.97	120.97	120.97	120.97	21400.0
2005-09-22 07:00:00	SPY	ETF	120.84	120.84	120.63	120.69	140100.0
2005-09-22 08:00:00	SPY	ETF	120.7	120.9	120.6	120.85	2474100.0
2005-09-22 09:00:00	SPY	ETF	120.86	121.06	120.5	121.03	8647900.0
2005-09-22 10:00:00	SPY	ETF	121.02	121.37	120.87	120.9	16561300.0
2005-09-22 11:00:00	SPY	ETF	120.91	121.12	120.73	120.89	6306000.0
2005-09-22 12:00:00	SPY	ETF	120.9	120.92	120.44	120.87	9969000.0
2005-09-22 13:00:00	SPY	ETF	120.88	121.57	120.76	121.29	15710100.0
2005-09-22 14:00:00	SPY	ETF	121.3	121.55	121.05	121.24	7777300.0
2005-09-22 15:00:00	SPY	ETF	121.24	121.66	121.08	121.45	9925100.0
2005-09-22 16:00:00	SPY	ETF	121.45	121.45	120.85	121.31	656500.0
2005-09-22 17:00:00	SPY	ETF	121.35	121.57	120.45	121.27	1218900.0
2005-09-22 18:00:00	SPY	ETF	121.28	121.28	121.26	121.27	3500.0
2005-09-22 19:00:00	SPY	ETF	121.27	121.27	121.24	121.26	4200.0
2005-09-22 09:00:00	QQQ	ETF	38.44	38.49	38.24	38.48	15268000.0
2005-09-22 10:00:00	QQQ	ETF	38.49	38.69	38.38	38.39	20256500.0
2005-09-22 11:00:00	QQQ	ETF	38.39	38.53	38.31	38.37	10138000.0
2005-09-22 12:00:00	QQQ	ETF	38.37	38.48	38.24	38.48	12021600.0
2005-09-22 13:00:00	QQQ	ETF	38.48	38.73	38.44	38.63	21268100.0
2005-09-22 14:00:00	QQQ	ETF	38.62	38.68	38.53	38.59	6663500.0
2005-09-22 15:00:00	QQQ	ETF	38.59	38.71	38.5	38.64	13371800.0
2005-09-22 08:00:00	IWM	ETF	64.44	64.58	64.44	64.58	700.0
2005-09-22 09:00:00	IWM	ETF	64.58	64.74	64.1	64.45	2435200.0
2005-09-22 10:00:00	IWM	ETF	64.46	64.84	64.43	64.54	8622300.0
2005-09-22 11:00:00	IWM	ETF	64.54	64.7	64.44	64.51	3325000.0
2005-09-22 12:00:00	IWM	ETF	64.51	64.54	64.23	64.52	3220300.0
2005-09-22 13:00:00	IWM	ETF	64.53	65.0	64.43	64.84	6909000.0
2005-09-22 14:00:00	IWM	ETF	64.85	64.96	64.64	64.91	2268900.0
2005-09-22 15:00:00	IWM	ETF	64.91	65.12	64.77	64.87	4084100.0
2005-09-22 16:00:00	IWM	ETF	64.87	64.93	64.58	64.9	130000.0
2005-09-22 17:00:00	IWM	ETF	64.9	65.09	64.23	64.24	249700.0
2005-09-22 07:00:00	DIA	ETF	103.53	103.6	103.53	103.6	17100.0
2005-09-22 08:00:00	DIA	ETF	103.69	103.73	103.47	103.69	135700.0
2005-09-22 09:00:00	DIA	ETF	103.67	103.87	103.47	103.82	953800.0
2005-09-22 10:00:00	DIA	ETF	103.84	104.1	103.67	103.71	1292400.0
2005-09-22 11:00:00	DIA	ETF	103.7	103.87	103.56	103.72	626400.0
2005-09-22 12:00:00	DIA	ETF	103.72	103.81	103.44	103.79	610700.0
2005-09-22 13:00:00	DIA	ETF	103.78	104.3	103.67	104.16	1396100.0
2005-09-22 14:00:00	DIA	ETF	104.14	104.27	103.95	104.05	649900.0
2005-09-22 15:00:00	DIA	ETF	104.07	104.4	103.9	104.14	1215600.0
2005-09-22 16:00:00	DIA	ETF	104.11	104.12	103.97	103.98	165900.0
2005-09-22 17:00:00	DIA	ETF	104.0	104.32	103.43	103.5	95500.0
2005-09-22 18:00:00	DIA	ETF	104.0	104.0	104.0	104.0	100.0
2005-09-22 19:00:00	DIA	ETF	104.02	104.02	104.0	104.0	1000.0
2005-09-22 08:00:00	GLD	ETF	47.29	47.3	46.81	46.96	23000.0
2005-09-22 09:00:00	GLD	ETF	46.99	47.02	46.65	46.68	440100.0
2005-09-22 10:00:00	GLD	ETF	46.67	46.68	46.224	46.53	760000.0
2005-09-22 11:00:00	GLD	ETF	46.52	46.55	46.45	46.46	195700.0
2005-09-22 12:00:00	GLD	ETF	46.47	46.63	46.45	46.54	190000.0
2005-09-22 13:00:00	GLD	ETF	46.53	46.58	46.4	46.51	271700.0

> showing 50 of 1,022 rows — these rows as CSV

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