PREVIEW / etf_1hour / 2004-02-03

all etf 1-hour files

  file:    by_date/etf_1hour/2004/2004-02-03.parquet
  size:    24 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-03 08:00:00	SPY	ETF	113.79	113.92	113.78	113.78	14600.0
2004-02-03 09:00:00	SPY	ETF	113.78	113.95	113.44	113.83	4152100.0
2004-02-03 10:00:00	SPY	ETF	113.84	114.02	113.5	113.9	4731300.0
2004-02-03 11:00:00	SPY	ETF	113.91	114.0	113.64	113.73	2657900.0
2004-02-03 12:00:00	SPY	ETF	113.72	114.1	113.68	114.01	1634000.0
2004-02-03 13:00:00	SPY	ETF	114.01	114.14	113.87	113.98	1251600.0
2004-02-03 14:00:00	SPY	ETF	113.97	114.07	113.57	113.81	3707000.0
2004-02-03 15:00:00	SPY	ETF	113.79	114.0	113.76	113.96	3314500.0
2004-02-03 16:00:00	SPY	ETF	113.95	114.03	113.46	113.52	1965500.0
2004-02-03 17:00:00	SPY	ETF	113.52	113.58	113.35	113.41	117300.0
2004-02-03 18:00:00	SPY	ETF	113.41	113.42	113.37	113.38	31400.0
2004-02-03 19:00:00	SPY	ETF	113.39	113.41	113.38	113.41	2900.0
2004-02-03 08:00:00	QQQ	ETF	36.91	36.98	36.91	36.92	55000.0
2004-02-03 09:00:00	QQQ	ETF	36.92	37.12	36.84	37.089	11794600.0
2004-02-03 10:00:00	QQQ	ETF	37.09	37.21	36.95	37.13	12899200.0
2004-02-03 11:00:00	QQQ	ETF	37.137	37.18	37.0	37.04	6920000.0
2004-02-03 12:00:00	QQQ	ETF	37.039	37.19	37.01	37.163	4552100.0
2004-02-03 13:00:00	QQQ	ETF	37.17	37.24	37.09	37.14	5552700.0
2004-02-03 14:00:00	QQQ	ETF	37.137	37.18	36.9	36.99	8615700.0
2004-02-03 15:00:00	QQQ	ETF	37.001	37.12	36.98	37.06	10788400.0
2004-02-03 16:00:00	QQQ	ETF	37.05	37.09	36.74	36.77	7021400.0
2004-02-03 17:00:00	QQQ	ETF	36.77	36.836	36.606	36.68	3206500.0
2004-02-03 18:00:00	QQQ	ETF	36.68	36.71	36.68	36.71	222300.0
2004-02-03 19:00:00	QQQ	ETF	36.72	36.73	36.7	36.72	36200.0
2004-02-03 09:00:00	IWM	ETF	57.8	57.91	57.56	57.815	593600.0
2004-02-03 10:00:00	IWM	ETF	57.825	57.905	57.625	57.8095	623200.0
2004-02-03 11:00:00	IWM	ETF	57.805	57.83	57.685	57.725	523400.0
2004-02-03 12:00:00	IWM	ETF	57.695	57.885	57.67	57.855	347000.0
2004-02-03 13:00:00	IWM	ETF	57.845	57.9095	57.779	57.815	192400.0
2004-02-03 14:00:00	IWM	ETF	57.8	57.84	57.555	57.655	670200.0
2004-02-03 15:00:00	IWM	ETF	57.66	57.81	57.6	57.725	1283600.0
2004-02-03 16:00:00	IWM	ETF	57.74	57.74	57.415	57.415	289600.0
2004-02-03 17:00:00	IWM	ETF	57.35	57.35	57.285	57.285	12800.0
2004-02-03 08:00:00	DIA	ETF	105.08	105.11	105.08	105.1	1400.0
2004-02-03 09:00:00	DIA	ETF	104.99	105.11	104.72	105.0	506100.0
2004-02-03 10:00:00	DIA	ETF	105.0	105.27	104.85	105.22	810300.0
2004-02-03 11:00:00	DIA	ETF	105.22	105.35	104.99	105.07	336100.0
2004-02-03 12:00:00	DIA	ETF	105.08	105.39	105.04	105.32	294600.0
2004-02-03 13:00:00	DIA	ETF	105.34	105.45	105.22	105.3	576000.0
2004-02-03 14:00:00	DIA	ETF	105.28	105.37	105.0	105.22	415800.0
2004-02-03 15:00:00	DIA	ETF	105.198	105.33	105.07	105.23	662800.0
2004-02-03 16:00:00	DIA	ETF	105.22	105.27	104.87	104.87	184700.0
2004-02-03 17:00:00	DIA	ETF	104.87	104.88	104.75	104.75	11300.0
2004-02-03 18:00:00	DIA	ETF	104.75	104.85	104.75	104.82	5900.0
2004-02-03 19:00:00	DIA	ETF	104.85	104.88	104.85	104.85	2000.0
2004-02-03 09:00:00	TLT	ETF	86.92	86.99	86.88	86.89	82000.0
2004-02-03 10:00:00	TLT	ETF	86.86	86.87	86.67	86.73	147500.0
2004-02-03 11:00:00	TLT	ETF	86.73	86.81	86.62	86.71	10500.0
2004-02-03 12:00:00	TLT	ETF	86.72	86.8	86.6	86.75	10300.0
2004-02-03 13:00:00	TLT	ETF	86.77	86.9	86.73	86.87	40300.0

> showing 50 of 696 rows — these rows as CSV

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