PREVIEW / etf_1hour / 2004-09-01

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-09-01.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-09-01 08:00:00	SPY	ETF	111.08	111.1	110.99	111.0	48200.0
2004-09-01 09:00:00	SPY	ETF	111.04	111.19	110.87	110.88	4546800.0
2004-09-01 10:00:00	SPY	ETF	110.88	111.64	110.87	111.37	10483300.0
2004-09-01 11:00:00	SPY	ETF	111.37	111.54	111.2	111.27	3635800.0
2004-09-01 12:00:00	SPY	ETF	111.28	111.42	111.18	111.31	2627300.0
2004-09-01 13:00:00	SPY	ETF	111.312	111.32	110.48	111.18	15657400.0
2004-09-01 14:00:00	SPY	ETF	111.18	111.3	111.0	111.2	2867600.0
2004-09-01 15:00:00	SPY	ETF	111.2	111.31	110.93	111.31	4903200.0
2004-09-01 16:00:00	SPY	ETF	111.31	111.4	111.2	111.34	3202700.0
2004-09-01 17:00:00	SPY	ETF	111.32	111.34	111.32	111.33	14200.0
2004-09-01 18:00:00	SPY	ETF	111.31	111.31	111.31	111.31	500.0
2004-09-01 19:00:00	SPY	ETF	111.34	111.34	111.34	111.34	7800.0
2004-09-01 08:00:00	QQQ	ETF	34.02	34.02	33.96	33.98	214700.0
2004-09-01 09:00:00	QQQ	ETF	33.98	34.1	33.91	34.0	8296900.0
2004-09-01 10:00:00	QQQ	ETF	34.0	34.45	33.981	34.34	25055400.0
2004-09-01 11:00:00	QQQ	ETF	34.34	34.39	34.22	34.28	8732600.0
2004-09-01 12:00:00	QQQ	ETF	34.28	34.34	34.24	34.26	5471300.0
2004-09-01 13:00:00	QQQ	ETF	34.25	34.28	33.8	34.16	25048800.0
2004-09-01 14:00:00	QQQ	ETF	34.152	34.22	34.08	34.19	5283900.0
2004-09-01 15:00:00	QQQ	ETF	34.19	34.27	34.06	34.26	11938500.0
2004-09-01 16:00:00	QQQ	ETF	34.261	34.3184	34.22	34.27	3146200.0
2004-09-01 17:00:00	QQQ	ETF	34.261	34.28	34.25	34.27	94100.0
2004-09-01 18:00:00	QQQ	ETF	34.262	34.27	34.24	34.25	41200.0
2004-09-01 19:00:00	QQQ	ETF	34.24	34.24	34.24	34.24	300.0
2004-09-01 08:00:00	IWM	ETF	54.68	54.68	54.68	54.68	9800.0
2004-09-01 09:00:00	IWM	ETF	54.605	55.545	54.545	54.95	5489200.0
2004-09-01 10:00:00	IWM	ETF	54.95	55.45	54.895	55.26	3965000.0
2004-09-01 11:00:00	IWM	ETF	55.26	55.365	55.15	55.185	1550800.0
2004-09-01 12:00:00	IWM	ETF	55.185	55.25	55.115	55.2	1185400.0
2004-09-01 13:00:00	IWM	ETF	55.205	55.205	54.765	55.06	2143600.0
2004-09-01 14:00:00	IWM	ETF	55.075	55.075	54.95	54.99	1703600.0
2004-09-01 15:00:00	IWM	ETF	54.97	55.08	54.825	55.08	1996800.0
2004-09-01 16:00:00	IWM	ETF	55.07	55.125	55.015	55.125	629200.0
2004-09-01 17:00:00	IWM	ETF	55.145	55.145	55.145	55.145	1000.0
2004-09-01 08:00:00	DIA	ETF	101.76	101.76	101.76	101.76	100.0
2004-09-01 09:00:00	DIA	ETF	101.79	101.89	101.63	101.68	534000.0
2004-09-01 10:00:00	DIA	ETF	101.68	102.26	101.66	102.02	823100.0
2004-09-01 11:00:00	DIA	ETF	102.01	102.14	101.89	101.93	316800.0
2004-09-01 12:00:00	DIA	ETF	101.98	102.05	101.88	101.98	507400.0
2004-09-01 13:00:00	DIA	ETF	101.99	101.99	101.22	101.84	1107800.0
2004-09-01 14:00:00	DIA	ETF	101.83	101.94	101.65	101.85	247900.0
2004-09-01 15:00:00	DIA	ETF	101.82	101.88	101.6	101.81	514500.0
2004-09-01 16:00:00	DIA	ETF	101.8	101.92	101.78	101.84	140600.0
2004-09-01 09:00:00	TLT	ETF	87.66	87.7	87.54	87.62	205700.0
2004-09-01 10:00:00	TLT	ETF	87.62	87.65	87.15	87.26	448000.0
2004-09-01 11:00:00	TLT	ETF	87.26	87.35	87.24	87.29	175100.0
2004-09-01 12:00:00	TLT	ETF	87.3	87.47	87.21	87.47	178800.0
2004-09-01 13:00:00	TLT	ETF	87.46	87.59	87.38	87.55	141600.0
2004-09-01 14:00:00	TLT	ETF	87.56	87.66	87.44	87.48	51200.0
2004-09-01 15:00:00	TLT	ETF	87.47	87.58	87.42	87.55	80100.0

> showing 50 of 676 rows — these rows as CSV

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