PREVIEW / etf_1hour / 2004-08-31

all etf 1-hour files

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

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-31 08:00:00	SPY	ETF	110.59	110.76	110.59	110.74	92700.0
2004-08-31 09:00:00	SPY	ETF	110.71	110.92	110.65	110.83	3304500.0
2004-08-31 10:00:00	SPY	ETF	110.83	110.84	110.36	110.43	9852900.0
2004-08-31 11:00:00	SPY	ETF	110.41	110.43	110.2	110.27	6206100.0
2004-08-31 12:00:00	SPY	ETF	110.21	110.44	110.16	110.29	3793900.0
2004-08-31 13:00:00	SPY	ETF	110.29	110.35	110.11	110.3	2784600.0
2004-08-31 14:00:00	SPY	ETF	110.29	110.83	110.1	110.78	5780900.0
2004-08-31 15:00:00	SPY	ETF	110.78	111.08	110.51	111.07	6418400.0
2004-08-31 16:00:00	SPY	ETF	111.07	111.18	111.01	111.16	4428900.0
2004-08-31 17:00:00	SPY	ETF	111.14	111.17	111.12	111.12	47200.0
2004-08-31 18:00:00	SPY	ETF	111.13	111.15	111.1	111.13	24700.0
2004-08-31 19:00:00	SPY	ETF	111.12	111.12	111.12	111.12	2300.0
2004-08-31 08:00:00	QQQ	ETF	33.96	34.05	33.96	34.05	45700.0
2004-08-31 09:00:00	QQQ	ETF	34.04	34.121	33.99	34.076	8608400.0
2004-08-31 10:00:00	QQQ	ETF	34.079	34.08	33.81	33.824	15901300.0
2004-08-31 11:00:00	QQQ	ETF	33.82	33.84	33.67	33.72	13315500.0
2004-08-31 12:00:00	QQQ	ETF	33.72	33.8	33.69	33.71	6175200.0
2004-08-31 13:00:00	QQQ	ETF	33.71	33.75	33.665	33.738	5072900.0
2004-08-31 14:00:00	QQQ	ETF	33.738	33.97	33.67	33.93	10011900.0
2004-08-31 15:00:00	QQQ	ETF	33.928	34.04	33.82	33.997	15180200.0
2004-08-31 16:00:00	QQQ	ETF	33.99	34.05	33.8361	34.023	5324300.0
2004-08-31 17:00:00	QQQ	ETF	34.03	34.05	34.03	34.04	57000.0
2004-08-31 18:00:00	QQQ	ETF	34.036	34.06	34.03	34.03	98900.0
2004-08-31 09:00:00	IWM	ETF	54.39	54.75	54.33	54.64	4296600.0
2004-08-31 10:00:00	IWM	ETF	54.65	54.655	54.13	54.18	4711200.0
2004-08-31 11:00:00	IWM	ETF	54.18	54.19	54.075	54.09	1276400.0
2004-08-31 12:00:00	IWM	ETF	54.1	54.165	54.025	54.095	1242600.0
2004-08-31 13:00:00	IWM	ETF	54.105	54.12	53.94	54.05	728000.0
2004-08-31 14:00:00	IWM	ETF	54.04	54.515	53.965	54.48	1837600.0
2004-08-31 15:00:00	IWM	ETF	54.52	54.705	54.375	54.68	3248400.0
2004-08-31 16:00:00	IWM	ETF	54.67	54.745	54.17	54.715	3539400.0
2004-08-31 17:00:00	IWM	ETF	54.225	54.225	54.225	54.225	100000.0
2004-08-31 19:00:00	IWM	ETF	54.7	54.7	54.635	54.635	400.0
2004-08-31 08:00:00	DIA	ETF	101.5	101.55	101.5	101.55	8900.0
2004-08-31 09:00:00	DIA	ETF	101.53	101.68	101.44	101.61	557800.0
2004-08-31 10:00:00	DIA	ETF	101.61	101.61	101.23	101.29	1203900.0
2004-08-31 11:00:00	DIA	ETF	101.28	101.3	101.05	101.05	496600.0
2004-08-31 12:00:00	DIA	ETF	101.05	101.25	101.0	101.11	555000.0
2004-08-31 13:00:00	DIA	ETF	101.09	101.16	100.93	101.1	482200.0
2004-08-31 14:00:00	DIA	ETF	101.11	101.59	100.9	101.58	574600.0
2004-08-31 15:00:00	DIA	ETF	101.57	101.82	101.32	101.82	1020800.0
2004-08-31 16:00:00	DIA	ETF	101.82	101.91	101.81	101.9	97500.0
2004-08-31 17:00:00	DIA	ETF	101.85	101.9	101.85	101.86	1600.0
2004-08-31 18:00:00	DIA	ETF	101.81	101.81	101.78	101.78	800.0
2004-08-31 19:00:00	DIA	ETF	101.78	101.78	101.78	101.78	1000.0
2004-08-31 08:00:00	TLT	ETF	87.15	87.15	87.15	87.15	400.0
2004-08-31 09:00:00	TLT	ETF	87.3	87.31	87.24	87.29	14000.0
2004-08-31 10:00:00	TLT	ETF	87.41	87.76	87.38	87.72	388300.0
2004-08-31 11:00:00	TLT	ETF	87.71	87.85	87.67	87.85	53600.0
2004-08-31 12:00:00	TLT	ETF	87.83	87.97	87.83	87.97	340400.0

> showing 50 of 685 rows — these rows as CSV

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