PREVIEW / etf_1hour / 2003-08-25

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-08-25.parquet
  size:    17 KB
  rows:    415

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-25 08:00:00	SPY	ETF	99.5	99.7	99.5	99.68	41600.0
2003-08-25 09:00:00	SPY	ETF	99.73	101.35	99.48	99.61	3942200.0
2003-08-25 10:00:00	SPY	ETF	99.62	99.81	99.41	99.59	4099300.0
2003-08-25 11:00:00	SPY	ETF	99.57	99.7	99.28	99.58	2945500.0
2003-08-25 12:00:00	SPY	ETF	99.58	99.82	99.47	99.81	1958900.0
2003-08-25 13:00:00	SPY	ETF	99.82	99.88	99.66	99.73	2654200.0
2003-08-25 14:00:00	SPY	ETF	99.73	99.83	99.54	99.58	1559400.0
2003-08-25 15:00:00	SPY	ETF	99.59	99.9	99.55	99.82	3004800.0
2003-08-25 16:00:00	SPY	ETF	99.83	100.0	99.76	99.95	1146900.0
2003-08-25 17:00:00	SPY	ETF	99.94	99.99	99.92	99.99	17900.0
2003-08-25 18:00:00	SPY	ETF	99.94	99.94	99.93	99.93	6800.0
2003-08-25 19:00:00	SPY	ETF	99.91	99.96	99.91	99.96	3000.0
2003-08-25 08:00:00	QQQ	ETF	32.31	32.37	32.26	32.36	74900.0
2003-08-25 09:00:00	QQQ	ETF	32.34	32.508	32.3	32.37	7594600.0
2003-08-25 10:00:00	QQQ	ETF	32.37	32.47	32.25	32.27	8930800.0
2003-08-25 11:00:00	QQQ	ETF	32.27	32.37	32.21	32.289	5828500.0
2003-08-25 12:00:00	QQQ	ETF	32.28	32.47	32.25	32.45	3290700.0
2003-08-25 13:00:00	QQQ	ETF	32.44	32.49	32.35	32.38	3029700.0
2003-08-25 14:00:00	QQQ	ETF	32.38	32.46	32.28	32.327	3280000.0
2003-08-25 15:00:00	QQQ	ETF	32.32	32.48	32.31	32.45	6009900.0
2003-08-25 16:00:00	QQQ	ETF	32.46	32.55	32.43	32.54	1821500.0
2003-08-25 17:00:00	QQQ	ETF	32.53	32.55	32.51	32.55	57800.0
2003-08-25 18:00:00	QQQ	ETF	32.54	32.56	32.53	32.55	20000.0
2003-08-25 19:00:00	QQQ	ETF	32.53	32.53	32.51	32.53	2800.0
2003-08-25 09:00:00	IWM	ETF	48.37	48.545	48.125	48.19	869200.0
2003-08-25 10:00:00	IWM	ETF	48.21	48.235	48.065	48.095	589000.0
2003-08-25 11:00:00	IWM	ETF	48.1	48.1	47.96	48.0	1124000.0
2003-08-25 12:00:00	IWM	ETF	48.015	48.2	47.98	48.19	287400.0
2003-08-25 13:00:00	IWM	ETF	48.19	48.22	48.175	48.19	100600.0
2003-08-25 14:00:00	IWM	ETF	48.2	48.225	48.105	48.105	401400.0
2003-08-25 15:00:00	IWM	ETF	48.125	48.415	48.12	48.325	849400.0
2003-08-25 16:00:00	IWM	ETF	48.27	48.44	48.27	48.415	26800.0
2003-08-25 08:00:00	DIA	ETF	93.5	93.66	93.48	93.61	2400.0
2003-08-25 09:00:00	DIA	ETF	93.68	94.0	93.249	93.37	656200.0
2003-08-25 10:00:00	DIA	ETF	93.34	93.48	93.15	93.26	900700.0
2003-08-25 11:00:00	DIA	ETF	93.22	93.33	93.01	93.18	652300.0
2003-08-25 12:00:00	DIA	ETF	93.18	93.38	93.05	93.38	408700.0
2003-08-25 13:00:00	DIA	ETF	93.38	93.45	93.2	93.25	312400.0
2003-08-25 14:00:00	DIA	ETF	93.26	93.31	93.06	93.14	365700.0
2003-08-25 15:00:00	DIA	ETF	93.14	93.41	93.11	93.38	467300.0
2003-08-25 16:00:00	DIA	ETF	93.35	93.51	93.31	93.45	63600.0
2003-08-25 17:00:00	DIA	ETF	93.5	93.52	93.5	93.52	900.0
2003-08-25 09:00:00	TLT	ETF	83.32	83.54	83.3	83.4	18900.0
2003-08-25 10:00:00	TLT	ETF	83.4	83.43	82.8	82.8	101100.0
2003-08-25 11:00:00	TLT	ETF	82.76	82.79	82.56	82.56	271000.0
2003-08-25 12:00:00	TLT	ETF	82.55	82.6	82.25	82.5	58700.0
2003-08-25 13:00:00	TLT	ETF	82.57	82.76	82.52	82.66	23300.0
2003-08-25 14:00:00	TLT	ETF	82.7	82.8	82.55	82.8	70300.0
2003-08-25 15:00:00	TLT	ETF	82.77	82.83	82.71	82.73	17900.0
2003-08-25 16:00:00	TLT	ETF	82.82	82.82	82.72	82.72	3200.0

> showing 50 of 415 rows — these rows as CSV

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