PREVIEW / etf_1hour / 2004-04-26

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-04-26.parquet
  size:    25 KB
  rows:    683

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-04-26 08:00:00	SPY	ETF	114.46	114.51	114.42	114.45	43200.0
2004-04-26 09:00:00	SPY	ETF	114.45	114.94	114.43	114.85	3672300.0
2004-04-26 10:00:00	SPY	ETF	114.85	114.89	114.02	114.17	5928600.0
2004-04-26 11:00:00	SPY	ETF	114.18	114.43	114.17	114.36	2187400.0
2004-04-26 12:00:00	SPY	ETF	114.36	114.45	114.15	114.22	1653200.0
2004-04-26 13:00:00	SPY	ETF	114.23	114.4	114.15	114.2	1313200.0
2004-04-26 14:00:00	SPY	ETF	114.18	114.23	113.75	113.97	5107400.0
2004-04-26 15:00:00	SPY	ETF	113.98	114.0	113.6	113.92	6964300.0
2004-04-26 16:00:00	SPY	ETF	113.91	114.52	113.9	114.3	1564600.0
2004-04-26 17:00:00	SPY	ETF	114.3	114.33	114.28	114.3	5800.0
2004-04-26 18:00:00	SPY	ETF	114.28	114.28	114.19	114.19	50000.0
2004-04-26 19:00:00	SPY	ETF	114.22	114.23	114.22	114.23	2200.0
2004-04-26 08:00:00	QQQ	ETF	37.17	37.17	37.14	37.17	64400.0
2004-04-26 09:00:00	QQQ	ETF	37.18	37.29	37.13	37.25	6666900.0
2004-04-26 10:00:00	QQQ	ETF	37.26	37.27	36.83	36.932	12573300.0
2004-04-26 11:00:00	QQQ	ETF	36.933	37.07	36.92	36.992	7811000.0
2004-04-26 12:00:00	QQQ	ETF	36.9901	37.04	36.89	36.93	6184600.0
2004-04-26 13:00:00	QQQ	ETF	36.93	37.0	36.9	36.91	4280100.0
2004-04-26 14:00:00	QQQ	ETF	36.9	36.91	36.679	36.78	12260100.0
2004-04-26 15:00:00	QQQ	ETF	36.79	36.84	36.65	36.78	12704300.0
2004-04-26 16:00:00	QQQ	ETF	36.771	36.99	36.76	36.97	2117000.0
2004-04-26 17:00:00	QQQ	ETF	36.96	36.99	36.95	36.95	171400.0
2004-04-26 18:00:00	QQQ	ETF	36.95	36.98	36.93	36.94	59500.0
2004-04-26 19:00:00	QQQ	ETF	36.93	36.96	36.93	36.96	3400.0
2004-04-26 08:00:00	IWM	ETF	58.9	58.9	58.79	58.79	12000.0
2004-04-26 09:00:00	IWM	ETF	58.9	59.495	58.9	59.48	1440400.0
2004-04-26 10:00:00	IWM	ETF	59.47	59.53	58.8	58.895	1490400.0
2004-04-26 11:00:00	IWM	ETF	58.915	59.25	58.915	59.165	414000.0
2004-04-26 12:00:00	IWM	ETF	59.18	59.23	59.02	59.085	618600.0
2004-04-26 13:00:00	IWM	ETF	59.095	59.18	59.04	59.075	224200.0
2004-04-26 14:00:00	IWM	ETF	59.05	59.065	58.6	58.82	1196000.0
2004-04-26 15:00:00	IWM	ETF	58.805	58.875	58.595	58.66	3354000.0
2004-04-26 16:00:00	IWM	ETF	58.66	59.02	58.65	59.0	368200.0
2004-04-26 17:00:00	IWM	ETF	58.97	58.97	58.97	58.97	4000.0
2004-04-26 08:00:00	DIA	ETF	104.95	104.98	104.9	104.96	1800.0
2004-04-26 09:00:00	DIA	ETF	104.95	105.34	104.93	105.27	542200.0
2004-04-26 10:00:00	DIA	ETF	105.27	105.3	104.66	104.77	543000.0
2004-04-26 11:00:00	DIA	ETF	104.75	105.01	104.75	104.97	288900.0
2004-04-26 12:00:00	DIA	ETF	104.97	105.03	104.84	104.89	174600.0
2004-04-26 13:00:00	DIA	ETF	104.88	105.07	104.87	104.91	139900.0
2004-04-26 14:00:00	DIA	ETF	104.9	104.9	104.49	104.69	546500.0
2004-04-26 15:00:00	DIA	ETF	104.68	104.7	104.36	104.66	693100.0
2004-04-26 16:00:00	DIA	ETF	104.68	105.01	104.67	105.01	67800.0
2004-04-26 18:00:00	DIA	ETF	104.86	104.87	104.86	104.87	300.0
2004-04-26 09:00:00	TLT	ETF	84.09	84.24	84.08	84.12	34800.0
2004-04-26 10:00:00	TLT	ETF	84.1	84.25	84.1	84.16	25400.0
2004-04-26 11:00:00	TLT	ETF	84.2	84.25	84.06	84.2	20200.0
2004-04-26 12:00:00	TLT	ETF	84.22	84.22	84.14	84.15	20700.0
2004-04-26 13:00:00	TLT	ETF	84.1	84.22	84.06	84.22	6300.0
2004-04-26 14:00:00	TLT	ETF	84.22	84.29	84.19	84.2	13200.0

> showing 50 of 683 rows — these rows as CSV

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