PREVIEW / etf_1hour / 2004-12-21

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-12-21.parquet
  size:    27 KB
  rows:    774

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-21 08:00:00	SPY	ETF	119.51	119.65	119.51	119.59	111000.0
2004-12-21 09:00:00	SPY	ETF	119.6	119.89	119.56	119.67	5302100.0
2004-12-21 10:00:00	SPY	ETF	119.66	119.74	119.46	119.55	5083000.0
2004-12-21 11:00:00	SPY	ETF	119.56	119.97	119.51	119.91	5950400.0
2004-12-21 12:00:00	SPY	ETF	119.92	120.11	119.84	120.08	3092700.0
2004-12-21 13:00:00	SPY	ETF	120.08	120.17	119.97	120.08	2133400.0
2004-12-21 14:00:00	SPY	ETF	120.08	120.48	120.06	120.42	4260200.0
2004-12-21 15:00:00	SPY	ETF	120.44	120.47	120.15	120.4	5025200.0
2004-12-21 16:00:00	SPY	ETF	120.41	120.46	120.31	120.37	1621800.0
2004-12-21 17:00:00	SPY	ETF	120.37	120.4	120.35	120.4	103200.0
2004-12-21 18:00:00	SPY	ETF	120.39	120.45	120.39	120.45	3500.0
2004-12-21 19:00:00	SPY	ETF	120.41	120.41	120.38	120.38	400.0
2004-12-21 08:00:00	QQQ	ETF	39.32	39.386	39.32	39.377	516433.0
2004-12-21 09:00:00	QQQ	ETF	39.38	39.537	39.24	39.449	13609662.0
2004-12-21 10:00:00	QQQ	ETF	39.4499	39.48	39.278	39.347	15068465.0
2004-12-21 11:00:00	QQQ	ETF	39.35	39.47	39.327	39.45	8872078.0
2004-12-21 12:00:00	QQQ	ETF	39.45	39.65	39.43	39.629	9049964.0
2004-12-21 13:00:00	QQQ	ETF	39.628	39.65	39.55	39.607	5927003.0
2004-12-21 14:00:00	QQQ	ETF	39.605	39.7	39.59	39.68	9213637.0
2004-12-21 15:00:00	QQQ	ETF	39.68	39.71	39.53	39.66	13374716.0
2004-12-21 16:00:00	QQQ	ETF	39.65	39.68	39.516	39.622	2463235.0
2004-12-21 17:00:00	QQQ	ETF	39.62	39.65	39.5383	39.62	50633.0
2004-12-21 18:00:00	QQQ	ETF	39.62	39.64	39.6	39.64	11170.0
2004-12-21 08:00:00	IWM	ETF	63.93	63.93	63.93	63.93	1000.0
2004-12-21 09:00:00	IWM	ETF	63.95	64.205	63.925	64.0	1421600.0
2004-12-21 10:00:00	IWM	ETF	64.0	64.02	63.805	63.88	1582600.0
2004-12-21 11:00:00	IWM	ETF	63.885	64.115	63.86	64.1	1052400.0
2004-12-21 12:00:00	IWM	ETF	64.095	64.365	64.095	64.335	728000.0
2004-12-21 13:00:00	IWM	ETF	64.335	64.375	64.215	64.295	659800.0
2004-12-21 14:00:00	IWM	ETF	64.295	64.425	64.275	64.405	1086200.0
2004-12-21 15:00:00	IWM	ETF	64.41	64.52	64.16	64.52	1952200.0
2004-12-21 16:00:00	IWM	ETF	64.5	64.53	64.415	64.5	210600.0
2004-12-21 17:00:00	IWM	ETF	64.45	64.52	64.45	64.52	3000.0
2004-12-21 08:00:00	DIA	ETF	106.72	106.72	106.72	106.72	1400.0
2004-12-21 09:00:00	DIA	ETF	106.72	106.89	106.62	106.69	556300.0
2004-12-21 10:00:00	DIA	ETF	106.69	106.81	106.61	106.69	753900.0
2004-12-21 11:00:00	DIA	ETF	106.69	107.09	106.67	107.06	965800.0
2004-12-21 12:00:00	DIA	ETF	107.07	107.22	107.03	107.18	1158400.0
2004-12-21 13:00:00	DIA	ETF	107.18	107.22	107.03	107.14	414500.0
2004-12-21 14:00:00	DIA	ETF	107.13	107.47	107.12	107.41	1288200.0
2004-12-21 15:00:00	DIA	ETF	107.41	107.47	107.2	107.36	1786500.0
2004-12-21 16:00:00	DIA	ETF	107.38	107.46	107.33	107.46	1051900.0
2004-12-21 18:00:00	DIA	ETF	107.45	107.48	107.45	107.45	1200.0
2004-12-21 09:00:00	GLD	ETF	44.13	44.14	44.05	44.13	445200.0
2004-12-21 10:00:00	GLD	ETF	44.14	44.15	44.08	44.11	436100.0
2004-12-21 11:00:00	GLD	ETF	44.09	44.19	44.09	44.18	152300.0
2004-12-21 12:00:00	GLD	ETF	44.17	44.2	44.15	44.17	84700.0
2004-12-21 13:00:00	GLD	ETF	44.17	44.18	44.1	44.17	73400.0
2004-12-21 14:00:00	GLD	ETF	44.18	44.24	44.18	44.21	77400.0
2004-12-21 15:00:00	GLD	ETF	44.2	44.23	44.18	44.21	87100.0

> showing 50 of 774 rows — these rows as CSV

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