PREVIEW / etf_1hour / 2004-08-25

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-08-25.parquet
  size:    25 KB
  rows:    679

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-25 08:00:00	SPY	ETF	110.48	110.55	110.41	110.41	151800.0
2004-08-25 09:00:00	SPY	ETF	110.38	110.4	110.1	110.21	2984200.0
2004-08-25 10:00:00	SPY	ETF	110.21	110.3	109.9	110.15	4906500.0
2004-08-25 11:00:00	SPY	ETF	110.15	110.29	110.06	110.2	1970900.0
2004-08-25 12:00:00	SPY	ETF	110.19	110.8	110.19	110.68	5339100.0
2004-08-25 13:00:00	SPY	ETF	110.68	110.96	110.67	110.84	5180300.0
2004-08-25 14:00:00	SPY	ETF	110.84	111.25	110.82	111.15	6123800.0
2004-08-25 15:00:00	SPY	ETF	111.15	111.27	111.02	111.12	5921500.0
2004-08-25 16:00:00	SPY	ETF	111.13	111.17	110.99	111.03	1207800.0
2004-08-25 17:00:00	SPY	ETF	111.05	111.06	111.01	111.05	86000.0
2004-08-25 18:00:00	SPY	ETF	111.05	111.08	111.04	111.04	8200.0
2004-08-25 08:00:00	QQQ	ETF	34.13	34.17	34.08	34.09	152900.0
2004-08-25 09:00:00	QQQ	ETF	34.08	34.09	33.973	34.0	9248900.0
2004-08-25 10:00:00	QQQ	ETF	34.0	34.12	33.9	34.1	16975700.0
2004-08-25 11:00:00	QQQ	ETF	34.1	34.16	34.05	34.09	6790400.0
2004-08-25 12:00:00	QQQ	ETF	34.09	34.383	34.086	34.36	15551600.0
2004-08-25 13:00:00	QQQ	ETF	34.36	34.47	34.348	34.41	9674000.0
2004-08-25 14:00:00	QQQ	ETF	34.411	34.59	34.4	34.56	12878000.0
2004-08-25 15:00:00	QQQ	ETF	34.552	34.6	34.49	34.54	13213900.0
2004-08-25 16:00:00	QQQ	ETF	34.547	34.57	34.51	34.52	2917100.0
2004-08-25 17:00:00	QQQ	ETF	34.524	34.53	34.5	34.53	77400.0
2004-08-25 18:00:00	QQQ	ETF	34.52	34.54	34.51	34.52	23500.0
2004-08-25 19:00:00	QQQ	ETF	34.53	34.53	34.51	34.52	26700.0
2004-08-25 08:00:00	IWM	ETF	54.56	54.56	54.54	54.54	3800.0
2004-08-25 09:00:00	IWM	ETF	54.43	54.43	54.19	54.25	1336600.0
2004-08-25 10:00:00	IWM	ETF	54.24	54.35	54.0	54.245	1430600.0
2004-08-25 11:00:00	IWM	ETF	54.23	54.295	54.145	54.245	734000.0
2004-08-25 12:00:00	IWM	ETF	54.245	54.655	54.237	54.605	1885400.0
2004-08-25 13:00:00	IWM	ETF	54.62	54.8	54.575	54.665	2217200.0
2004-08-25 14:00:00	IWM	ETF	54.665	54.875	54.63	54.82	2917800.0
2004-08-25 15:00:00	IWM	ETF	54.815	54.865	54.74	54.85	1957800.0
2004-08-25 16:00:00	IWM	ETF	54.85	54.885	54.5637	54.5637	1275400.0
2004-08-25 17:00:00	IWM	ETF	54.73	54.73	54.7	54.7	40600.0
2004-08-25 08:00:00	DIA	ETF	101.3	101.37	101.25	101.25	17600.0
2004-08-25 09:00:00	DIA	ETF	101.25	101.25	101.01	101.09	262600.0
2004-08-25 10:00:00	DIA	ETF	101.07	101.19	100.79	101.07	1221300.0
2004-08-25 11:00:00	DIA	ETF	101.06	101.15	101.0	101.06	160600.0
2004-08-25 12:00:00	DIA	ETF	101.06	101.58	101.06	101.54	714100.0
2004-08-25 13:00:00	DIA	ETF	101.55	101.8	101.51	101.66	955800.0
2004-08-25 14:00:00	DIA	ETF	101.65	102.09	101.65	102.01	1204400.0
2004-08-25 15:00:00	DIA	ETF	102.03	102.16	101.86	101.95	1006200.0
2004-08-25 16:00:00	DIA	ETF	101.97	102.1	101.88	101.88	85400.0
2004-08-25 17:00:00	DIA	ETF	101.95	101.95	101.82	101.82	300.0
2004-08-25 18:00:00	DIA	ETF	101.85	101.85	101.85	101.85	500.0
2004-08-25 09:00:00	TLT	ETF	86.32	86.35	86.25	86.32	24200.0
2004-08-25 10:00:00	TLT	ETF	86.33	86.64	86.32	86.52	121500.0
2004-08-25 11:00:00	TLT	ETF	86.51	86.61	86.49	86.6	13800.0
2004-08-25 12:00:00	TLT	ETF	86.58	86.58	86.35	86.4	53400.0
2004-08-25 13:00:00	TLT	ETF	86.41	86.54	86.29	86.54	266800.0
2004-08-25 14:00:00	TLT	ETF	86.5	86.5	86.36	86.4	56300.0

> showing 50 of 679 rows — these rows as CSV

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