PREVIEW / etf_1hour / 2004-01-30

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-01-30.parquet
  size:    25 KB
  rows:    706

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-01-30 08:00:00	SPY	ETF	113.68	113.69	113.18	113.65	651800.0
2004-01-30 09:00:00	SPY	ETF	113.63	113.63	113.17	113.42	3552000.0
2004-01-30 10:00:00	SPY	ETF	113.45	113.72	113.15	113.4	7413100.0
2004-01-30 11:00:00	SPY	ETF	113.38	113.46	113.1	113.35	2448700.0
2004-01-30 12:00:00	SPY	ETF	113.35	113.56	113.22	113.45	1542600.0
2004-01-30 13:00:00	SPY	ETF	113.45	113.6	113.4	113.47	2623500.0
2004-01-30 14:00:00	SPY	ETF	113.45	113.5	113.09	113.42	3680700.0
2004-01-30 15:00:00	SPY	ETF	113.39	113.64	113.32	113.44	4970500.0
2004-01-30 16:00:00	SPY	ETF	113.44	113.55	113.36	113.52	1868100.0
2004-01-30 17:00:00	SPY	ETF	113.52	113.54	113.45	113.54	17200.0
2004-01-30 18:00:00	SPY	ETF	113.54	113.54	113.54	113.54	900.0
2004-01-30 19:00:00	SPY	ETF	113.49	113.49	113.48	113.48	1000.0
2004-01-30 08:00:00	QQQ	ETF	37.32	37.35	37.18	37.31	456700.0
2004-01-30 09:00:00	QQQ	ETF	37.3	37.36	37.04	37.31	16714500.0
2004-01-30 10:00:00	QQQ	ETF	37.315	37.44	37.17	37.26	17940200.0
2004-01-30 11:00:00	QQQ	ETF	37.26	37.29	37.07	37.22	9072800.0
2004-01-30 12:00:00	QQQ	ETF	37.23	37.254	37.09	37.188	6057600.0
2004-01-30 13:00:00	QQQ	ETF	37.186	37.24	37.11	37.152	3945300.0
2004-01-30 14:00:00	QQQ	ETF	37.15	37.18	36.97	37.11	9910000.0
2004-01-30 15:00:00	QQQ	ETF	37.14	37.22	37.08	37.089	12073200.0
2004-01-30 16:00:00	QQQ	ETF	37.089	37.187	37.008	37.03	3715200.0
2004-01-30 17:00:00	QQQ	ETF	37.022	37.03	36.93	37.03	126600.0
2004-01-30 18:00:00	QQQ	ETF	37.04	37.1	37.0	37.03	21400.0
2004-01-30 19:00:00	QQQ	ETF	37.02	37.04	37.01	37.01	3100.0
2004-01-30 20:00:00	QQQ	ETF	37.05	37.05	37.05	37.05	300.0
2004-01-30 08:00:00	IWM	ETF	57.85	57.85	57.85	57.85	200.0
2004-01-30 09:00:00	IWM	ETF	57.7	57.965	57.45	57.925	1127800.0
2004-01-30 10:00:00	IWM	ETF	57.93	58.19	57.805	57.88	2705000.0
2004-01-30 11:00:00	IWM	ETF	57.885	57.915	57.67	57.85	739600.0
2004-01-30 12:00:00	IWM	ETF	57.85	57.89	57.7	57.735	991200.0
2004-01-30 13:00:00	IWM	ETF	57.74	57.755	57.555	57.665	468200.0
2004-01-30 14:00:00	IWM	ETF	57.665	57.825	57.5	57.755	1037800.0
2004-01-30 15:00:00	IWM	ETF	57.755	58.0	57.67	57.7	841200.0
2004-01-30 16:00:00	IWM	ETF	57.705	57.99	57.635	57.99	493200.0
2004-01-30 17:00:00	IWM	ETF	57.86	57.86	57.86	57.86	52000.0
2004-01-30 08:00:00	DIA	ETF	105.07	105.1	104.85	105.02	33700.0
2004-01-30 09:00:00	DIA	ETF	105.0	105.0	104.6	104.83	1124200.0
2004-01-30 10:00:00	DIA	ETF	104.86	105.09	104.57	104.84	2247800.0
2004-01-30 11:00:00	DIA	ETF	104.85	104.86	104.62	104.78	772700.0
2004-01-30 12:00:00	DIA	ETF	104.77	104.96	104.71	104.841	646700.0
2004-01-30 13:00:00	DIA	ETF	104.87	105.04	104.83	104.97	266300.0
2004-01-30 14:00:00	DIA	ETF	104.97	105.0	104.7	104.9	650000.0
2004-01-30 15:00:00	DIA	ETF	104.9	105.23	104.87	105.03	1503400.0
2004-01-30 16:00:00	DIA	ETF	105.05	105.19	104.99	105.07	572400.0
2004-01-30 17:00:00	DIA	ETF	105.1	105.1	105.05	105.07	1200.0
2004-01-30 18:00:00	DIA	ETF	105.07	105.1	105.07	105.1	1200.0
2004-01-30 09:00:00	TLT	ETF	86.9	87.05	86.86	86.86	50700.0
2004-01-30 10:00:00	TLT	ETF	86.74	86.97	86.6	86.76	80200.0
2004-01-30 11:00:00	TLT	ETF	86.8	86.95	86.69	86.87	13800.0
2004-01-30 12:00:00	TLT	ETF	86.87	87.12	86.85	87.0	151000.0

> showing 50 of 706 rows — these rows as CSV

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