PREVIEW / etf_1hour / 2005-10-04

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-10-04.parquet
  size:    33 KB
  rows:    1,007

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-10-04 07:00:00	SPY	ETF	122.85	122.85	122.76	122.76	60200.0
2005-10-04 08:00:00	SPY	ETF	122.5	122.85	122.5	122.71	129400.0
2005-10-04 09:00:00	SPY	ETF	122.73	122.89	122.5	122.5	4705100.0
2005-10-04 10:00:00	SPY	ETF	122.5	123.03	122.48	122.88	11188200.0
2005-10-04 11:00:00	SPY	ETF	122.89	122.98	122.61	122.94	4619300.0
2005-10-04 12:00:00	SPY	ETF	122.94	122.96	122.77	122.83	2701400.0
2005-10-04 13:00:00	SPY	ETF	122.83	122.89	122.54	122.6	2972800.0
2005-10-04 14:00:00	SPY	ETF	122.59	122.66	121.78	121.82	12509800.0
2005-10-04 15:00:00	SPY	ETF	121.82	121.99	121.33	121.4	17220600.0
2005-10-04 16:00:00	SPY	ETF	121.39	121.44	121.12	121.12	935200.0
2005-10-04 17:00:00	SPY	ETF	121.14	121.2	121.12	121.2	16000.0
2005-10-04 18:00:00	SPY	ETF	121.16	121.16	121.13	121.14	4600.0
2005-10-04 19:00:00	SPY	ETF	121.14	121.17	121.12	121.17	3700.0
2005-10-04 09:00:00	QQQ	ETF	39.6	39.65	39.52	39.56	8375300.0
2005-10-04 10:00:00	QQQ	ETF	39.56	39.74	39.53	39.73	11918700.0
2005-10-04 11:00:00	QQQ	ETF	39.73	39.86	39.64	39.85	9648400.0
2005-10-04 12:00:00	QQQ	ETF	39.85	39.88	39.8	39.83	5410900.0
2005-10-04 13:00:00	QQQ	ETF	39.83	39.86	39.65	39.66	7030100.0
2005-10-04 14:00:00	QQQ	ETF	39.66	39.67	39.39	39.42	14620800.0
2005-10-04 15:00:00	QQQ	ETF	39.41	39.48	39.29	39.31	23481900.0
2005-10-04 09:00:00	IWM	ETF	66.78	67.0	66.59	66.6	1036100.0
2005-10-04 10:00:00	IWM	ETF	66.6	66.93	66.54	66.8	3558600.0
2005-10-04 11:00:00	IWM	ETF	66.79	67.03	66.62	67.03	1377200.0
2005-10-04 12:00:00	IWM	ETF	67.03	67.07	66.96	66.99	1076000.0
2005-10-04 13:00:00	IWM	ETF	66.98	67.1	66.76	66.81	921400.0
2005-10-04 14:00:00	IWM	ETF	66.82	66.87	66.36	66.37	2635100.0
2005-10-04 15:00:00	IWM	ETF	66.37	66.44	65.9212	65.96	5172500.0
2005-10-04 16:00:00	IWM	ETF	65.93	66.08	65.69	65.69	83100.0
2005-10-04 17:00:00	IWM	ETF	65.78	65.78	65.72	65.73	1020000.0
2005-10-04 08:00:00	DIA	ETF	105.4	105.4	105.4	105.4	1000.0
2005-10-04 09:00:00	DIA	ETF	105.42	105.48	105.23	105.23	369900.0
2005-10-04 10:00:00	DIA	ETF	105.24	105.64	105.24	105.53	817700.0
2005-10-04 11:00:00	DIA	ETF	105.53	105.62	105.3	105.61	309000.0
2005-10-04 12:00:00	DIA	ETF	105.61	105.61	105.4415	105.45	446600.0
2005-10-04 13:00:00	DIA	ETF	105.47	105.54	105.25	105.29	555300.0
2005-10-04 14:00:00	DIA	ETF	105.29	105.33	104.6	104.64	1726500.0
2005-10-04 15:00:00	DIA	ETF	104.64	104.73	104.3	104.38	1891100.0
2005-10-04 16:00:00	DIA	ETF	104.37	104.37	104.17	104.17	244900.0
2005-10-04 18:00:00	DIA	ETF	104.17	104.17	104.17	104.17	500.0
2005-10-04 19:00:00	DIA	ETF	104.17	104.17	104.17	104.17	500.0
2005-10-04 08:00:00	GLD	ETF	46.73	46.73	46.7	46.7	400.0
2005-10-04 09:00:00	GLD	ETF	46.58	46.73	46.51	46.66	127400.0
2005-10-04 10:00:00	GLD	ETF	46.67	46.67	46.4	46.42	264200.0
2005-10-04 11:00:00	GLD	ETF	46.41	46.45	46.3	46.37	320500.0
2005-10-04 12:00:00	GLD	ETF	46.39	46.55	46.39	46.4585	65500.0
2005-10-04 13:00:00	GLD	ETF	46.45	46.52	46.45	46.52	52300.0
2005-10-04 14:00:00	GLD	ETF	46.52	46.56	46.42	46.44	649700.0
2005-10-04 15:00:00	GLD	ETF	46.44	46.48	46.4	46.43	259800.0
2005-10-04 16:00:00	GLD	ETF	46.45	46.45	46.45	46.45	2100.0
2005-10-04 18:00:00	GLD	ETF	46.47	46.47	46.47	46.47	300.0

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

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