PREVIEW / etf_1hour / 2005-11-08

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-11-08.parquet
  size:    33 KB
  rows:    1,012

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-08 07:00:00	SPY	ETF	122.28	122.3	122.07	122.07	258600.0
2005-11-08 08:00:00	SPY	ETF	122.2	122.3	122.0	122.0	1951600.0
2005-11-08 09:00:00	SPY	ETF	122.01	122.03	121.79	121.9	7472400.0
2005-11-08 10:00:00	SPY	ETF	121.9	122.13	121.83	121.94	6707900.0
2005-11-08 11:00:00	SPY	ETF	121.94	122.42	121.92	122.32	6653700.0
2005-11-08 12:00:00	SPY	ETF	122.32	122.34	122.06	122.24	4412600.0
2005-11-08 13:00:00	SPY	ETF	122.25	122.27	121.96	122.04	4961100.0
2005-11-08 14:00:00	SPY	ETF	122.05	122.21	121.98	122.09	1883400.0
2005-11-08 15:00:00	SPY	ETF	122.1	122.31	122.04	122.07	6224700.0
2005-11-08 16:00:00	SPY	ETF	122.1	122.25	121.955	122.25	904900.0
2005-11-08 17:00:00	SPY	ETF	122.25	122.27	122.2	122.22	34400.0
2005-11-08 18:00:00	SPY	ETF	122.23	122.24	122.2	122.23	44800.0
2005-11-08 19:00:00	SPY	ETF	122.19	122.19	122.16	122.16	1600.0
2005-11-08 09:00:00	QQQ	ETF	40.06	40.15	39.99	40.03	18004600.0
2005-11-08 10:00:00	QQQ	ETF	40.03	40.23	40.0	40.15	14797200.0
2005-11-08 11:00:00	QQQ	ETF	40.14	40.35	40.12	40.33	16265300.0
2005-11-08 12:00:00	QQQ	ETF	40.33	40.34	40.16	40.23	8317300.0
2005-11-08 13:00:00	QQQ	ETF	40.22	40.24	40.1	40.16	5928600.0
2005-11-08 14:00:00	QQQ	ETF	40.16	40.22	40.0	40.13	4498400.0
2005-11-08 15:00:00	QQQ	ETF	40.13	40.22	40.06	40.13	7995500.0
2005-11-08 07:00:00	IWM	ETF	65.62	65.62	65.6	65.6	9800.0
2005-11-08 08:00:00	IWM	ETF	65.69	65.7	65.47	65.47	275200.0
2005-11-08 09:00:00	IWM	ETF	65.45	65.45	65.1	65.17	4010200.0
2005-11-08 10:00:00	IWM	ETF	65.17	65.36	65.06	65.2	4799900.0
2005-11-08 11:00:00	IWM	ETF	65.21	65.57	65.13	65.51	3285700.0
2005-11-08 12:00:00	IWM	ETF	65.51	65.53	65.23	65.3	1287000.0
2005-11-08 13:00:00	IWM	ETF	65.29	65.45	65.13	65.22	1517900.0
2005-11-08 14:00:00	IWM	ETF	65.21	65.37	65.14	65.2599	1249500.0
2005-11-08 15:00:00	IWM	ETF	65.26	65.48	65.18	65.28	3811600.0
2005-11-08 16:00:00	IWM	ETF	65.28	65.54	65.27	65.49	203600.0
2005-11-08 17:00:00	IWM	ETF	65.51	65.51	65.51	65.51	100.0
2005-11-08 07:00:00	DIA	ETF	105.56	105.56	105.56	105.56	200.0
2005-11-08 08:00:00	DIA	ETF	105.6	105.6	105.53	105.54	15500.0
2005-11-08 09:00:00	DIA	ETF	105.47	105.53	105.36	105.44	554100.0
2005-11-08 10:00:00	DIA	ETF	105.43	105.54	105.3	105.4	642700.0
2005-11-08 11:00:00	DIA	ETF	105.41	105.74	105.37	105.67	639000.0
2005-11-08 12:00:00	DIA	ETF	105.65	105.68	105.49	105.59	252700.0
2005-11-08 13:00:00	DIA	ETF	105.59	105.59	105.41	105.461	147400.0
2005-11-08 14:00:00	DIA	ETF	105.479	105.64	105.46	105.53	185500.0
2005-11-08 15:00:00	DIA	ETF	105.53	105.7	105.48	105.5	584600.0
2005-11-08 16:00:00	DIA	ETF	105.54	105.64	105.53	105.61	13000.0
2005-11-08 08:00:00	GLD	ETF	45.76	45.76	45.7	45.7	4400.0
2005-11-08 09:00:00	GLD	ETF	45.83	46.07	45.82	46.01	127800.0
2005-11-08 10:00:00	GLD	ETF	46.01	46.03	45.86	45.91	121200.0
2005-11-08 11:00:00	GLD	ETF	45.93	46.1	45.91	46.0	83300.0
2005-11-08 12:00:00	GLD	ETF	45.99	46.03	45.892	45.989	83200.0
2005-11-08 13:00:00	GLD	ETF	45.99	46.0	45.94	45.97	50100.0
2005-11-08 14:00:00	GLD	ETF	45.979	46.02	45.97	45.97	47800.0
2005-11-08 15:00:00	GLD	ETF	45.98	46.03	45.97	45.97	49600.0
2005-11-08 16:00:00	GLD	ETF	45.93	45.93	45.91	45.91	2800.0

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

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