PREVIEW / etf_1hour / 2005-11-04

all etf 1-hour files

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

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-04 07:00:00	SPY	ETF	122.2	122.2	122.13	122.15	143300.0
2005-11-04 08:00:00	SPY	ETF	122.15	122.28	121.96	122.18	3028800.0
2005-11-04 09:00:00	SPY	ETF	122.18	122.49	122.15	122.32	7627800.0
2005-11-04 10:00:00	SPY	ETF	122.3201	122.43	121.55	121.67	15967500.0
2005-11-04 11:00:00	SPY	ETF	121.67	121.99	121.61	121.8	8005400.0
2005-11-04 12:00:00	SPY	ETF	121.84	122.04	121.68	121.94	7177100.0
2005-11-04 13:00:00	SPY	ETF	121.96	122.0	121.73	121.74	4409700.0
2005-11-04 14:00:00	SPY	ETF	121.74	122.05	121.65	121.86	3875200.0
2005-11-04 15:00:00	SPY	ETF	121.86	122.22	121.76	122.11	7439100.0
2005-11-04 16:00:00	SPY	ETF	122.12	122.17	120.11	122.1	940200.0
2005-11-04 17:00:00	SPY	ETF	122.08	122.13	122.01	122.01	46000.0
2005-11-04 18:00:00	SPY	ETF	122.1	122.11	122.1	122.11	900.0
2005-11-04 09:00:00	QQQ	ETF	40.0	40.13	39.97	40.11	14972400.0
2005-11-04 10:00:00	QQQ	ETF	40.12	40.23	39.84	39.9	25011800.0
2005-11-04 11:00:00	QQQ	ETF	39.9	40.03	39.88	39.97	13188200.0
2005-11-04 12:00:00	QQQ	ETF	39.97	40.0	39.9	39.98	4610500.0
2005-11-04 13:00:00	QQQ	ETF	39.98	40.0	39.9	39.92	4069900.0
2005-11-04 14:00:00	QQQ	ETF	39.93	40.05	39.87	39.96	10197800.0
2005-11-04 15:00:00	QQQ	ETF	39.96	40.13	38.98	40.06	15024800.0
2005-11-04 07:00:00	IWM	ETF	65.62	65.67	65.62	65.62	76000.0
2005-11-04 08:00:00	IWM	ETF	65.64	65.66	65.49	65.49	797600.0
2005-11-04 09:00:00	IWM	ETF	65.51	65.77	65.4	65.62	4631000.0
2005-11-04 10:00:00	IWM	ETF	65.62	65.7	65.04	65.18	5382300.0
2005-11-04 11:00:00	IWM	ETF	65.15	65.3	65.05	65.19	3375700.0
2005-11-04 12:00:00	IWM	ETF	65.18	65.49	65.09	65.39	3118100.0
2005-11-04 13:00:00	IWM	ETF	65.38	65.4	65.15	65.17	1917100.0
2005-11-04 14:00:00	IWM	ETF	65.16	65.36	64.94	65.13	2689200.0
2005-11-04 15:00:00	IWM	ETF	65.14	65.49	65.06	65.49	3260400.0
2005-11-04 16:00:00	IWM	ETF	65.5	65.6	65.48	65.48	269600.0
2005-11-04 17:00:00	IWM	ETF	65.6	65.6	65.55	65.55	600.0
2005-11-04 18:00:00	IWM	ETF	65.55	65.55	65.55	65.55	300.0
2005-11-04 07:00:00	DIA	ETF	105.26	105.26	105.26	105.26	2500.0
2005-11-04 08:00:00	DIA	ETF	105.26	105.33	105.11	105.24	256800.0
2005-11-04 09:00:00	DIA	ETF	105.23	105.45	105.23	105.43	320900.0
2005-11-04 10:00:00	DIA	ETF	105.44	105.49	104.74	104.8	934900.0
2005-11-04 11:00:00	DIA	ETF	104.83	105.06	104.79	104.94	349800.0
2005-11-04 12:00:00	DIA	ETF	104.94	105.12	104.85	105.06	158000.0
2005-11-04 13:00:00	DIA	ETF	105.07	105.08	104.84	104.9	231000.0
2005-11-04 14:00:00	DIA	ETF	104.88	105.17	104.8	105.02	544400.0
2005-11-04 15:00:00	DIA	ETF	105.01	105.33	104.91	105.25	1334700.0
2005-11-04 16:00:00	DIA	ETF	105.25	105.25	105.18	105.18	13500.0
2005-11-04 17:00:00	DIA	ETF	105.18	105.18	105.18	105.18	200.0
2005-11-04 18:00:00	DIA	ETF	105.18	105.22	105.18	105.22	500.0
2005-11-04 07:00:00	GLD	ETF	45.93	45.96	45.93	45.96	1500.0
2005-11-04 08:00:00	GLD	ETF	45.99	46.31	45.93	46.24	13500.0
2005-11-04 09:00:00	GLD	ETF	46.18	46.24	45.93	46.0	135900.0
2005-11-04 10:00:00	GLD	ETF	45.98	46.0	45.32	45.42	685200.0
2005-11-04 11:00:00	GLD	ETF	45.43	45.55	45.42	45.46	307900.0
2005-11-04 12:00:00	GLD	ETF	45.48	45.55	45.42	45.53	222300.0
2005-11-04 13:00:00	GLD	ETF	45.54	45.59	45.45	45.48	62900.0

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

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