PREVIEW / etf_1hour / 2003-04-02

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-04-02.parquet
  size:    16 KB
  rows:    387

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
2003-04-02 08:00:00	SPY	ETF	87.26	87.49	87.19	87.42	147400.0
2003-04-02 09:00:00	SPY	ETF	87.42	87.95	87.4	87.74	7907300.0
2003-04-02 10:00:00	SPY	ETF	87.75	88.36	87.68	88.27	8823500.0
2003-04-02 11:00:00	SPY	ETF	88.25	88.55	88.22	88.36	7472400.0
2003-04-02 12:00:00	SPY	ETF	88.36	88.68	88.25	88.38	3706700.0
2003-04-02 13:00:00	SPY	ETF	88.39	88.47	88.18	88.41	4045000.0
2003-04-02 14:00:00	SPY	ETF	88.42	88.65	88.28	88.6	3553800.0
2003-04-02 15:00:00	SPY	ETF	88.59	88.77	88.16	88.39	6169000.0
2003-04-02 16:00:00	SPY	ETF	88.37	88.46	87.98	88.18	2541600.0
2003-04-02 17:00:00	SPY	ETF	88.16	88.24	88.13	88.17	60200.0
2003-04-02 18:00:00	SPY	ETF	88.2	88.28	88.15	88.24	25700.0
2003-04-02 19:00:00	SPY	ETF	88.3	88.3	88.14	88.14	7200.0
2003-04-02 08:00:00	QQQ	ETF	25.91	25.98	25.9	25.94	254400.0
2003-04-02 09:00:00	QQQ	ETF	25.94	26.28	25.94	26.24	16076900.0
2003-04-02 10:00:00	QQQ	ETF	26.24	26.48	26.14	26.42	17151300.0
2003-04-02 11:00:00	QQQ	ETF	26.42	26.54	26.39	26.43	7759900.0
2003-04-02 12:00:00	QQQ	ETF	26.43	26.54	26.38	26.45	4526800.0
2003-04-02 13:00:00	QQQ	ETF	26.45	26.48	26.33	26.43	5525100.0
2003-04-02 14:00:00	QQQ	ETF	26.43	26.53	26.36	26.5	5094000.0
2003-04-02 15:00:00	QQQ	ETF	26.5	26.56	26.32	26.44	10975600.0
2003-04-02 16:00:00	QQQ	ETF	26.44	26.49	26.35	26.43	2699900.0
2003-04-02 17:00:00	QQQ	ETF	26.44	26.46	26.42	26.44	98700.0
2003-04-02 18:00:00	QQQ	ETF	26.44	26.48	26.42	26.47	86700.0
2003-04-02 19:00:00	QQQ	ETF	26.47	26.52	26.47	26.47	66300.0
2003-04-02 09:00:00	IWM	ETF	37.235	37.235	37.065	37.16	585400.0
2003-04-02 10:00:00	IWM	ETF	37.155	37.445	37.15	37.415	390200.0
2003-04-02 11:00:00	IWM	ETF	37.415	37.485	37.39	37.44	147200.0
2003-04-02 12:00:00	IWM	ETF	37.425	37.485	37.38	37.425	179400.0
2003-04-02 13:00:00	IWM	ETF	37.395	37.42	37.34	37.4	71000.0
2003-04-02 14:00:00	IWM	ETF	37.425	37.525	37.37	37.525	323800.0
2003-04-02 15:00:00	IWM	ETF	37.505	37.6	37.405	37.455	734000.0
2003-04-02 16:00:00	IWM	ETF	37.47	37.485	37.135	37.36	275600.0
2003-04-02 17:00:00	IWM	ETF	37.43	37.605	37.42	37.605	3400.0
2003-04-02 08:00:00	DIA	ETF	81.82	82.2	81.79	82.06	26000.0
2003-04-02 09:00:00	DIA	ETF	82.1	82.59	82.1	82.46	2988800.0
2003-04-02 10:00:00	DIA	ETF	82.39	83.04	82.38	82.97	1885500.0
2003-04-02 11:00:00	DIA	ETF	82.96	83.23	82.91	83.07	1503500.0
2003-04-02 12:00:00	DIA	ETF	83.07	83.31	82.92	83.07	796600.0
2003-04-02 13:00:00	DIA	ETF	83.1	83.14	82.87	83.09	942000.0
2003-04-02 14:00:00	DIA	ETF	83.1	83.26	82.96	83.21	488100.0
2003-04-02 15:00:00	DIA	ETF	83.22	83.34	82.85	82.99	1927100.0
2003-04-02 16:00:00	DIA	ETF	83.0	83.08	82.72	82.89	271500.0
2003-04-02 17:00:00	DIA	ETF	82.84	82.85	82.8	82.83	10300.0
2003-04-02 18:00:00	DIA	ETF	82.8	82.9	82.8	82.9	2300.0
2003-04-02 19:00:00	DIA	ETF	82.93	83.0	82.83	82.83	3900.0
2003-04-02 09:00:00	TLT	ETF	87.65	87.68	87.5	87.58	113900.0
2003-04-02 10:00:00	TLT	ETF	87.6	87.7	87.41	87.41	70100.0
2003-04-02 11:00:00	TLT	ETF	87.45	87.45	87.28	87.35	9300.0
2003-04-02 12:00:00	TLT	ETF	87.36	87.49	87.3	87.42	55900.0
2003-04-02 13:00:00	TLT	ETF	87.38	87.4	87.36	87.38	1500.0

> showing 50 of 387 rows — these rows as CSV

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