PREVIEW / etf_1hour / 2004-07-26

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-07-26.parquet
  size:    26 KB
  rows:    709

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-07-26 08:00:00	SPY	ETF	109.25	109.3	109.2	109.25	64000.0
2004-07-26 09:00:00	SPY	ETF	109.22	109.43	109.08	109.26	4104600.0
2004-07-26 10:00:00	SPY	ETF	109.26	109.39	108.81	108.86	7161800.0
2004-07-26 11:00:00	SPY	ETF	108.86	108.93	108.32	108.74	8760400.0
2004-07-26 12:00:00	SPY	ETF	108.73	108.92	108.34	108.47	4686600.0
2004-07-26 13:00:00	SPY	ETF	108.48	108.87	108.36	108.48	5558300.0
2004-07-26 14:00:00	SPY	ETF	108.49	108.78	108.21	108.35	6100900.0
2004-07-26 15:00:00	SPY	ETF	108.35	108.96	108.24	108.85	8569900.0
2004-07-26 16:00:00	SPY	ETF	108.85	108.94	108.68	108.93	1352400.0
2004-07-26 17:00:00	SPY	ETF	108.88	108.91	108.86	108.86	10500.0
2004-07-26 18:00:00	SPY	ETF	108.85	108.9	108.85	108.88	9900.0
2004-07-26 19:00:00	SPY	ETF	108.88	108.9	108.82	108.9	2000.0
2004-07-26 08:00:00	QQQ	ETF	34.36	34.38	34.28	34.3	145700.0
2004-07-26 09:00:00	QQQ	ETF	34.3	34.41	34.2	34.32	12455100.0
2004-07-26 10:00:00	QQQ	ETF	34.32	34.41	34.07	34.09	16734500.0
2004-07-26 11:00:00	QQQ	ETF	34.09	34.13	33.78	33.98	25186400.0
2004-07-26 12:00:00	QQQ	ETF	33.99	34.08	33.808	33.86	12190700.0
2004-07-26 13:00:00	QQQ	ETF	33.86	34.02	33.77	33.864	11516200.0
2004-07-26 14:00:00	QQQ	ETF	33.86	34.01	33.77	33.83	12459700.0
2004-07-26 15:00:00	QQQ	ETF	33.83	34.08	33.8	34.06	18291400.0
2004-07-26 16:00:00	QQQ	ETF	34.06	34.13	34.02	34.093	3637300.0
2004-07-26 17:00:00	QQQ	ETF	34.09	34.09	34.06	34.08	39800.0
2004-07-26 18:00:00	QQQ	ETF	34.07	34.12	34.07	34.12	66100.0
2004-07-26 19:00:00	QQQ	ETF	34.11	34.11	34.07	34.07	7600.0
2004-07-26 09:00:00	IWM	ETF	53.89	54.12	53.855	53.965	1302800.0
2004-07-26 10:00:00	IWM	ETF	53.96	54.065	53.5	53.575	2120800.0
2004-07-26 11:00:00	IWM	ETF	53.625	53.64	53.12	53.4	1527800.0
2004-07-26 12:00:00	IWM	ETF	53.375	53.41	53.065	53.165	1841400.0
2004-07-26 13:00:00	IWM	ETF	53.145	53.31	53.018	53.155	1506400.0
2004-07-26 14:00:00	IWM	ETF	53.155	53.2	52.855	52.92	1376200.0
2004-07-26 15:00:00	IWM	ETF	52.925	53.315	52.865	53.165	2832000.0
2004-07-26 16:00:00	IWM	ETF	53.16	53.2	53.115	53.115	2283600.0
2004-07-26 17:00:00	IWM	ETF	53.125	53.175	53.125	53.175	104000.0
2004-07-26 08:00:00	DIA	ETF	100.03	100.08	100.02	100.02	13700.0
2004-07-26 09:00:00	DIA	ETF	100.08	100.25	99.96	100.06	744300.0
2004-07-26 10:00:00	DIA	ETF	100.06	100.13	99.7	99.72	1553300.0
2004-07-26 11:00:00	DIA	ETF	99.74	99.8	99.31	99.69	2078800.0
2004-07-26 12:00:00	DIA	ETF	99.69	99.81	99.46	99.52	361200.0
2004-07-26 13:00:00	DIA	ETF	99.5	99.9	99.43	99.58	699800.0
2004-07-26 14:00:00	DIA	ETF	99.57	99.78	99.36	99.49	978100.0
2004-07-26 15:00:00	DIA	ETF	99.48	99.92	99.4	99.88	1567000.0
2004-07-26 16:00:00	DIA	ETF	99.89	99.92	99.74	99.92	154500.0
2004-07-26 09:00:00	TLT	ETF	84.8	84.84	84.71	84.73	83500.0
2004-07-26 10:00:00	TLT	ETF	84.7	84.71	84.55	84.58	28900.0
2004-07-26 11:00:00	TLT	ETF	84.58	84.68	84.56	84.56	373000.0
2004-07-26 12:00:00	TLT	ETF	84.56	84.6	84.46	84.6	46500.0
2004-07-26 13:00:00	TLT	ETF	84.59	84.6	84.48	84.56	29200.0
2004-07-26 14:00:00	TLT	ETF	84.56	84.63	84.52	84.59	48800.0
2004-07-26 15:00:00	TLT	ETF	84.65	84.66	84.56	84.56	57500.0
2004-07-26 16:00:00	TLT	ETF	84.55	84.55	84.55	84.55	7100.0

> showing 50 of 709 rows — these rows as CSV

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