PREVIEW / etf_1hour / 2003-07-28

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-07-28.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-28 08:00:00	SPY	ETF	100.35	100.41	100.35	100.41	47900.0
2003-07-28 09:00:00	SPY	ETF	100.43	100.49	99.67	99.86	5502300.0
2003-07-28 10:00:00	SPY	ETF	99.82	100.4	99.706	100.26	5274200.0
2003-07-28 11:00:00	SPY	ETF	100.27	100.45	100.07	100.07	3556200.0
2003-07-28 12:00:00	SPY	ETF	100.07	100.1	99.67	99.97	2914700.0
2003-07-28 13:00:00	SPY	ETF	99.96	100.37	99.76	100.22	3398900.0
2003-07-28 14:00:00	SPY	ETF	100.22	100.288	99.86	100.25	3768800.0
2003-07-28 15:00:00	SPY	ETF	100.25	100.35	99.75	100.04	5168700.0
2003-07-28 16:00:00	SPY	ETF	100.04	100.09	99.8	99.919	1204600.0
2003-07-28 17:00:00	SPY	ETF	99.91	99.94	99.89	99.89	8300.0
2003-07-28 18:00:00	SPY	ETF	99.9	99.95	99.9	99.944	7400.0
2003-07-28 19:00:00	SPY	ETF	99.91	99.91	99.9	99.9	700.0
2003-07-28 08:00:00	QQQ	ETF	31.89	31.93	31.86	31.89	45100.0
2003-07-28 09:00:00	QQQ	ETF	31.9	31.95	31.6	31.72	9931500.0
2003-07-28 10:00:00	QQQ	ETF	31.72	31.97	31.67	31.91	10423500.0
2003-07-28 11:00:00	QQQ	ETF	31.92	31.988	31.8	31.82	6665000.0
2003-07-28 12:00:00	QQQ	ETF	31.83	31.83	31.67	31.77	6426400.0
2003-07-28 13:00:00	QQQ	ETF	31.77	31.926	31.67	31.861	3706400.0
2003-07-28 14:00:00	QQQ	ETF	31.86	31.921	31.709	31.92	6207700.0
2003-07-28 15:00:00	QQQ	ETF	31.902	31.96	31.72	31.85	8768400.0
2003-07-28 16:00:00	QQQ	ETF	31.85	31.92	31.83	31.88	1141500.0
2003-07-28 17:00:00	QQQ	ETF	31.88	31.891	31.8	31.84	174000.0
2003-07-28 18:00:00	QQQ	ETF	31.866	31.87	31.84	31.86	17200.0
2003-07-28 19:00:00	QQQ	ETF	31.86	31.86	31.86	31.86	700.0
2003-07-28 09:00:00	IWM	ETF	46.82	47.13	46.79	46.925	824600.0
2003-07-28 10:00:00	IWM	ETF	46.9	47.29	46.865	47.19	415000.0
2003-07-28 11:00:00	IWM	ETF	47.195	47.25	47.085	47.15	617400.0
2003-07-28 12:00:00	IWM	ETF	47.16	47.165	47.07	47.15	178000.0
2003-07-28 13:00:00	IWM	ETF	47.15	47.335	47.14	47.33	417200.0
2003-07-28 14:00:00	IWM	ETF	47.32	47.325	47.19	47.32	159000.0
2003-07-28 15:00:00	IWM	ETF	47.34	47.4	47.15	47.35	659200.0
2003-07-28 16:00:00	IWM	ETF	47.4	47.465	47.265	47.265	230200.0
2003-07-28 08:00:00	DIA	ETF	93.03	93.1	93.0	93.06	6100.0
2003-07-28 09:00:00	DIA	ETF	93.05	93.15	92.4	92.55	814200.0
2003-07-28 10:00:00	DIA	ETF	92.57	93.01	92.44	92.92	1165400.0
2003-07-28 11:00:00	DIA	ETF	92.9	93.15	92.82	92.87	820900.0
2003-07-28 12:00:00	DIA	ETF	92.87	92.88	92.46	92.73	621300.0
2003-07-28 13:00:00	DIA	ETF	92.73	93.06	92.57	92.91	463800.0
2003-07-28 14:00:00	DIA	ETF	92.88	93.02	92.57	92.98	546000.0
2003-07-28 15:00:00	DIA	ETF	92.95	93.039	92.5	92.74	671400.0
2003-07-28 16:00:00	DIA	ETF	92.768	92.82	92.63	92.66	83500.0
2003-07-28 17:00:00	DIA	ETF	92.66	92.72	92.66	92.67	1000.0
2003-07-28 18:00:00	DIA	ETF	92.67	92.67	92.67	92.67	300.0
2003-07-28 19:00:00	DIA	ETF	92.66	92.66	92.66	92.66	4900.0
2003-07-28 09:00:00	TLT	ETF	85.24	85.29	84.76	85.097	200100.0
2003-07-28 10:00:00	TLT	ETF	85.06	85.1	84.85	84.96	154200.0
2003-07-28 11:00:00	TLT	ETF	84.93	85.02	84.62	84.73	136600.0
2003-07-28 12:00:00	TLT	ETF	84.73	84.94	84.68	84.81	118600.0
2003-07-28 13:00:00	TLT	ETF	84.74	84.94	84.74	84.94	161200.0
2003-07-28 14:00:00	TLT	ETF	84.94	84.94	84.57	84.58	146700.0

> showing 50 of 421 rows — these rows as CSV

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