PREVIEW / etf_1hour / 2005-02-02

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-02-02.parquet
  size:    28 KB
  rows:    832

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-02-02 08:00:00	SPY	ETF	119.13	119.18	119.09	119.09	17500.0
2005-02-02 09:00:00	SPY	ETF	119.09	119.12	118.92	118.93	5664700.0
2005-02-02 10:00:00	SPY	ETF	118.94	119.2	118.9	119.18	9789500.0
2005-02-02 11:00:00	SPY	ETF	119.19	119.33	119.14	119.33	4134100.0
2005-02-02 12:00:00	SPY	ETF	119.3	119.33	119.06	119.18	3207100.0
2005-02-02 13:00:00	SPY	ETF	119.18	119.22	119.11	119.18	2112200.0
2005-02-02 14:00:00	SPY	ETF	119.17	119.59	119.03	119.24	16067400.0
2005-02-02 15:00:00	SPY	ETF	119.23	119.4	118.91	119.35	9747900.0
2005-02-02 16:00:00	SPY	ETF	119.4	119.48	119.2	119.24	975500.0
2005-02-02 17:00:00	SPY	ETF	119.24	119.28	119.16	119.16	28500.0
2005-02-02 18:00:00	SPY	ETF	119.16	119.2	119.14	119.2	1300.0
2005-02-02 19:00:00	SPY	ETF	119.19	119.19	119.19	119.19	200.0
2005-02-02 09:00:00	QQQ	ETF	37.65	37.66	37.49	37.49	11983600.0
2005-02-02 10:00:00	QQQ	ETF	37.49	37.58	37.4	37.57	15190800.0
2005-02-02 11:00:00	QQQ	ETF	37.56	37.59	37.52	37.58	5793700.0
2005-02-02 12:00:00	QQQ	ETF	37.58	37.59	37.48	37.53	4356600.0
2005-02-02 13:00:00	QQQ	ETF	37.53	37.59	37.52	37.57	3640400.0
2005-02-02 14:00:00	QQQ	ETF	37.57	37.73	37.4	37.48	22851900.0
2005-02-02 15:00:00	QQQ	ETF	37.48	37.61	37.31	37.57	25220800.0
2005-02-02 08:00:00	IWM	ETF	62.575	62.58	62.575	62.58	600.0
2005-02-02 09:00:00	IWM	ETF	62.59	62.665	62.47	62.49	1705600.0
2005-02-02 10:00:00	IWM	ETF	62.5	62.74	62.46	62.71	2691600.0
2005-02-02 11:00:00	IWM	ETF	62.7	62.73	62.6	62.68	962800.0
2005-02-02 12:00:00	IWM	ETF	62.66	62.68	62.53	62.6	1640400.0
2005-02-02 13:00:00	IWM	ETF	62.6	62.645	62.555	62.605	1961800.0
2005-02-02 14:00:00	IWM	ETF	62.61	62.995	62.605	62.77	3154800.0
2005-02-02 15:00:00	IWM	ETF	62.775	62.885	62.56	62.885	3616600.0
2005-02-02 16:00:00	IWM	ETF	62.89	62.945	62.5856	62.825	1229200.0
2005-02-02 17:00:00	IWM	ETF	62.875	62.875	62.875	62.875	1000.0
2005-02-02 18:00:00	IWM	ETF	62.735	62.735	62.735	62.735	800.0
2005-02-02 08:00:00	DIA	ETF	105.6	105.62	105.48	105.48	12400.0
2005-02-02 09:00:00	DIA	ETF	105.48	105.52	105.37	105.39	401300.0
2005-02-02 10:00:00	DIA	ETF	105.39	105.68	105.35	105.64	675100.0
2005-02-02 11:00:00	DIA	ETF	105.65	105.85	105.61	105.85	588300.0
2005-02-02 12:00:00	DIA	ETF	105.85	105.88	105.64	105.7	504300.0
2005-02-02 13:00:00	DIA	ETF	105.73	105.79	105.7	105.78	179800.0
2005-02-02 14:00:00	DIA	ETF	105.78	106.13	105.65	105.85	1376300.0
2005-02-02 15:00:00	DIA	ETF	105.86	105.91	105.59	105.88	739300.0
2005-02-02 16:00:00	DIA	ETF	105.87	105.98	105.8	105.87	79900.0
2005-02-02 18:00:00	DIA	ETF	105.8	105.8	105.8	105.8	100.0
2005-02-02 19:00:00	DIA	ETF	105.76	105.76	105.76	105.76	700.0
2005-02-02 09:00:00	GLD	ETF	42.22	42.23	42.13	42.19	274200.0
2005-02-02 10:00:00	GLD	ETF	42.18	42.18	42.09	42.13	105700.0
2005-02-02 11:00:00	GLD	ETF	42.13	42.13	42.02	42.09	139100.0
2005-02-02 12:00:00	GLD	ETF	42.1	42.11	42.02	42.06	41900.0
2005-02-02 13:00:00	GLD	ETF	42.07	42.16	42.07	42.16	71900.0
2005-02-02 14:00:00	GLD	ETF	42.14	42.22	42.1	42.2	98900.0
2005-02-02 15:00:00	GLD	ETF	42.19	42.22	42.16	42.17	116600.0
2005-02-02 09:00:00	TLT	ETF	91.2	91.29	91.2	91.22	80100.0
2005-02-02 10:00:00	TLT	ETF	91.22	91.29	91.2	91.2	62100.0

> showing 50 of 832 rows — these rows as CSV

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