PREVIEW / etf_1hour / 2003-08-05

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-08-05.parquet
  size:    17 KB
  rows:    418

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-08-05 08:00:00	SPY	ETF	98.48	98.75	98.48	98.66	11000.0
2003-08-05 09:00:00	SPY	ETF	98.66	98.68	98.23	98.34	4180400.0
2003-08-05 10:00:00	SPY	ETF	98.35	98.76	97.701	98.1	10100400.0
2003-08-05 11:00:00	SPY	ETF	98.09	98.33	97.83	98.22	3144100.0
2003-08-05 12:00:00	SPY	ETF	98.21	98.46	98.04	98.15	2174800.0
2003-08-05 13:00:00	SPY	ETF	98.12	98.21	97.81	97.89	3067900.0
2003-08-05 14:00:00	SPY	ETF	97.88	98.05	97.57	97.75	8234700.0
2003-08-05 15:00:00	SPY	ETF	97.75	97.8	96.84	96.85	16144900.0
2003-08-05 16:00:00	SPY	ETF	96.85	98.6868	96.34	96.41	5936300.0
2003-08-05 17:00:00	SPY	ETF	96.4	96.91	96.37	96.43	678800.0
2003-08-05 18:00:00	SPY	ETF	96.42	96.47	96.4	96.47	28000.0
2003-08-05 19:00:00	SPY	ETF	96.47	96.51	96.43	96.48	11600.0
2003-08-05 08:00:00	QQQ	ETF	31.44	31.49	31.4	31.47	48000.0
2003-08-05 09:00:00	QQQ	ETF	31.46	31.48	31.21	31.242	8358700.0
2003-08-05 10:00:00	QQQ	ETF	31.24	31.46	30.995	31.141	18845600.0
2003-08-05 11:00:00	QQQ	ETF	31.148	31.2	31.01	31.11	5951900.0
2003-08-05 12:00:00	QQQ	ETF	31.13	31.2	31.05	31.11	3766500.0
2003-08-05 13:00:00	QQQ	ETF	31.121	31.14	30.9	30.97	6587500.0
2003-08-05 14:00:00	QQQ	ETF	30.97	31.036	30.82	30.86	12112900.0
2003-08-05 15:00:00	QQQ	ETF	30.868	30.89	30.48	30.55	26947600.0
2003-08-05 16:00:00	QQQ	ETF	30.53	30.57	30.1	30.21	10276800.0
2003-08-05 17:00:00	QQQ	ETF	30.2	31.51	30.11	30.17	4706900.0
2003-08-05 18:00:00	QQQ	ETF	30.17	30.21	30.14	30.18	47400.0
2003-08-05 19:00:00	QQQ	ETF	30.18	30.21	30.18	30.2	21000.0
2003-08-05 09:00:00	IWM	ETF	46.3	46.325	46.09	46.13	401600.0
2003-08-05 10:00:00	IWM	ETF	46.29	46.31	45.975	46.115	712000.0
2003-08-05 11:00:00	IWM	ETF	46.11	46.125	45.99	46.075	532600.0
2003-08-05 12:00:00	IWM	ETF	46.05	46.155	46.05	46.065	205800.0
2003-08-05 13:00:00	IWM	ETF	46.07	46.1	45.895	45.96	383000.0
2003-08-05 14:00:00	IWM	ETF	45.945	45.975	45.8	45.82	303200.0
2003-08-05 15:00:00	IWM	ETF	45.83	45.875	45.475	45.49	2943400.0
2003-08-05 16:00:00	IWM	ETF	45.48	45.48	45.35	45.4	131800.0
2003-08-05 08:00:00	DIA	ETF	91.79	91.93	91.79	91.93	5600.0
2003-08-05 09:00:00	DIA	ETF	91.92	91.97	91.54	91.65	548500.0
2003-08-05 10:00:00	DIA	ETF	91.65	92.05	91.16	91.48	1326400.0
2003-08-05 11:00:00	DIA	ETF	91.44	91.73	91.28	91.64	494000.0
2003-08-05 12:00:00	DIA	ETF	91.65	91.81	91.51	91.58	282300.0
2003-08-05 13:00:00	DIA	ETF	91.57	91.6	91.3	91.38	417700.0
2003-08-05 14:00:00	DIA	ETF	91.38	91.538	91.13	91.27	639800.0
2003-08-05 15:00:00	DIA	ETF	91.31	91.31	90.44	90.44	1534000.0
2003-08-05 16:00:00	DIA	ETF	90.5	90.5	90.03	90.16	215500.0
2003-08-05 17:00:00	DIA	ETF	90.11	90.14	90.05	90.1	6000.0
2003-08-05 18:00:00	DIA	ETF	90.1	90.18	90.01	90.12	6800.0
2003-08-05 19:00:00	DIA	ETF	90.12	90.12	90.05	90.12	3100.0
2003-08-05 09:00:00	TLT	ETF	83.21	83.29	82.99	82.99	254100.0
2003-08-05 10:00:00	TLT	ETF	82.96	82.99	82.35	82.48	466700.0
2003-08-05 11:00:00	TLT	ETF	82.48	82.55	82.2	82.48	431600.0
2003-08-05 12:00:00	TLT	ETF	82.48	82.58	82.42	82.43	76500.0
2003-08-05 13:00:00	TLT	ETF	82.4	82.43	82.16	82.27	137400.0
2003-08-05 14:00:00	TLT	ETF	82.25	82.28	81.8	81.97	436800.0

> showing 50 of 418 rows — these rows as CSV

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