PREVIEW / etf_1hour / 2004-12-07

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-12-07.parquet
  size:    28 KB
  rows:    778

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-07 08:00:00	SPY	ETF	119.58	119.65	119.52	119.58	62300.0
2004-12-07 09:00:00	SPY	ETF	119.61	119.62	119.17	119.48	4688200.0
2004-12-07 10:00:00	SPY	ETF	119.48	119.61	119.2	119.36	3967900.0
2004-12-07 11:00:00	SPY	ETF	119.36	119.52	119.27	119.42	2395600.0
2004-12-07 12:00:00	SPY	ETF	119.42	119.57	119.21	119.21	4287000.0
2004-12-07 13:00:00	SPY	ETF	119.21	119.24	118.45	118.7	11969100.0
2004-12-07 14:00:00	SPY	ETF	118.68	118.73	118.37	118.4	6008300.0
2004-12-07 15:00:00	SPY	ETF	118.41	118.53	118.05	118.08	11128600.0
2004-12-07 16:00:00	SPY	ETF	118.09	119.38	117.96	117.97	4159400.0
2004-12-07 17:00:00	SPY	ETF	118.0	118.0	117.92	117.94	60500.0
2004-12-07 18:00:00	SPY	ETF	118.0	118.0	117.96	117.96	1300.0
2004-12-07 19:00:00	SPY	ETF	118.01	118.01	118.01	118.01	1000.0
2004-12-07 08:00:00	QQQ	ETF	40.25	40.39	40.25	40.32	744799.0
2004-12-07 09:00:00	QQQ	ETF	40.33	40.43	40.2	40.4	10657863.0
2004-12-07 10:00:00	QQQ	ETF	40.41	40.5	40.26	40.32	11114728.0
2004-12-07 11:00:00	QQQ	ETF	40.32	40.372	40.29	40.32	7600347.0
2004-12-07 12:00:00	QQQ	ETF	40.32	40.42	40.249	40.25	7031876.0
2004-12-07 13:00:00	QQQ	ETF	40.252	40.252	39.86	39.96	20671165.0
2004-12-07 14:00:00	QQQ	ETF	39.96	39.97	39.68	39.68	15289704.0
2004-12-07 15:00:00	QQQ	ETF	39.68	39.74	39.55	39.58	25169232.0
2004-12-07 16:00:00	QQQ	ETF	39.58	39.62	39.53	39.56	2161056.0
2004-12-07 17:00:00	QQQ	ETF	39.56	39.6	39.52	39.59	282268.0
2004-12-07 18:00:00	QQQ	ETF	39.56	39.58	39.5	39.52	105585.0
2004-12-07 09:00:00	IWM	ETF	63.74	63.825	63.605	63.81	1805200.0
2004-12-07 10:00:00	IWM	ETF	63.8	63.86	63.54	63.62	1114400.0
2004-12-07 11:00:00	IWM	ETF	63.61	63.635	63.47	63.6	780400.0
2004-12-07 12:00:00	IWM	ETF	63.605	63.665	63.375	63.4	553800.0
2004-12-07 13:00:00	IWM	ETF	63.4	63.4	62.875	63.0	2040600.0
2004-12-07 14:00:00	IWM	ETF	62.99	63.05	62.81	62.812	1145600.0
2004-12-07 15:00:00	IWM	ETF	62.8	62.845	62.36	62.36	4013800.0
2004-12-07 16:00:00	IWM	ETF	62.37	62.515	62.35	62.475	389000.0
2004-12-07 17:00:00	IWM	ETF	62.35	62.35	62.35	62.35	9000.0
2004-12-07 08:00:00	DIA	ETF	105.6	105.61	105.52	105.53	13000.0
2004-12-07 09:00:00	DIA	ETF	105.63	105.63	105.21	105.51	432300.0
2004-12-07 10:00:00	DIA	ETF	105.52	105.59	105.25	105.37	759400.0
2004-12-07 11:00:00	DIA	ETF	105.37	105.55	105.3	105.48	185400.0
2004-12-07 12:00:00	DIA	ETF	105.48	105.63	105.38	105.4	249300.0
2004-12-07 13:00:00	DIA	ETF	105.4	105.4	104.65	104.79	2567900.0
2004-12-07 14:00:00	DIA	ETF	104.79	104.88	104.53	104.61	992700.0
2004-12-07 15:00:00	DIA	ETF	104.6	104.7	104.4	104.42	1928400.0
2004-12-07 16:00:00	DIA	ETF	104.43	104.51	104.34	104.34	84500.0
2004-12-07 17:00:00	DIA	ETF	104.46	104.46	104.3	104.38	7600.0
2004-12-07 18:00:00	DIA	ETF	104.38	104.38	104.38	104.38	3000.0
2004-12-07 09:00:00	GLD	ETF	45.3	45.31	45.2	45.23	961300.0
2004-12-07 10:00:00	GLD	ETF	45.23	45.3	45.13	45.29	541400.0
2004-12-07 11:00:00	GLD	ETF	45.29	45.32	45.18	45.27	365500.0
2004-12-07 12:00:00	GLD	ETF	45.27	45.27	45.14	45.21	308700.0
2004-12-07 13:00:00	GLD	ETF	45.21	45.21	45.14	45.16	903200.0
2004-12-07 14:00:00	GLD	ETF	45.16	45.19	45.13	45.17	187900.0
2004-12-07 15:00:00	GLD	ETF	45.15	45.2	45.07	45.1	484100.0

> showing 50 of 778 rows — these rows as CSV

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