PREVIEW / etf_1hour / 2005-08-31

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-08-31.parquet
  size:    32 KB
  rows:    956

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-08-31 04:00:00	SPY	ETF	121.05	121.07	121.05	121.06	18300.0
2005-08-31 07:00:00	SPY	ETF	121.12	121.54	121.11	121.41	732300.0
2005-08-31 08:00:00	SPY	ETF	121.4	121.54	121.01	121.15	2789900.0
2005-08-31 09:00:00	SPY	ETF	121.13	121.46	121.01	121.04	7341100.0
2005-08-31 10:00:00	SPY	ETF	121.04	121.38	120.74	121.19	20721100.0
2005-08-31 11:00:00	SPY	ETF	121.19	121.64	121.11	121.44	9895100.0
2005-08-31 12:00:00	SPY	ETF	121.44	121.5	121.03	121.16	9687200.0
2005-08-31 13:00:00	SPY	ETF	121.16	121.68	121.1	121.54	9952900.0
2005-08-31 14:00:00	SPY	ETF	121.55	121.84	121.26	121.82	8151200.0
2005-08-31 15:00:00	SPY	ETF	121.8	122.48	121.17	122.39	21174200.0
2005-08-31 16:00:00	SPY	ETF	122.37	122.67	122.35	122.5	3349800.0
2005-08-31 17:00:00	SPY	ETF	122.48	122.54	122.46	122.49	283700.0
2005-08-31 18:00:00	SPY	ETF	122.52	122.53	122.49	122.51	50200.0
2005-08-31 19:00:00	SPY	ETF	122.49	122.49	122.45	122.49	24800.0
2005-08-31 09:00:00	QQQ	ETF	38.64	38.74	38.55	38.57	7891900.0
2005-08-31 10:00:00	QQQ	ETF	38.57	38.69	38.48	38.53	19606300.0
2005-08-31 11:00:00	QQQ	ETF	38.53	38.74	38.49	38.6	12889000.0
2005-08-31 12:00:00	QQQ	ETF	38.6	38.63	38.51	38.53	5411700.0
2005-08-31 13:00:00	QQQ	ETF	38.53	38.76	38.5	38.71	11038700.0
2005-08-31 14:00:00	QQQ	ETF	38.71	38.79	38.61	38.78	7933300.0
2005-08-31 15:00:00	QQQ	ETF	38.77	39.01	38.75	38.99	20239700.0
2005-08-31 07:00:00	IWM	ETF	65.11	65.23	65.11	65.21	27000.0
2005-08-31 08:00:00	IWM	ETF	65.29	65.31	65.05	65.05	219200.0
2005-08-31 09:00:00	IWM	ETF	65.06	65.41	65.04	65.1	2279900.0
2005-08-31 10:00:00	IWM	ETF	65.1	65.53	64.92	65.42	3321900.0
2005-08-31 11:00:00	IWM	ETF	65.42	65.75	65.36	65.66	3459300.0
2005-08-31 12:00:00	IWM	ETF	65.64	65.7	65.45	65.62	1245200.0
2005-08-31 13:00:00	IWM	ETF	65.63	65.95	65.57	65.87	4122500.0
2005-08-31 14:00:00	IWM	ETF	65.87	66.21	65.75	66.18	3135900.0
2005-08-31 15:00:00	IWM	ETF	66.18	66.43	66.09	66.42	5515600.0
2005-08-31 16:00:00	IWM	ETF	66.42	66.53	66.35	66.42	953000.0
2005-08-31 17:00:00	IWM	ETF	66.46	66.48	66.46	66.48	4100.0
2005-08-31 07:00:00	DIA	ETF	104.07	104.38	104.07	104.26	8000.0
2005-08-31 08:00:00	DIA	ETF	104.28	104.31	103.98	104.0	9100.0
2005-08-31 09:00:00	DIA	ETF	104.0	104.23	103.8	103.82	1631500.0
2005-08-31 10:00:00	DIA	ETF	103.82	104.03	103.54	103.89	1543100.0
2005-08-31 11:00:00	DIA	ETF	103.89	104.39	103.85	104.13	983800.0
2005-08-31 12:00:00	DIA	ETF	104.12	104.17	103.84	103.9	664600.0
2005-08-31 13:00:00	DIA	ETF	103.91	104.39	103.86	104.31	850300.0
2005-08-31 14:00:00	DIA	ETF	104.28	104.5	104.07	104.48	861600.0
2005-08-31 15:00:00	DIA	ETF	104.46	104.85	104.37	104.76	2708600.0
2005-08-31 16:00:00	DIA	ETF	104.79	104.99	104.75	104.88	36500.0
2005-08-31 19:00:00	DIA	ETF	104.9	104.9	104.9	104.9	400.0
2005-08-31 08:00:00	GLD	ETF	43.15	43.15	43.12	43.12	2000.0
2005-08-31 09:00:00	GLD	ETF	43.13	43.19	43.03	43.17	94100.0
2005-08-31 10:00:00	GLD	ETF	43.16	43.32	43.16	43.23	217600.0
2005-08-31 11:00:00	GLD	ETF	43.23	43.33	43.2	43.32	440900.0
2005-08-31 12:00:00	GLD	ETF	43.32	43.35	43.26	43.34	914000.0
2005-08-31 13:00:00	GLD	ETF	43.34	43.36	43.28	43.33	363300.0
2005-08-31 14:00:00	GLD	ETF	43.33	43.39	43.3	43.39	239600.0

> showing 50 of 956 rows — these rows as CSV

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