PREVIEW / etf_1hour / 2004-08-23

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-08-23.parquet
  size:    24 KB
  rows:    676

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
2004-08-23 08:00:00	SPY	ETF	110.5	110.66	110.5	110.66	27100.0
2004-08-23 09:00:00	SPY	ETF	110.66	110.68	110.26	110.32	5729700.0
2004-08-23 10:00:00	SPY	ETF	110.32	110.69	110.23	110.59	8488100.0
2004-08-23 11:00:00	SPY	ETF	110.59	110.62	110.4	110.5	3007300.0
2004-08-23 12:00:00	SPY	ETF	110.5	110.6	110.36	110.38	1322200.0
2004-08-23 13:00:00	SPY	ETF	110.39	110.61	110.24	110.59	3354300.0
2004-08-23 14:00:00	SPY	ETF	110.58	110.77	110.32	110.37	3183000.0
2004-08-23 15:00:00	SPY	ETF	110.35	110.38	110.05	110.2	5888500.0
2004-08-23 16:00:00	SPY	ETF	110.22	110.29	110.14	110.27	1743500.0
2004-08-23 17:00:00	SPY	ETF	110.2	110.22	109.55	110.2	100200.0
2004-08-23 18:00:00	SPY	ETF	110.52	110.52	110.2	110.26	7300.0
2004-08-23 19:00:00	SPY	ETF	110.26	110.27	110.26	110.27	1200.0
2004-08-23 08:00:00	QQQ	ETF	34.13	34.13	34.04	34.08	250900.0
2004-08-23 09:00:00	QQQ	ETF	34.09	34.1	33.91	33.96	14324200.0
2004-08-23 10:00:00	QQQ	ETF	33.96	34.19	33.92	34.187	16616500.0
2004-08-23 11:00:00	QQQ	ETF	34.188	34.189	34.06	34.1	8512900.0
2004-08-23 12:00:00	QQQ	ETF	34.12	34.18	34.07	34.08	6810000.0
2004-08-23 13:00:00	QQQ	ETF	34.079	34.219	34.03	34.18	9181900.0
2004-08-23 14:00:00	QQQ	ETF	34.182	34.27	34.114	34.14	9709200.0
2004-08-23 15:00:00	QQQ	ETF	34.14	34.15	33.99	34.098	13700700.0
2004-08-23 16:00:00	QQQ	ETF	34.09	34.16	34.06	34.08	2072700.0
2004-08-23 17:00:00	QQQ	ETF	34.09	34.12	34.08	34.11	117700.0
2004-08-23 18:00:00	QQQ	ETF	34.11	34.12	34.08	34.08	88900.0
2004-08-23 19:00:00	QQQ	ETF	34.08	34.1	34.08	34.1	6800.0
2004-08-23 08:00:00	IWM	ETF	54.645	54.75	54.645	54.695	8600.0
2004-08-23 09:00:00	IWM	ETF	54.715	54.92	54.22	54.22	3047600.0
2004-08-23 10:00:00	IWM	ETF	54.22	54.69	54.2	54.635	3141200.0
2004-08-23 11:00:00	IWM	ETF	54.615	54.625	54.45	54.56	840200.0
2004-08-23 12:00:00	IWM	ETF	54.55	54.6	54.34	54.345	601400.0
2004-08-23 13:00:00	IWM	ETF	54.355	54.53	54.25	54.495	580000.0
2004-08-23 14:00:00	IWM	ETF	54.51	54.61	54.285	54.3	977600.0
2004-08-23 15:00:00	IWM	ETF	54.315	54.34	54.105	54.215	1705600.0
2004-08-23 16:00:00	IWM	ETF	54.225	54.32	54.2	54.31	287800.0
2004-08-23 08:00:00	DIA	ETF	101.28	101.37	101.28	101.37	8800.0
2004-08-23 09:00:00	DIA	ETF	101.31	101.36	101.09	101.1	621800.0
2004-08-23 10:00:00	DIA	ETF	101.11	101.4	101.06	101.28	548100.0
2004-08-23 11:00:00	DIA	ETF	101.29	101.31	101.13	101.21	419700.0
2004-08-23 12:00:00	DIA	ETF	101.21	101.31	101.1	101.12	326800.0
2004-08-23 13:00:00	DIA	ETF	101.13	101.29	100.97	101.24	442000.0
2004-08-23 14:00:00	DIA	ETF	101.26	101.45	101.04	101.08	317200.0
2004-08-23 15:00:00	DIA	ETF	101.1	101.1	100.81	100.93	1008300.0
2004-08-23 16:00:00	DIA	ETF	100.91	100.97	100.86	100.91	40000.0
2004-08-23 08:00:00	TLT	ETF	86.2	86.2	86.17	86.17	1800.0
2004-08-23 09:00:00	TLT	ETF	86.11	86.16	86.05	86.11	231100.0
2004-08-23 10:00:00	TLT	ETF	86.08	86.11	85.97	85.97	200600.0
2004-08-23 11:00:00	TLT	ETF	86.0	86.0	85.97	86.0	132400.0
2004-08-23 12:00:00	TLT	ETF	86.06	86.11	86.01	86.11	31600.0
2004-08-23 13:00:00	TLT	ETF	86.11	86.15	86.1	86.12	35600.0
2004-08-23 14:00:00	TLT	ETF	86.11	86.12	86.01	86.09	44800.0
2004-08-23 15:00:00	TLT	ETF	86.11	86.17	86.05	86.05	58700.0

> showing 50 of 676 rows — these rows as CSV

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