PREVIEW / etf_1hour / 2003-05-02

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-05-02.parquet
  size:    17 KB
  rows:    410

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-05-02 08:00:00	SPY	ETF	91.94	92.21	91.82	91.88	102600.0
2003-05-02 09:00:00	SPY	ETF	91.95	92.33	91.49	92.29	6082700.0
2003-05-02 10:00:00	SPY	ETF	92.29	92.75	92.08	92.56	10571400.0
2003-05-02 11:00:00	SPY	ETF	92.53	93.29	92.53	93.17	8400200.0
2003-05-02 12:00:00	SPY	ETF	93.16	93.25	92.88	92.91	2990200.0
2003-05-02 13:00:00	SPY	ETF	92.88	93.21	92.83	93.18	2968200.0
2003-05-02 14:00:00	SPY	ETF	93.17	93.47	93.07	93.29	5008400.0
2003-05-02 15:00:00	SPY	ETF	93.33	93.45	93.09	93.34	4921500.0
2003-05-02 16:00:00	SPY	ETF	93.3	93.37	93.12	93.26	2986100.0
2003-05-02 17:00:00	SPY	ETF	93.3	93.45	93.1	93.33	92700.0
2003-05-02 18:00:00	SPY	ETF	93.29	93.3	93.28	93.28	6900.0
2003-05-02 19:00:00	SPY	ETF	93.26	93.37	93.26	93.27	1600.0
2003-05-02 08:00:00	QQQ	ETF	27.74	27.82	27.66	27.72	191100.0
2003-05-02 09:00:00	QQQ	ETF	27.71	27.91	27.57	27.9	8194100.0
2003-05-02 10:00:00	QQQ	ETF	27.91	28.05	27.81	28.0	16171600.0
2003-05-02 11:00:00	QQQ	ETF	28.0	28.26	27.9	28.18	15234300.0
2003-05-02 12:00:00	QQQ	ETF	28.16	28.24	28.07	28.07	7306900.0
2003-05-02 13:00:00	QQQ	ETF	28.07	28.18	28.0	28.16	7153300.0
2003-05-02 14:00:00	QQQ	ETF	28.17	28.28	28.12	28.21	9368600.0
2003-05-02 15:00:00	QQQ	ETF	28.21	28.27	28.11	28.27	12552100.0
2003-05-02 16:00:00	QQQ	ETF	28.28	28.31	28.23	28.3	1635100.0
2003-05-02 17:00:00	QQQ	ETF	28.3	28.4	28.3	28.32	40200.0
2003-05-02 18:00:00	QQQ	ETF	28.32	28.35	28.32	28.33	32400.0
2003-05-02 19:00:00	QQQ	ETF	28.33	28.4	28.3	28.35	20100.0
2003-05-02 09:00:00	IWM	ETF	39.75	40.275	39.75	40.27	332600.0
2003-05-02 10:00:00	IWM	ETF	40.28	40.425	40.22	40.29	643400.0
2003-05-02 11:00:00	IWM	ETF	40.31	40.485	40.3	40.415	350200.0
2003-05-02 12:00:00	IWM	ETF	40.44	40.6	40.44	40.48	369000.0
2003-05-02 13:00:00	IWM	ETF	40.48	40.545	40.45	40.545	219800.0
2003-05-02 14:00:00	IWM	ETF	40.54	40.625	40.45	40.59	292800.0
2003-05-02 15:00:00	IWM	ETF	40.595	40.675	40.525	40.645	901200.0
2003-05-02 16:00:00	IWM	ETF	40.65	40.65	40.555	40.65	90800.0
2003-05-02 08:00:00	DIA	ETF	84.65	84.95	84.53	84.6	25900.0
2003-05-02 09:00:00	DIA	ETF	84.63	84.93	84.21	84.86	1321800.0
2003-05-02 10:00:00	DIA	ETF	84.85	85.36	84.7	85.22	2487300.0
2003-05-02 11:00:00	DIA	ETF	85.23	85.86	85.18	85.74	1752100.0
2003-05-02 12:00:00	DIA	ETF	85.75	85.82	85.45	85.49	637100.0
2003-05-02 13:00:00	DIA	ETF	85.49	85.8	85.44	85.74	644300.0
2003-05-02 14:00:00	DIA	ETF	85.75	85.99	85.65	85.91	768900.0
2003-05-02 15:00:00	DIA	ETF	85.94	86.03	85.61	85.91	2074800.0
2003-05-02 16:00:00	DIA	ETF	85.92	85.97	85.78	85.85	170500.0
2003-05-02 17:00:00	DIA	ETF	85.87	85.93	85.81	85.81	7100.0
2003-05-02 18:00:00	DIA	ETF	85.81	85.93	85.81	85.93	1500.0
2003-05-02 09:00:00	TLT	ETF	89.06	89.07	88.91	88.98	12700.0
2003-05-02 10:00:00	TLT	ETF	88.97	88.97	88.81	88.86	32700.0
2003-05-02 11:00:00	TLT	ETF	88.81	88.81	88.61	88.61	10100.0
2003-05-02 12:00:00	TLT	ETF	88.6	88.6	88.5	88.6	68000.0
2003-05-02 13:00:00	TLT	ETF	88.62	88.62	88.35	88.38	36800.0
2003-05-02 14:00:00	TLT	ETF	88.3	88.44	88.27	88.41	36000.0
2003-05-02 15:00:00	TLT	ETF	88.42	88.49	88.32	88.32	28700.0

> showing 50 of 410 rows — these rows as CSV

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