PREVIEW / etf_1hour / 2004-02-05

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-02-05.parquet
  size:    25 KB
  rows:    696

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-02-05 08:00:00	SPY	ETF	113.22	113.27	113.06	113.24	253000.0
2004-02-05 09:00:00	SPY	ETF	113.15	113.33	112.97	113.05	4354400.0
2004-02-05 10:00:00	SPY	ETF	113.07	113.26	112.93	112.97	4042700.0
2004-02-05 11:00:00	SPY	ETF	112.98	113.08	112.78	112.96	4604700.0
2004-02-05 12:00:00	SPY	ETF	112.96	113.07	112.84	113.07	1326500.0
2004-02-05 13:00:00	SPY	ETF	113.06	113.54	112.99	113.32	7021900.0
2004-02-05 14:00:00	SPY	ETF	113.32	113.49	112.98	113.02	4043200.0
2004-02-05 15:00:00	SPY	ETF	113.02	113.47	113.0	113.3	5935300.0
2004-02-05 16:00:00	SPY	ETF	113.3	113.35	113.13	113.16	1852600.0
2004-02-05 17:00:00	SPY	ETF	113.16	113.17	113.1	113.12	37500.0
2004-02-05 18:00:00	SPY	ETF	113.1	113.17	113.1	113.17	6500.0
2004-02-05 19:00:00	SPY	ETF	113.14	113.14	113.1	113.1	7400.0
2004-02-05 08:00:00	QQQ	ETF	36.55	36.56	36.48	36.5	311400.0
2004-02-05 09:00:00	QQQ	ETF	36.5	36.63	36.47	36.54	12657700.0
2004-02-05 10:00:00	QQQ	ETF	36.53	36.64	36.412	36.42	13775700.0
2004-02-05 11:00:00	QQQ	ETF	36.43	36.49	36.33	36.42	14082200.0
2004-02-05 12:00:00	QQQ	ETF	36.43	36.53	36.38	36.5	6056300.0
2004-02-05 13:00:00	QQQ	ETF	36.509	36.69	36.49	36.554	12472300.0
2004-02-05 14:00:00	QQQ	ETF	36.55	36.66	36.45	36.49	7879300.0
2004-02-05 15:00:00	QQQ	ETF	36.49	36.63	36.46	36.484	9690600.0
2004-02-05 16:00:00	QQQ	ETF	36.5	36.51	36.43	36.49	3280100.0
2004-02-05 17:00:00	QQQ	ETF	36.47	36.48	36.44	36.47	215200.0
2004-02-05 18:00:00	QQQ	ETF	36.47	36.49	36.46	36.48	64800.0
2004-02-05 19:00:00	QQQ	ETF	36.48	36.49	36.46	36.46	11700.0
2004-02-05 09:00:00	IWM	ETF	56.5675	56.785	56.495	56.58	1471200.0
2004-02-05 10:00:00	IWM	ETF	56.595	56.875	56.55	56.61	1695600.0
2004-02-05 11:00:00	IWM	ETF	56.605	56.625	56.295	56.5	1259400.0
2004-02-05 12:00:00	IWM	ETF	56.495	56.555	56.3725	56.465	454000.0
2004-02-05 13:00:00	IWM	ETF	56.495	56.935	56.495	56.755	1217200.0
2004-02-05 14:00:00	IWM	ETF	56.755	56.9	56.5765	56.605	655000.0
2004-02-05 15:00:00	IWM	ETF	56.625	56.75	56.57	56.68	1261000.0
2004-02-05 16:00:00	IWM	ETF	56.695	57.11	56.265	56.65	942200.0
2004-02-05 17:00:00	IWM	ETF	56.719	56.719	56.719	56.719	200.0
2004-02-05 18:00:00	IWM	ETF	56.6715	56.6715	56.6715	56.6715	2400.0
2004-02-05 08:00:00	DIA	ETF	105.12	105.13	104.94	105.0	7900.0
2004-02-05 09:00:00	DIA	ETF	105.0	105.13	104.68	104.87	502600.0
2004-02-05 10:00:00	DIA	ETF	104.87	105.12	104.75	104.87	400700.0
2004-02-05 11:00:00	DIA	ETF	104.89	105.06	104.78	104.97	889200.0
2004-02-05 12:00:00	DIA	ETF	104.97	105.02	104.85	105.001	371200.0
2004-02-05 13:00:00	DIA	ETF	104.99	105.44	104.98	105.22	1576400.0
2004-02-05 14:00:00	DIA	ETF	105.26	105.39	104.91	104.95	646900.0
2004-02-05 15:00:00	DIA	ETF	104.96	105.324	104.95	105.14	700100.0
2004-02-05 16:00:00	DIA	ETF	105.14	105.19	105.05	105.1	72800.0
2004-02-05 17:00:00	DIA	ETF	105.1	105.17	105.1	105.17	1000.0
2004-02-05 18:00:00	DIA	ETF	105.12	105.14	105.12	105.14	2800.0
2004-02-05 19:00:00	DIA	ETF	105.11	105.11	105.11	105.11	400.0
2004-02-05 09:00:00	TLT	ETF	86.84	86.93	86.77	86.93	30900.0
2004-02-05 10:00:00	TLT	ETF	86.92	86.93	86.81	86.85	20900.0
2004-02-05 11:00:00	TLT	ETF	86.86	87.01	86.86	87.01	135000.0
2004-02-05 12:00:00	TLT	ETF	87.07	87.08	86.8	86.97	91700.0

> showing 50 of 696 rows — these rows as CSV

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