PREVIEW / etf_1hour / 2003-08-29

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-08-29.parquet
  size:    17 KB
  rows:    414

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-29 08:00:00	SPY	ETF	100.65	100.65	100.49	100.57	40200.0
2003-08-29 09:00:00	SPY	ETF	100.57	101.05	100.48	101.0	3401800.0
2003-08-29 10:00:00	SPY	ETF	101.0	101.15	100.65	100.86	4591500.0
2003-08-29 11:00:00	SPY	ETF	100.86	101.02	100.67	100.71	2071200.0
2003-08-29 12:00:00	SPY	ETF	100.7	100.85	100.62	100.71	1625800.0
2003-08-29 13:00:00	SPY	ETF	100.71	100.97	100.69	100.95	2936600.0
2003-08-29 14:00:00	SPY	ETF	100.95	101.23	100.91	101.18	2544200.0
2003-08-29 15:00:00	SPY	ETF	101.18	101.46	101.09	101.37	5008200.0
2003-08-29 16:00:00	SPY	ETF	101.37	101.49	101.25	101.38	4099400.0
2003-08-29 17:00:00	SPY	ETF	101.39	101.45	101.38	101.45	10800.0
2003-08-29 18:00:00	SPY	ETF	101.45	101.5	101.38	101.38	3800.0
2003-08-29 19:00:00	SPY	ETF	101.47	101.48	101.44	101.48	700.0
2003-08-29 08:00:00	QQQ	ETF	33.0	33.03	32.98	33.02	36200.0
2003-08-29 09:00:00	QQQ	ETF	33.02	33.26	32.98	33.24	6456800.0
2003-08-29 10:00:00	QQQ	ETF	33.24	33.297	33.07	33.16	9483800.0
2003-08-29 11:00:00	QQQ	ETF	33.16	33.25	33.11	33.13	3354700.0
2003-08-29 12:00:00	QQQ	ETF	33.12	33.18	33.05	33.11	3358500.0
2003-08-29 13:00:00	QQQ	ETF	33.12	33.25	33.1	33.23	3470300.0
2003-08-29 14:00:00	QQQ	ETF	33.24	33.32	33.21	33.32	4843200.0
2003-08-29 15:00:00	QQQ	ETF	33.31	33.45	33.23	33.31	14800600.0
2003-08-29 16:00:00	QQQ	ETF	33.31	33.44	33.12	33.43	4352200.0
2003-08-29 17:00:00	QQQ	ETF	33.44	33.45	33.37	33.43	133300.0
2003-08-29 18:00:00	QQQ	ETF	33.43	33.43	33.37	33.4	22600.0
2003-08-29 19:00:00	QQQ	ETF	33.39	33.45	33.39	33.45	3500.0
2003-08-29 09:00:00	IWM	ETF	49.445	49.515	49.335	49.515	174200.0
2003-08-29 10:00:00	IWM	ETF	49.515	49.63	49.445	49.575	781600.0
2003-08-29 11:00:00	IWM	ETF	49.57	49.65	49.56	49.59	395600.0
2003-08-29 12:00:00	IWM	ETF	49.585	49.65	49.58	49.6	126800.0
2003-08-29 13:00:00	IWM	ETF	49.62	49.725	49.61	49.725	87800.0
2003-08-29 14:00:00	IWM	ETF	49.73	49.825	49.705	49.8	199200.0
2003-08-29 15:00:00	IWM	ETF	49.785	49.925	49.6	49.615	407400.0
2003-08-29 16:00:00	IWM	ETF	49.62	49.665	49.555	49.66	1314800.0
2003-08-29 08:00:00	DIA	ETF	93.84	93.84	93.79	93.79	600.0
2003-08-29 09:00:00	DIA	ETF	93.78	94.201	93.69	94.18	424000.0
2003-08-29 10:00:00	DIA	ETF	94.19	94.28	93.86	94.0	937500.0
2003-08-29 11:00:00	DIA	ETF	94.03	94.18	93.83	93.9	415800.0
2003-08-29 12:00:00	DIA	ETF	93.91	94.03	93.8	93.89	225000.0
2003-08-29 13:00:00	DIA	ETF	93.9	94.12	93.9	94.1	244500.0
2003-08-29 14:00:00	DIA	ETF	94.09	94.25	94.04	94.23	485300.0
2003-08-29 15:00:00	DIA	ETF	94.23	94.41	94.14	94.38	1202400.0
2003-08-29 16:00:00	DIA	ETF	94.38	94.48	94.33	94.44	102000.0
2003-08-29 17:00:00	DIA	ETF	94.44	94.47	94.39	94.39	10500.0
2003-08-29 18:00:00	DIA	ETF	94.41	94.42	94.4	94.42	900.0
2003-08-29 19:00:00	DIA	ETF	94.38	94.42	94.38	94.42	300.0
2003-08-29 09:00:00	TLT	ETF	83.94	83.98	83.74	83.9	46700.0
2003-08-29 10:00:00	TLT	ETF	83.8	83.85	83.38	83.54	99700.0
2003-08-29 11:00:00	TLT	ETF	83.54	83.88	83.5	83.87	38300.0
2003-08-29 12:00:00	TLT	ETF	83.88	83.99	83.84	83.84	187800.0
2003-08-29 13:00:00	TLT	ETF	83.78	83.99	83.78	83.9	25100.0
2003-08-29 14:00:00	TLT	ETF	83.82	83.95	83.803	83.92	44600.0

> showing 50 of 414 rows — these rows as CSV

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