PREVIEW / etf_1hour / 2005-11-02

all etf 1-hour files

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

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-02 07:00:00	SPY	ETF	120.6	120.6	120.42	120.42	46000.0
2005-11-02 08:00:00	SPY	ETF	120.37	120.61	120.21	120.27	1182600.0
2005-11-02 09:00:00	SPY	ETF	120.27	120.77	120.13	120.63	7283700.0
2005-11-02 10:00:00	SPY	ETF	120.64	121.07	120.58	120.98	12828800.0
2005-11-02 11:00:00	SPY	ETF	120.98	121.38	120.96	121.25	10748100.0
2005-11-02 12:00:00	SPY	ETF	121.26	121.56	121.1	121.5	7779400.0
2005-11-02 13:00:00	SPY	ETF	121.49	121.54	121.35	121.47	5569200.0
2005-11-02 14:00:00	SPY	ETF	121.46	121.66	121.23	121.33	10515600.0
2005-11-02 15:00:00	SPY	ETF	121.33	121.66	121.29	121.63	12931400.0
2005-11-02 16:00:00	SPY	ETF	121.63	121.75	121.55	121.7	1764700.0
2005-11-02 17:00:00	SPY	ETF	121.7	121.74	121.4495	121.74	62800.0
2005-11-02 18:00:00	SPY	ETF	121.7	121.73	121.68	121.7	15900.0
2005-11-02 09:00:00	QQQ	ETF	38.72	39.01	38.71	38.91	13601300.0
2005-11-02 10:00:00	QQQ	ETF	38.91	39.12	38.88	39.09	18014500.0
2005-11-02 11:00:00	QQQ	ETF	39.09	39.26	39.09	39.22	15099600.0
2005-11-02 12:00:00	QQQ	ETF	39.22	39.46	39.14	39.41	15703900.0
2005-11-02 13:00:00	QQQ	ETF	39.4	39.41	39.31	39.39	9261300.0
2005-11-02 14:00:00	QQQ	ETF	39.39	39.45	39.21	39.25	12449500.0
2005-11-02 15:00:00	QQQ	ETF	39.26	39.4	39.25	39.34	10436900.0
2005-11-02 07:00:00	IWM	ETF	64.11	64.11	64.1	64.11	27000.0
2005-11-02 08:00:00	IWM	ETF	64.1	64.14	63.91	63.97	792400.0
2005-11-02 09:00:00	IWM	ETF	63.97	64.59	63.85	64.42	3814900.0
2005-11-02 10:00:00	IWM	ETF	64.42	64.78	64.32	64.75	5993000.0
2005-11-02 11:00:00	IWM	ETF	64.74	64.95	64.74	64.88	6419900.0
2005-11-02 12:00:00	IWM	ETF	64.88	65.09	64.75	65.02	3780600.0
2005-11-02 13:00:00	IWM	ETF	65.02	65.14	64.96	65.04	3026100.0
2005-11-02 14:00:00	IWM	ETF	65.05	65.22	65.0	65.1	3751700.0
2005-11-02 15:00:00	IWM	ETF	65.1	65.39	65.07	65.38	4924700.0
2005-11-02 16:00:00	IWM	ETF	65.38	65.41	65.27	65.35	222500.0
2005-11-02 17:00:00	IWM	ETF	65.4	65.4	65.35	65.35	600.0
2005-11-02 18:00:00	IWM	ETF	65.34	65.34	65.34	65.34	500.0
2005-11-02 08:00:00	DIA	ETF	104.03	104.03	103.86	103.91	3800.0
2005-11-02 09:00:00	DIA	ETF	103.92	104.15	103.76	103.98	603700.0
2005-11-02 10:00:00	DIA	ETF	103.98	104.33	103.98	104.28	1067200.0
2005-11-02 11:00:00	DIA	ETF	104.31	104.64	104.3	104.56	1025300.0
2005-11-02 12:00:00	DIA	ETF	104.56	104.81	104.49	104.74	544500.0
2005-11-02 13:00:00	DIA	ETF	104.75	104.76	104.6	104.73	423400.0
2005-11-02 14:00:00	DIA	ETF	104.71	104.89	104.45	104.51	1006100.0
2005-11-02 15:00:00	DIA	ETF	104.51	104.73	104.494	104.64	1249100.0
2005-11-02 16:00:00	DIA	ETF	104.64	104.74	104.61	104.7	346500.0
2005-11-02 08:00:00	GLD	ETF	45.8	45.94	45.8	45.94	7500.0
2005-11-02 09:00:00	GLD	ETF	45.92	46.0	45.9	45.94	173200.0
2005-11-02 10:00:00	GLD	ETF	45.93	46.19	45.9	46.14	228600.0
2005-11-02 11:00:00	GLD	ETF	46.14	46.18	46.04	46.1	201300.0
2005-11-02 12:00:00	GLD	ETF	46.08	46.23	46.08	46.149	108600.0
2005-11-02 13:00:00	GLD	ETF	46.15	46.16	46.09	46.12	59800.0
2005-11-02 14:00:00	GLD	ETF	46.14	46.19	46.1201	46.1505	55000.0
2005-11-02 15:00:00	GLD	ETF	46.1501	46.16	46.09	46.09	125500.0
2005-11-02 16:00:00	GLD	ETF	46.1	46.1	46.1	46.1	100.0
2005-11-02 08:00:00	TLT	ETF	88.79	89.0	88.79	88.96	3600.0

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

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