PREVIEW / etf_1hour / 2003-07-09

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-07-09.parquet
  size:    17 KB
  rows:    431

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-09 08:00:00	SPY	ETF	100.77	100.9	100.77	100.89	32600.0
2003-07-09 09:00:00	SPY	ETF	100.88	101.17	100.69	100.91	3562700.0
2003-07-09 10:00:00	SPY	ETF	100.9	101.4	100.391	100.47	6494200.0
2003-07-09 11:00:00	SPY	ETF	100.45	100.71	100.34	100.4	4587300.0
2003-07-09 12:00:00	SPY	ETF	100.38	100.45	100.03	100.41	4371800.0
2003-07-09 13:00:00	SPY	ETF	100.4	100.58	100.32	100.47	1452800.0
2003-07-09 14:00:00	SPY	ETF	100.47	100.9	100.46	100.77	3200300.0
2003-07-09 15:00:00	SPY	ETF	100.76	101.1	100.43	100.57	5912800.0
2003-07-09 16:00:00	SPY	ETF	100.56	100.7143	100.25	100.31	2420500.0
2003-07-09 17:00:00	SPY	ETF	100.32	100.32	100.23	100.28	110300.0
2003-07-09 18:00:00	SPY	ETF	100.29	100.32	100.28	100.3	8000.0
2003-07-09 19:00:00	SPY	ETF	100.31	100.34	100.27	100.34	1800.0
2003-07-09 08:00:00	QQQ	ETF	32.08	32.17	32.08	32.15	185700.0
2003-07-09 09:00:00	QQQ	ETF	32.15	32.35	32.1	32.212	10085500.0
2003-07-09 10:00:00	QQQ	ETF	32.21	32.49	32.07	32.1	16938800.0
2003-07-09 11:00:00	QQQ	ETF	32.08	32.29	32.06	32.08	11804200.0
2003-07-09 12:00:00	QQQ	ETF	32.08	32.16	31.93	32.11	7857600.0
2003-07-09 13:00:00	QQQ	ETF	32.09	32.2	32.07	32.12	4246300.0
2003-07-09 14:00:00	QQQ	ETF	32.119	32.36	32.08	32.301	8423900.0
2003-07-09 15:00:00	QQQ	ETF	32.294	32.45	32.1	32.17	11840700.0
2003-07-09 16:00:00	QQQ	ETF	32.17	32.23	31.933	31.97	5093300.0
2003-07-09 17:00:00	QQQ	ETF	31.96	32.0	31.95	31.99	866900.0
2003-07-09 18:00:00	QQQ	ETF	31.99	32.02	31.96	31.99	103400.0
2003-07-09 19:00:00	QQQ	ETF	31.98	31.99	31.96	31.97	17300.0
2003-07-09 09:00:00	IWM	ETF	47.26	47.365	46.87	47.07	1105600.0
2003-07-09 10:00:00	IWM	ETF	47.045	47.385	46.9625	47.185	1575000.0
2003-07-09 11:00:00	IWM	ETF	47.185	47.32	47.135	47.235	728200.0
2003-07-09 12:00:00	IWM	ETF	47.225	47.31	47.125	47.31	787600.0
2003-07-09 13:00:00	IWM	ETF	47.3	47.41	47.225	47.305	945600.0
2003-07-09 14:00:00	IWM	ETF	47.335	47.54	47.335	47.505	349000.0
2003-07-09 15:00:00	IWM	ETF	47.485	47.7	47.45	47.46	989600.0
2003-07-09 16:00:00	IWM	ETF	47.475	47.7	47.475	47.66	774400.0
2003-07-09 19:00:00	IWM	ETF	47.45	47.45	47.45	47.45	200.0
2003-07-09 08:00:00	DIA	ETF	92.22	92.29	92.16	92.16	2200.0
2003-07-09 09:00:00	DIA	ETF	92.25	92.4	91.9	92.11	678400.0
2003-07-09 10:00:00	DIA	ETF	92.11	92.49	91.5	91.58	1460300.0
2003-07-09 11:00:00	DIA	ETF	91.58	91.77	91.47	91.48	953500.0
2003-07-09 12:00:00	DIA	ETF	91.48	91.64	91.23	91.64	562600.0
2003-07-09 13:00:00	DIA	ETF	91.57	91.7	91.47	91.64	185800.0
2003-07-09 14:00:00	DIA	ETF	91.638	91.98	91.61	91.87	461200.0
2003-07-09 15:00:00	DIA	ETF	91.87	92.14	91.57	91.73	1082000.0
2003-07-09 16:00:00	DIA	ETF	91.69	92.41	91.62	91.67	719900.0
2003-07-09 17:00:00	DIA	ETF	92.4159	92.4159	91.44	91.45	1028500.0
2003-07-09 18:00:00	DIA	ETF	91.59	91.6	91.55	91.55	800.0
2003-07-09 19:00:00	DIA	ETF	91.55	91.55	91.49	91.49	1100.0
2003-07-09 20:00:00	DIA	ETF	91.5	91.5	91.5	91.5	500.0
2003-07-09 09:00:00	TLT	ETF	90.53	90.53	90.42	90.49	34100.0
2003-07-09 10:00:00	TLT	ETF	90.45	90.45	90.15	90.32	69600.0
2003-07-09 11:00:00	TLT	ETF	90.32	90.38	90.11	90.16	40300.0
2003-07-09 12:00:00	TLT	ETF	90.15	90.34	90.15	90.25	23300.0

> showing 50 of 431 rows — these rows as CSV

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