PREVIEW / etf_1hour / 2005-11-09

all etf 1-hour files

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

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-11-09 07:00:00	SPY	ETF	122.3	122.3	122.1	122.1	87000.0
2005-11-09 08:00:00	SPY	ETF	122.11	122.25	122.01	122.13	1549600.0
2005-11-09 09:00:00	SPY	ETF	122.13	122.18	121.86	121.94	6057200.0
2005-11-09 10:00:00	SPY	ETF	121.94	122.38	121.86	122.1	7869500.0
2005-11-09 11:00:00	SPY	ETF	122.1	122.2	121.92	122.16	4994500.0
2005-11-09 12:00:00	SPY	ETF	122.15	122.95	122.08	122.8	13332800.0
2005-11-09 13:00:00	SPY	ETF	122.8	122.82	122.47	122.57	4716100.0
2005-11-09 14:00:00	SPY	ETF	122.58	122.72	122.27	122.38	8316200.0
2005-11-09 15:00:00	SPY	ETF	122.39	122.68	122.19	122.25	8763000.0
2005-11-09 16:00:00	SPY	ETF	122.26	122.39	122.2	122.34	750400.0
2005-11-09 17:00:00	SPY	ETF	122.34	122.34	122.2	122.29	585900.0
2005-11-09 18:00:00	SPY	ETF	122.29	122.3	122.27	122.29	2600.0
2005-11-09 19:00:00	SPY	ETF	122.35	122.39	122.3	122.3	6700.0
2005-11-09 09:00:00	QQQ	ETF	40.13	40.17	40.06	40.06	6608500.0
2005-11-09 10:00:00	QQQ	ETF	40.07	40.21	40.03	40.11	10121800.0
2005-11-09 11:00:00	QQQ	ETF	40.11	40.15	40.04	40.12	7159200.0
2005-11-09 12:00:00	QQQ	ETF	40.12	40.33	40.07	40.28	16501600.0
2005-11-09 13:00:00	QQQ	ETF	40.28	40.33	40.17	40.22	5396500.0
2005-11-09 14:00:00	QQQ	ETF	40.22	40.27	40.09	40.15	9252300.0
2005-11-09 15:00:00	QQQ	ETF	40.15	40.24	40.13	40.16	9918300.0
2005-11-09 07:00:00	IWM	ETF	65.61	65.62	65.48	65.48	3900.0
2005-11-09 08:00:00	IWM	ETF	65.48	65.61	65.44	65.48	4106800.0
2005-11-09 09:00:00	IWM	ETF	65.46	65.49	65.11	65.18	1692000.0
2005-11-09 10:00:00	IWM	ETF	65.19	65.44	65.12	65.26	2097800.0
2005-11-09 11:00:00	IWM	ETF	65.25	65.41	65.13	65.391	1743200.0
2005-11-09 12:00:00	IWM	ETF	65.4	66.09	65.3	66.06	10742000.0
2005-11-09 13:00:00	IWM	ETF	66.05	66.1	65.83	65.88	1640000.0
2005-11-09 14:00:00	IWM	ETF	65.88	65.94	65.57	65.63	3168100.0
2005-11-09 15:00:00	IWM	ETF	65.64	65.85	65.56	65.59	3981300.0
2005-11-09 16:00:00	IWM	ETF	65.61	65.74	65.58	65.74	233600.0
2005-11-09 08:00:00	DIA	ETF	105.57	105.6	105.52	105.52	111100.0
2005-11-09 09:00:00	DIA	ETF	105.42	105.54	105.32	105.32	360300.0
2005-11-09 10:00:00	DIA	ETF	105.3312	105.64	105.27	105.52	939100.0
2005-11-09 11:00:00	DIA	ETF	105.52	105.53	105.37	105.5	450300.0
2005-11-09 12:00:00	DIA	ETF	105.5	106.11	105.43	106.02	908100.0
2005-11-09 13:00:00	DIA	ETF	106.02	106.04	105.73	105.81	242800.0
2005-11-09 14:00:00	DIA	ETF	105.81	105.88	105.59	105.67	320600.0
2005-11-09 15:00:00	DIA	ETF	105.66	105.89	105.47	105.51	991900.0
2005-11-09 16:00:00	DIA	ETF	105.53	105.63	105.53	105.61	7700.0
2005-11-09 17:00:00	DIA	ETF	105.6	105.6	105.6	105.6	1000.0
2005-11-09 08:00:00	GLD	ETF	46.08	46.26	46.08	46.26	2100.0
2005-11-09 09:00:00	GLD	ETF	46.28	46.28	46.03	46.09	128500.0
2005-11-09 10:00:00	GLD	ETF	46.09	46.16	46.03	46.14	205400.0
2005-11-09 11:00:00	GLD	ETF	46.14	46.45	46.12	46.41	223300.0
2005-11-09 12:00:00	GLD	ETF	46.41	46.65	46.41	46.54	158700.0
2005-11-09 13:00:00	GLD	ETF	46.54	46.56	46.45	46.491	97200.0
2005-11-09 14:00:00	GLD	ETF	46.49	46.51	46.48	46.5	114000.0
2005-11-09 15:00:00	GLD	ETF	46.4901	46.53	46.46	46.53	410100.0
2005-11-09 16:00:00	GLD	ETF	46.56	46.56	46.55	46.55	2100.0
2005-11-09 07:00:00	TLT	ETF	89.15	89.15	89.15	89.15	1000.0

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

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