PREVIEW / etf_1hour / 2004-12-03

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-12-03.parquet
  size:    27 KB
  rows:    796

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
2004-12-03 08:00:00	SPY	ETF	119.88	119.95	118.91	119.33	1020500.0
2004-12-03 09:00:00	SPY	ETF	119.34	119.83	119.18	119.79	6818700.0
2004-12-03 10:00:00	SPY	ETF	119.8	120.14	119.25	119.53	13846300.0
2004-12-03 11:00:00	SPY	ETF	119.52	119.81	119.52	119.72	4692800.0
2004-12-03 12:00:00	SPY	ETF	119.73	119.82	119.35	119.35	3845600.0
2004-12-03 13:00:00	SPY	ETF	119.35	119.46	119.09	119.3	4560100.0
2004-12-03 14:00:00	SPY	ETF	119.31	119.49	119.2	119.34	3676000.0
2004-12-03 15:00:00	SPY	ETF	119.34	119.63	119.33	119.43	6433200.0
2004-12-03 16:00:00	SPY	ETF	119.45	119.55	119.18	119.22	2317500.0
2004-12-03 17:00:00	SPY	ETF	119.22	119.33	119.19	119.33	4800.0
2004-12-03 18:00:00	SPY	ETF	119.25	119.25	119.24	119.24	1000.0
2004-12-03 19:00:00	SPY	ETF	119.25	119.25	119.25	119.25	4500.0
2004-12-03 08:00:00	QQQ	ETF	40.41	40.52	40.22	40.29	5221886.0
2004-12-03 09:00:00	QQQ	ETF	40.29	40.48	40.2	40.46	16287338.0
2004-12-03 10:00:00	QQQ	ETF	40.456	40.59	40.08	40.21	30649992.0
2004-12-03 11:00:00	QQQ	ETF	40.209	40.39	40.2	40.33	14168828.0
2004-12-03 12:00:00	QQQ	ETF	40.33	40.38	40.198	40.2	7958262.0
2004-12-03 13:00:00	QQQ	ETF	40.202	40.3	40.13	40.18	10061854.0
2004-12-03 14:00:00	QQQ	ETF	40.18	40.28	40.13	40.173	9033451.0
2004-12-03 15:00:00	QQQ	ETF	40.18	40.294	40.121	40.14	11880852.0
2004-12-03 16:00:00	QQQ	ETF	40.13	40.224	40.0075	40.051	4987040.0
2004-12-03 17:00:00	QQQ	ETF	40.06	40.08	40.06	40.08	27815.0
2004-12-03 18:00:00	QQQ	ETF	40.08	40.11	40.07	40.1	27784.0
2004-12-03 08:00:00	IWM	ETF	64.205	64.205	63.9	63.93	63800.0
2004-12-03 09:00:00	IWM	ETF	63.93	64.195	63.845	64.195	2986600.0
2004-12-03 10:00:00	IWM	ETF	64.195	64.41	63.94	64.04	3597000.0
2004-12-03 11:00:00	IWM	ETF	64.055	64.22	64.02	64.12	616200.0
2004-12-03 12:00:00	IWM	ETF	64.115	64.19	64.045	64.05	672200.0
2004-12-03 13:00:00	IWM	ETF	64.045	64.13	63.995	64.055	833600.0
2004-12-03 14:00:00	IWM	ETF	64.06	64.175	64.02	64.07	1063000.0
2004-12-03 15:00:00	IWM	ETF	64.07	64.22	63.96	63.985	1723200.0
2004-12-03 16:00:00	IWM	ETF	63.99	64.1	63.81	63.875	801800.0
2004-12-03 08:00:00	DIA	ETF	106.22	106.25	105.7	105.73	16200.0
2004-12-03 09:00:00	DIA	ETF	105.73	106.14	105.56	106.1	907000.0
2004-12-03 10:00:00	DIA	ETF	106.1	106.39	105.66	105.91	2730200.0
2004-12-03 11:00:00	DIA	ETF	105.9	106.13	105.89	106.11	674600.0
2004-12-03 12:00:00	DIA	ETF	106.1	106.16	105.77	105.77	492100.0
2004-12-03 13:00:00	DIA	ETF	105.77	105.86	105.56	105.73	876600.0
2004-12-03 14:00:00	DIA	ETF	105.74	105.9	105.66	105.77	522200.0
2004-12-03 15:00:00	DIA	ETF	105.78	106.01	105.75	105.84	830800.0
2004-12-03 16:00:00	DIA	ETF	105.84	105.86	105.66	105.66	109500.0
2004-12-03 17:00:00	DIA	ETF	105.68	105.68	105.68	105.68	500.0
2004-12-03 18:00:00	DIA	ETF	105.71	105.71	105.71	105.71	1000.0
2004-12-03 19:00:00	DIA	ETF	105.71	105.71	105.71	105.71	2000.0
2004-12-03 09:00:00	GLD	ETF	45.04	45.07	45.0	45.0	226900.0
2004-12-03 10:00:00	GLD	ETF	45.0	45.07	44.8	45.0	952000.0
2004-12-03 11:00:00	GLD	ETF	45.01	45.2	44.97	45.16	436000.0
2004-12-03 12:00:00	GLD	ETF	45.16	45.5	45.1	45.45	813900.0
2004-12-03 13:00:00	GLD	ETF	45.45	45.65	45.44	45.62	921500.0
2004-12-03 14:00:00	GLD	ETF	45.61	45.65	45.53	45.56	273100.0

> showing 50 of 796 rows — these rows as CSV

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