PREVIEW / etf_1hour / 2005-09-26

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-09-26.parquet
  size:    32 KB
  rows:    971

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-09-26 05:00:00	SPY	ETF	122.12	122.18	122.12	122.18	25100.0
2005-09-26 06:00:00	SPY	ETF	122.26	122.3	122.2	122.2	29800.0
2005-09-26 07:00:00	SPY	ETF	122.2	122.2	122.02	122.02	165300.0
2005-09-26 08:00:00	SPY	ETF	122.05	122.27	121.95	122.02	1879300.0
2005-09-26 09:00:00	SPY	ETF	122.02	122.17	121.72	121.81	7647500.0
2005-09-26 10:00:00	SPY	ETF	121.79	122.24	121.71	121.97	8623000.0
2005-09-26 11:00:00	SPY	ETF	121.98	122.12	121.89	121.92	7009000.0
2005-09-26 12:00:00	SPY	ETF	121.92	122.15	121.73	121.9	9672000.0
2005-09-26 13:00:00	SPY	ETF	121.91	121.94	121.47	121.62	8750500.0
2005-09-26 14:00:00	SPY	ETF	121.61	121.64	121.08	121.21	8193100.0
2005-09-26 15:00:00	SPY	ETF	121.22	121.68	121.15	121.47	7895600.0
2005-09-26 16:00:00	SPY	ETF	121.47	121.9	121.4575	121.56	7307800.0
2005-09-26 17:00:00	SPY	ETF	121.48	121.6	121.47	121.55	831300.0
2005-09-26 18:00:00	SPY	ETF	121.53	121.58	121.53	121.58	10400.0
2005-09-26 09:00:00	QQQ	ETF	38.97	39.03	38.85	38.88	11185800.0
2005-09-26 10:00:00	QQQ	ETF	38.87	39.03	38.83	38.92	11927700.0
2005-09-26 11:00:00	QQQ	ETF	38.92	38.98	38.89	38.9	6078300.0
2005-09-26 12:00:00	QQQ	ETF	38.9	38.99	38.83	38.87	6160500.0
2005-09-26 13:00:00	QQQ	ETF	38.87	38.89	38.68	38.77	8857900.0
2005-09-26 14:00:00	QQQ	ETF	38.77	38.78	38.55	38.64	10967900.0
2005-09-26 15:00:00	QQQ	ETF	38.65	38.79	38.63	38.76	7049500.0
2005-09-26 08:00:00	IWM	ETF	65.68	65.78	65.62	65.67	60800.0
2005-09-26 09:00:00	IWM	ETF	65.58	65.76	65.24	65.27	4383800.0
2005-09-26 10:00:00	IWM	ETF	65.28	65.8	65.27	65.69	2970300.0
2005-09-26 11:00:00	IWM	ETF	65.69	65.74	65.6	65.62	1754400.0
2005-09-26 12:00:00	IWM	ETF	65.62	65.85	65.61	65.79	1732900.0
2005-09-26 13:00:00	IWM	ETF	65.8	65.8	65.35	65.51	4132200.0
2005-09-26 14:00:00	IWM	ETF	65.5	65.53	65.19	65.31	2324700.0
2005-09-26 15:00:00	IWM	ETF	65.31	65.6	65.24	65.46	2793900.0
2005-09-26 16:00:00	IWM	ETF	65.52	65.63	65.52	65.55	1266100.0
2005-09-26 17:00:00	IWM	ETF	65.49	65.61	65.49	65.51	60600.0
2005-09-26 18:00:00	IWM	ETF	65.6	65.6	65.6	65.6	100.0
2005-09-26 07:00:00	DIA	ETF	104.64	104.65	104.61	104.64	2100.0
2005-09-26 08:00:00	DIA	ETF	104.64	104.73	104.6	104.6	19100.0
2005-09-26 09:00:00	DIA	ETF	104.58	104.95	104.55	104.61	941700.0
2005-09-26 10:00:00	DIA	ETF	104.62	105.03	104.51	104.75	1489900.0
2005-09-26 11:00:00	DIA	ETF	104.76	104.87	104.68	104.71	254700.0
2005-09-26 12:00:00	DIA	ETF	104.71	104.92	104.59	104.74	282500.0
2005-09-26 13:00:00	DIA	ETF	104.74	104.74	104.32	104.47	513900.0
2005-09-26 14:00:00	DIA	ETF	104.47	104.7	104.02	104.12	560300.0
2005-09-26 15:00:00	DIA	ETF	104.09	104.52	104.06	104.41	561500.0
2005-09-26 16:00:00	DIA	ETF	104.565	104.565	104.1266	104.1266	1170900.0
2005-09-26 17:00:00	DIA	ETF	104.41	104.49	104.4	104.44	9100.0
2005-09-26 08:00:00	GLD	ETF	45.95	45.95	45.85	45.85	3600.0
2005-09-26 09:00:00	GLD	ETF	45.8	46.05	45.8	46.01	265900.0
2005-09-26 10:00:00	GLD	ETF	46.02	46.26	46.008	46.23	196400.0
2005-09-26 11:00:00	GLD	ETF	46.23	46.33	46.16	46.33	253100.0
2005-09-26 12:00:00	GLD	ETF	46.3	46.56	46.3	46.51	311800.0
2005-09-26 13:00:00	GLD	ETF	46.52	46.55	46.44	46.54	143300.0
2005-09-26 14:00:00	GLD	ETF	46.54	46.6	46.506	46.59	94900.0

> showing 50 of 971 rows — these rows as CSV

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