PREVIEW / etf_1hour / 2004-08-30

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-08-30.parquet
  size:    24 KB
  rows:    658

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-30 08:00:00	SPY	ETF	111.15	111.2	111.11	111.14	52900.0
2004-08-30 09:00:00	SPY	ETF	111.14	111.34	111.1	111.23	2411400.0
2004-08-30 10:00:00	SPY	ETF	111.23	111.26	110.89	110.97	5215000.0
2004-08-30 11:00:00	SPY	ETF	110.97	111.14	110.91	111.04	4467700.0
2004-08-30 12:00:00	SPY	ETF	111.05	111.06	110.93	111.0	1956800.0
2004-08-30 13:00:00	SPY	ETF	111.0	111.05	110.91	110.99	1558100.0
2004-08-30 14:00:00	SPY	ETF	111.0	111.04	110.78	110.79	2351700.0
2004-08-30 15:00:00	SPY	ETF	110.79	110.813	110.51	110.58	5744700.0
2004-08-30 16:00:00	SPY	ETF	110.58	110.61	110.45	110.56	1429000.0
2004-08-30 17:00:00	SPY	ETF	110.55	110.57	110.55	110.56	3900.0
2004-08-30 18:00:00	SPY	ETF	110.56	110.56	110.56	110.56	1200.0
2004-08-30 08:00:00	QQQ	ETF	34.37	34.37	34.33	34.35	92600.0
2004-08-30 09:00:00	QQQ	ETF	34.34	34.43	34.32	34.38	6132000.0
2004-08-30 10:00:00	QQQ	ETF	34.38	34.39	34.016	34.077	17631600.0
2004-08-30 11:00:00	QQQ	ETF	34.072	34.23	34.06	34.182	7639700.0
2004-08-30 12:00:00	QQQ	ETF	34.18	34.19	34.115	34.1894	4849500.0
2004-08-30 13:00:00	QQQ	ETF	34.181	34.22	34.13	34.18	4412000.0
2004-08-30 14:00:00	QQQ	ETF	34.182	34.22	34.1	34.1	3717500.0
2004-08-30 15:00:00	QQQ	ETF	34.105	34.16	34.03	34.035	12365000.0
2004-08-30 16:00:00	QQQ	ETF	34.04	34.06	33.95	34.0	4520800.0
2004-08-30 17:00:00	QQQ	ETF	34.0	34.04	33.99	34.04	147300.0
2004-08-30 18:00:00	QQQ	ETF	34.014	34.03	34.01	34.02	18700.0
2004-08-30 19:00:00	QQQ	ETF	34.02	34.03	34.01	34.03	31600.0
2004-08-30 08:00:00	IWM	ETF	54.725	54.725	54.725	54.725	1600.0
2004-08-30 09:00:00	IWM	ETF	54.77	54.84	54.595	54.735	579600.0
2004-08-30 10:00:00	IWM	ETF	54.735	54.77	54.24	54.32	1785800.0
2004-08-30 11:00:00	IWM	ETF	54.32	54.57	54.27	54.495	2131600.0
2004-08-30 12:00:00	IWM	ETF	54.495	54.54	54.455	54.535	751400.0
2004-08-30 13:00:00	IWM	ETF	54.54	54.565	54.49	54.545	371600.0
2004-08-30 14:00:00	IWM	ETF	54.55	54.55	54.315	54.35	750800.0
2004-08-30 15:00:00	IWM	ETF	54.35	54.385	54.215	54.275	2336400.0
2004-08-30 16:00:00	IWM	ETF	54.31	54.355	54.25	54.31	550000.0
2004-08-30 08:00:00	DIA	ETF	101.94	101.94	101.86	101.86	2900.0
2004-08-30 09:00:00	DIA	ETF	101.87	102.09	101.81	101.99	796500.0
2004-08-30 10:00:00	DIA	ETF	101.94	102.07	101.78	101.84	611800.0
2004-08-30 11:00:00	DIA	ETF	101.84	101.99	101.8	101.9	493100.0
2004-08-30 12:00:00	DIA	ETF	101.89	101.89	101.79	101.85	338000.0
2004-08-30 13:00:00	DIA	ETF	101.85	101.86	101.68	101.8	167500.0
2004-08-30 14:00:00	DIA	ETF	101.8	101.84	101.63	101.63	771700.0
2004-08-30 15:00:00	DIA	ETF	101.61	101.63	101.37	101.39	1169300.0
2004-08-30 16:00:00	DIA	ETF	101.4	101.41	101.31	101.39	27400.0
2004-08-30 08:00:00	TLT	ETF	86.83	86.88	86.83	86.88	2300.0
2004-08-30 09:00:00	TLT	ETF	87.0	87.04	86.92	87.01	43500.0
2004-08-30 10:00:00	TLT	ETF	87.01	87.17	86.99	87.092	76600.0
2004-08-30 11:00:00	TLT	ETF	87.12	87.16	87.01	87.02	19900.0
2004-08-30 12:00:00	TLT	ETF	87.04	87.13	87.03	87.13	10700.0
2004-08-30 13:00:00	TLT	ETF	87.08	87.15	87.04	87.06	5200.0
2004-08-30 14:00:00	TLT	ETF	87.05	87.11	87.03	87.11	20200.0
2004-08-30 15:00:00	TLT	ETF	87.13	87.2	87.12	87.2	72400.0
2004-08-30 16:00:00	TLT	ETF	87.2	87.23	87.2	87.23	7300.0

> showing 50 of 658 rows — these rows as CSV

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