PREVIEW / etf_1hour / 2003-09-03

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-09-03.parquet
  size:    17 KB
  rows:    445

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-09-03 08:00:00	SPY	ETF	103.12	103.21	103.06	103.11	23400.0
2003-09-03 09:00:00	SPY	ETF	103.1	103.19	102.78	103.08	8220000.0
2003-09-03 10:00:00	SPY	ETF	103.08	103.422	102.92	103.37	7261400.0
2003-09-03 11:00:00	SPY	ETF	103.39	103.47	102.95	103.14	5972500.0
2003-09-03 12:00:00	SPY	ETF	103.12	103.37	103.05	103.29	2947500.0
2003-09-03 13:00:00	SPY	ETF	103.28	103.44	103.12	103.17	2757900.0
2003-09-03 14:00:00	SPY	ETF	103.16	103.56	103.04	103.28	4467700.0
2003-09-03 15:00:00	SPY	ETF	103.29	103.37	102.88	103.19	5168600.0
2003-09-03 16:00:00	SPY	ETF	103.2	103.39	102.7825	103.28	4324100.0
2003-09-03 17:00:00	SPY	ETF	103.28	103.3	103.24	103.24	8100.0
2003-09-03 18:00:00	SPY	ETF	103.276	103.31	103.24	103.31	10900.0
2003-09-03 19:00:00	SPY	ETF	103.26	103.31	103.26	103.28	2200.0
2003-09-03 08:00:00	QQQ	ETF	34.05	34.1	34.02	34.03	164800.0
2003-09-03 09:00:00	QQQ	ETF	34.04	34.17	33.96	34.05	12966600.0
2003-09-03 10:00:00	QQQ	ETF	34.05	34.2	33.97	34.09	16024400.0
2003-09-03 11:00:00	QQQ	ETF	34.09	34.16	33.86	33.91	10830800.0
2003-09-03 12:00:00	QQQ	ETF	33.91	34.04	33.89	33.994	5393300.0
2003-09-03 13:00:00	QQQ	ETF	34.0	34.1	33.93	33.98	3790700.0
2003-09-03 14:00:00	QQQ	ETF	33.976	34.08	33.83	33.92	8917400.0
2003-09-03 15:00:00	QQQ	ETF	33.92	33.97	33.65	33.789	12985900.0
2003-09-03 16:00:00	QQQ	ETF	33.789	33.9	33.76	33.85	5513200.0
2003-09-03 17:00:00	QQQ	ETF	33.85	33.86	33.85	33.86	19600.0
2003-09-03 18:00:00	QQQ	ETF	33.86	33.88	33.84	33.88	19700.0
2003-09-03 19:00:00	QQQ	ETF	33.86	33.88	33.85	33.85	10100.0
2003-09-03 08:00:00	IWM	ETF	50.89	50.89	50.89	50.89	1000.0
2003-09-03 09:00:00	IWM	ETF	50.89	51.0	50.74	50.94	1619000.0
2003-09-03 10:00:00	IWM	ETF	50.95	51.15	50.93	51.075	549600.0
2003-09-03 11:00:00	IWM	ETF	51.085	51.115	50.98	51.065	739400.0
2003-09-03 12:00:00	IWM	ETF	51.07	51.155	51.045	51.07	305000.0
2003-09-03 13:00:00	IWM	ETF	51.085	51.15	51.005	51.005	540400.0
2003-09-03 14:00:00	IWM	ETF	51.005	51.175	51.005	51.095	702800.0
2003-09-03 15:00:00	IWM	ETF	51.11	51.11	50.86	51.07	701600.0
2003-09-03 16:00:00	IWM	ETF	51.05	51.1	50.965	51.0	90600.0
2003-09-03 08:00:00	DIA	ETF	95.72	95.77	95.67	95.71	10500.0
2003-09-03 09:00:00	DIA	ETF	95.8	95.8	95.36	95.65	724300.0
2003-09-03 10:00:00	DIA	ETF	95.68	95.94	95.48	95.88	1009400.0
2003-09-03 11:00:00	DIA	ETF	95.9	95.97	95.6	95.74	522900.0
2003-09-03 12:00:00	DIA	ETF	95.69	95.96	95.68	95.93	341200.0
2003-09-03 13:00:00	DIA	ETF	95.95	96.1	95.77	95.81	290300.0
2003-09-03 14:00:00	DIA	ETF	95.81	96.23	95.79	96.06	876500.0
2003-09-03 15:00:00	DIA	ETF	96.02	96.1	95.65	95.91	1030000.0
2003-09-03 16:00:00	DIA	ETF	95.93	96.05	95.91	96.02	102500.0
2003-09-03 17:00:00	DIA	ETF	96.0	96.05	95.9	95.9	2900.0
2003-09-03 18:00:00	DIA	ETF	95.9	95.9	95.9	95.9	400.0
2003-09-03 19:00:00	DIA	ETF	96.01	96.01	96.01	96.01	300.0
2003-09-03 09:00:00	TLT	ETF	82.484	82.484	82.0	82.13	78500.0
2003-09-03 10:00:00	TLT	ETF	82.13	82.31	82.09	82.21	101900.0
2003-09-03 11:00:00	TLT	ETF	82.27	82.48	82.19	82.46	25000.0
2003-09-03 12:00:00	TLT	ETF	82.36	82.4	82.14	82.26	41800.0
2003-09-03 13:00:00	TLT	ETF	82.26	82.28	82.05	82.11	20200.0

> showing 50 of 445 rows — these rows as CSV

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