PREVIEW / etf_1hour / 2005-08-24

all etf 1-hour files

  file:    by_date/etf_1hour/2005/2005-08-24.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-24 07:00:00	SPY	ETF	121.98	121.98	121.95	121.95	1100.0
2005-08-24 08:00:00	SPY	ETF	121.95	122.16	121.75	121.9	548500.0
2005-08-24 09:00:00	SPY	ETF	121.89	122.03	121.77	122.01	7129000.0
2005-08-24 10:00:00	SPY	ETF	122.0	122.57	121.94	122.41	16030900.0
2005-08-24 11:00:00	SPY	ETF	122.41	122.5	122.18	122.38	5760200.0
2005-08-24 12:00:00	SPY	ETF	122.39	122.73	122.27	122.63	4883800.0
2005-08-24 13:00:00	SPY	ETF	122.64	122.65	122.21	122.29	6866600.0
2005-08-24 14:00:00	SPY	ETF	122.29	122.42	121.79	121.81	9761400.0
2005-08-24 15:00:00	SPY	ETF	121.82	121.87	121.19	121.24	25442900.0
2005-08-24 16:00:00	SPY	ETF	121.23	122.35	121.05	121.14	1026000.0
2005-08-24 17:00:00	SPY	ETF	121.13	121.18	121.12	121.17	31300.0
2005-08-24 18:00:00	SPY	ETF	121.15	121.21	121.1	121.21	29000.0
2005-08-24 19:00:00	SPY	ETF	121.2	121.2	121.19	121.19	4000.0
2005-08-24 09:00:00	QQQ	ETF	38.65	38.71	38.59	38.7	7348300.0
2005-08-24 10:00:00	QQQ	ETF	38.71	39.09	38.69	39.01	21283400.0
2005-08-24 11:00:00	QQQ	ETF	39.01	39.08	38.94	39.05	9823000.0
2005-08-24 12:00:00	QQQ	ETF	39.05	39.18	39.01	39.13	8078000.0
2005-08-24 13:00:00	QQQ	ETF	39.13	39.13	38.97	39.01	5843500.0
2005-08-24 14:00:00	QQQ	ETF	39.0	39.03	38.76	38.77	10671600.0
2005-08-24 15:00:00	QQQ	ETF	38.77	38.78	38.46	38.5	25699800.0
2005-08-24 08:00:00	IWM	ETF	65.31	65.31	65.17	65.18	148300.0
2005-08-24 09:00:00	IWM	ETF	65.21	65.32	65.1	65.2	1503200.0
2005-08-24 10:00:00	IWM	ETF	65.23	65.82	65.21	65.71	4162600.0
2005-08-24 11:00:00	IWM	ETF	65.71	65.74	65.52	65.58	2249500.0
2005-08-24 12:00:00	IWM	ETF	65.58	65.99	65.48	65.98	3978800.0
2005-08-24 13:00:00	IWM	ETF	65.99	66.01	65.78	65.88	2215500.0
2005-08-24 14:00:00	IWM	ETF	65.88	66.03	65.6	65.6	3939200.0
2005-08-24 15:00:00	IWM	ETF	65.61	65.65	64.91	65.22	8705500.0
2005-08-24 16:00:00	IWM	ETF	65.17	65.27	65.15	65.2	70100.0
2005-08-24 17:00:00	IWM	ETF	65.21	65.25	65.21	65.25	5900.0
2005-08-24 08:00:00	DIA	ETF	105.05	105.12	104.89	104.93	112400.0
2005-08-24 09:00:00	DIA	ETF	104.92	105.04	104.76	104.95	792500.0
2005-08-24 10:00:00	DIA	ETF	104.96	105.42	104.91	105.3	1997500.0
2005-08-24 11:00:00	DIA	ETF	105.3	105.37	105.11	105.26	383100.0
2005-08-24 12:00:00	DIA	ETF	105.25	105.5	105.16	105.43	449800.0
2005-08-24 13:00:00	DIA	ETF	105.44	105.44	105.1	105.13	666100.0
2005-08-24 14:00:00	DIA	ETF	105.13	105.23	104.75	104.78	1056700.0
2005-08-24 15:00:00	DIA	ETF	104.7784	105.55	104.2	104.32	3300300.0
2005-08-24 16:00:00	DIA	ETF	104.3	104.315	104.06	104.12	83400.0
2005-08-24 17:00:00	DIA	ETF	104.16	104.24	104.16	104.24	5100.0
2005-08-24 18:00:00	DIA	ETF	104.25	104.25	104.23	104.23	900.0
2005-08-24 08:00:00	GLD	ETF	43.83	43.83	43.83	43.83	2000.0
2005-08-24 09:00:00	GLD	ETF	43.8	43.96	43.8	43.91	66100.0
2005-08-24 10:00:00	GLD	ETF	43.93	43.93	43.55	43.58	128200.0
2005-08-24 11:00:00	GLD	ETF	43.59	43.63	43.41	43.49	219800.0
2005-08-24 12:00:00	GLD	ETF	43.51	43.61	43.49	43.5515	138500.0
2005-08-24 13:00:00	GLD	ETF	43.56	43.65	43.56	43.62	65400.0
2005-08-24 14:00:00	GLD	ETF	43.62	43.68	43.58	43.63	62500.0
2005-08-24 15:00:00	GLD	ETF	43.65	43.65	43.58	43.6	210600.0
2005-08-24 16:00:00	GLD	ETF	43.62	43.64	43.62	43.64	300.0

> showing 50 of 956 rows — these rows as CSV

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