PREVIEW / etf_1hour / 2003-07-11

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-07-11.parquet
  size:    17 KB
  rows:    421

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-07-11 08:00:00	SPY	ETF	99.2	99.45	99.15	99.45	116500.0
2003-07-11 09:00:00	SPY	ETF	99.47	99.99	99.38	99.84	5536900.0
2003-07-11 10:00:00	SPY	ETF	99.86	100.3	99.56	100.02	8157800.0
2003-07-11 11:00:00	SPY	ETF	100.04	100.35	99.81	100.33	3310300.0
2003-07-11 12:00:00	SPY	ETF	100.32	100.45	100.15	100.16	2666600.0
2003-07-11 13:00:00	SPY	ETF	100.17	100.27	100.04	100.2	1998400.0
2003-07-11 14:00:00	SPY	ETF	100.19	100.28	99.61	99.71	3985900.0
2003-07-11 15:00:00	SPY	ETF	99.71	100.27	99.6	100.14	3923700.0
2003-07-11 16:00:00	SPY	ETF	100.13	100.29	99.2025	100.2	5060300.0
2003-07-11 17:00:00	SPY	ETF	100.25	100.25	100.15	100.15	109700.0
2003-07-11 18:00:00	SPY	ETF	100.22	100.23	100.22	100.23	600.0
2003-07-11 19:00:00	SPY	ETF	100.24	100.24	100.15	100.15	2700.0
2003-07-11 08:00:00	QQQ	ETF	31.52	31.64	31.49	31.63	162100.0
2003-07-11 09:00:00	QQQ	ETF	31.63	31.85	31.63	31.82	10917900.0
2003-07-11 10:00:00	QQQ	ETF	31.819	31.99	31.71	31.855	12824200.0
2003-07-11 11:00:00	QQQ	ETF	31.85	31.98	31.76	31.95	7860400.0
2003-07-11 12:00:00	QQQ	ETF	31.96	31.98	31.84	31.87	8731000.0
2003-07-11 13:00:00	QQQ	ETF	31.87	31.94	31.82	31.89	4579900.0
2003-07-11 14:00:00	QQQ	ETF	31.9	31.92	31.61	31.67	9060700.0
2003-07-11 15:00:00	QQQ	ETF	31.671	31.93	31.62	31.839	6980000.0
2003-07-11 16:00:00	QQQ	ETF	31.84	31.92	31.8	31.91	1470200.0
2003-07-11 17:00:00	QQQ	ETF	31.92	31.96	31.91	31.94	88500.0
2003-07-11 18:00:00	QQQ	ETF	31.94	31.94	31.91	31.94	22000.0
2003-07-11 19:00:00	QQQ	ETF	31.92	31.98	31.92	31.97	28800.0
2003-07-11 09:00:00	IWM	ETF	46.86	47.175	46.8	47.1	364200.0
2003-07-11 10:00:00	IWM	ETF	47.13	47.35	47.01	47.25	535800.0
2003-07-11 11:00:00	IWM	ETF	47.24	47.32	47.16	47.315	380800.0
2003-07-11 12:00:00	IWM	ETF	47.31	47.32	47.205	47.26	169400.0
2003-07-11 13:00:00	IWM	ETF	47.25	47.255	47.175	47.175	185000.0
2003-07-11 14:00:00	IWM	ETF	47.195	47.235	47.055	47.07	175400.0
2003-07-11 15:00:00	IWM	ETF	47.105	47.245	47.075	47.22	400800.0
2003-07-11 16:00:00	IWM	ETF	47.25	47.34	47.25	47.315	108000.0
2003-07-11 08:00:00	DIA	ETF	90.62	90.62	90.51	90.56	8000.0
2003-07-11 09:00:00	DIA	ETF	90.8	91.23	90.65	91.12	667800.0
2003-07-11 10:00:00	DIA	ETF	91.14	91.55	90.85	91.3	1229700.0
2003-07-11 11:00:00	DIA	ETF	91.32	91.56	91.19	91.55	518900.0
2003-07-11 12:00:00	DIA	ETF	91.551	91.69	91.38	91.4	368500.0
2003-07-11 13:00:00	DIA	ETF	91.38	91.45	91.2	91.39	274400.0
2003-07-11 14:00:00	DIA	ETF	91.39	91.45	90.9	91.0	445400.0
2003-07-11 15:00:00	DIA	ETF	90.99	91.46	90.87	91.373	587900.0
2003-07-11 16:00:00	DIA	ETF	91.371	91.4	91.3	91.35	165900.0
2003-07-11 17:00:00	DIA	ETF	91.35	91.36	91.25	91.26	1600.0
2003-07-11 19:00:00	DIA	ETF	91.32	91.32	91.28	91.28	2200.0
2003-07-11 09:00:00	TLT	ETF	90.3	90.55	90.3	90.52	256000.0
2003-07-11 10:00:00	TLT	ETF	90.5	90.5	90.22	90.41	13500.0
2003-07-11 11:00:00	TLT	ETF	90.35	90.39	90.3	90.3	12300.0
2003-07-11 12:00:00	TLT	ETF	90.3	90.38	90.21	90.35	11600.0
2003-07-11 13:00:00	TLT	ETF	90.35	90.39	90.3	90.33	16500.0
2003-07-11 14:00:00	TLT	ETF	90.4	90.65	90.39	90.65	52000.0
2003-07-11 15:00:00	TLT	ETF	90.72	90.76	90.66	90.69	22500.0

> showing 50 of 421 rows — these rows as CSV

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