PREVIEW / etf_1hour / 2003-09-11

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-09-11.parquet
  size:    17 KB
  rows:    424

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-11 08:00:00	SPY	ETF	101.96	102.05	101.7	102.0	190800.0
2003-09-11 09:00:00	SPY	ETF	102.01	102.39	101.99	102.14	5462900.0
2003-09-11 10:00:00	SPY	ETF	102.155	102.44	102.03	102.12	5578800.0
2003-09-11 11:00:00	SPY	ETF	102.11	102.47	101.84	102.29	6881000.0
2003-09-11 12:00:00	SPY	ETF	102.3	102.47	102.26	102.45	1993100.0
2003-09-11 13:00:00	SPY	ETF	102.45	102.62	102.4	102.48	3273200.0
2003-09-11 14:00:00	SPY	ETF	102.47	102.76	102.46	102.65	3947800.0
2003-09-11 15:00:00	SPY	ETF	102.65	102.7	102.19	102.267	4482300.0
2003-09-11 16:00:00	SPY	ETF	102.2	102.4121	102.2	102.34	2607400.0
2003-09-11 17:00:00	SPY	ETF	102.3	102.34	102.3	102.31	14100.0
2003-09-11 18:00:00	SPY	ETF	102.31	102.34	102.26	102.34	394900.0
2003-09-11 19:00:00	SPY	ETF	102.34	102.34	102.26	102.31	1600.0
2003-09-11 08:00:00	QQQ	ETF	33.22	33.32	33.12	33.3	436900.0
2003-09-11 09:00:00	QQQ	ETF	33.3	33.47	33.25	33.32	10759000.0
2003-09-11 10:00:00	QQQ	ETF	33.32	33.44	33.08	33.15	15109200.0
2003-09-11 11:00:00	QQQ	ETF	33.15	33.39	33.01	33.336	14443100.0
2003-09-11 12:00:00	QQQ	ETF	33.338	33.57	33.32	33.55	10118700.0
2003-09-11 13:00:00	QQQ	ETF	33.55	33.64	33.45	33.54	8637400.0
2003-09-11 14:00:00	QQQ	ETF	33.54	33.78	33.53	33.75	10029700.0
2003-09-11 15:00:00	QQQ	ETF	33.75	33.78	33.5	33.56	12600600.0
2003-09-11 16:00:00	QQQ	ETF	33.56	33.7	33.54	33.62	2530800.0
2003-09-11 17:00:00	QQQ	ETF	33.622	33.66	33.62	33.625	38300.0
2003-09-11 18:00:00	QQQ	ETF	33.65	33.66	33.62	33.63	21900.0
2003-09-11 19:00:00	QQQ	ETF	33.63	33.65	33.63	33.63	11800.0
2003-09-11 09:00:00	IWM	ETF	50.19	50.35	50.11	50.29	956400.0
2003-09-11 10:00:00	IWM	ETF	50.29	50.515	50.19	50.19	1049400.0
2003-09-11 11:00:00	IWM	ETF	50.19	50.39	50.095	50.355	594200.0
2003-09-11 12:00:00	IWM	ETF	50.335	50.44	50.3075	50.38	347400.0
2003-09-11 13:00:00	IWM	ETF	50.385	50.545	50.385	50.455	664200.0
2003-09-11 14:00:00	IWM	ETF	50.485	50.775	50.485	50.74	642800.0
2003-09-11 15:00:00	IWM	ETF	50.76	50.76	50.615	50.665	805200.0
2003-09-11 16:00:00	IWM	ETF	50.655	50.675	50.575	50.675	65800.0
2003-09-11 08:00:00	DIA	ETF	94.63	94.69	94.41	94.69	5800.0
2003-09-11 09:00:00	DIA	ETF	94.66	94.88	94.61	94.74	869200.0
2003-09-11 10:00:00	DIA	ETF	94.73	94.99	94.71	94.76	593900.0
2003-09-11 11:00:00	DIA	ETF	94.78	95.07	94.53	94.96	1503400.0
2003-09-11 12:00:00	DIA	ETF	94.97	95.113	94.89	95.08	405900.0
2003-09-11 13:00:00	DIA	ETF	95.11	95.2	95.03	95.08	518400.0
2003-09-11 14:00:00	DIA	ETF	95.1	95.34	95.1	95.3	649000.0
2003-09-11 15:00:00	DIA	ETF	95.3	95.33	94.81	94.84	850600.0
2003-09-11 16:00:00	DIA	ETF	94.84	94.971	94.84	94.96	340800.0
2003-09-11 17:00:00	DIA	ETF	94.98	94.98	94.98	94.98	400.0
2003-09-11 19:00:00	DIA	ETF	94.98	94.98	94.96	94.96	500.0
2003-09-11 09:00:00	TLT	ETF	84.26	84.37	84.15	84.26	83800.0
2003-09-11 10:00:00	TLT	ETF	84.28	84.28	83.88	84.01	434200.0
2003-09-11 11:00:00	TLT	ETF	84.07	84.2	84.0	84.04	129200.0
2003-09-11 12:00:00	TLT	ETF	84.1	84.12	83.89	83.94	36200.0
2003-09-11 13:00:00	TLT	ETF	84.03	84.17	83.8	84.0	50600.0
2003-09-11 14:00:00	TLT	ETF	84.01	84.05	83.87	84.0	40600.0
2003-09-11 15:00:00	TLT	ETF	83.95	84.14	83.91	84.04	48900.0

> showing 50 of 424 rows — these rows as CSV

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