PREVIEW / etf_1hour / 2003-04-07

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-04-07.parquet
  size:    17 KB
  rows:    416

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-04-07 08:00:00	SPY	ETF	90.53	90.62	90.24	90.3	94200.0
2003-04-07 09:00:00	SPY	ETF	90.3	90.66	90.11	90.44	10226800.0
2003-04-07 10:00:00	SPY	ETF	90.46	90.85	89.8	89.85	15960000.0
2003-04-07 11:00:00	SPY	ETF	89.87	90.22	89.8	89.93	7831000.0
2003-04-07 12:00:00	SPY	ETF	89.93	90.09	89.63	89.88	4856000.0
2003-04-07 13:00:00	SPY	ETF	89.9	90.06	89.69	89.88	3410400.0
2003-04-07 14:00:00	SPY	ETF	89.87	89.97	89.2	89.24	4931300.0
2003-04-07 15:00:00	SPY	ETF	89.2	89.28	88.19	88.23	13718200.0
2003-04-07 16:00:00	SPY	ETF	88.22	90.52	87.97	88.12	3485100.0
2003-04-07 17:00:00	SPY	ETF	88.15	88.2	88.07	88.11	49500.0
2003-04-07 18:00:00	SPY	ETF	88.06	88.11	88.0	88.06	21300.0
2003-04-07 19:00:00	SPY	ETF	88.06	88.06	87.9	87.98	8100.0
2003-04-07 08:00:00	QQQ	ETF	27.04	27.07	26.63	26.99	212700.0
2003-04-07 09:00:00	QQQ	ETF	27.0	27.18	26.95	27.09	14837300.0
2003-04-07 10:00:00	QQQ	ETF	27.1	27.15	26.81	26.84	11928400.0
2003-04-07 11:00:00	QQQ	ETF	26.84	26.97	26.81	26.92	7713500.0
2003-04-07 12:00:00	QQQ	ETF	26.92	26.95	26.77	26.8	6107400.0
2003-04-07 13:00:00	QQQ	ETF	26.8	26.9	26.78	26.86	4335500.0
2003-04-07 14:00:00	QQQ	ETF	26.84	26.89	26.57	26.57	6868500.0
2003-04-07 15:00:00	QQQ	ETF	26.57	26.6	26.18	26.21	20714200.0
2003-04-07 16:00:00	QQQ	ETF	26.2	26.25	26.06	26.08	3118300.0
2003-04-07 17:00:00	QQQ	ETF	26.09	26.14	26.08	26.13	132600.0
2003-04-07 18:00:00	QQQ	ETF	26.12	26.16	26.1	26.11	48500.0
2003-04-07 19:00:00	QQQ	ETF	26.11	26.18	26.11	26.11	60000.0
2003-04-07 09:00:00	IWM	ETF	38.075	38.2	37.925	38.125	499600.0
2003-04-07 10:00:00	IWM	ETF	38.135	38.22	37.88	37.89	784800.0
2003-04-07 11:00:00	IWM	ETF	37.875	37.95	37.85	37.875	442400.0
2003-04-07 12:00:00	IWM	ETF	37.895	37.925	37.79	37.85	285000.0
2003-04-07 13:00:00	IWM	ETF	37.86	37.865	37.76	37.765	141400.0
2003-04-07 14:00:00	IWM	ETF	37.81	37.81	37.6	37.6	165800.0
2003-04-07 15:00:00	IWM	ETF	37.61	37.61	37.325	37.415	501600.0
2003-04-07 16:00:00	IWM	ETF	37.415	37.415	37.29	37.29	7200.0
2003-04-07 17:00:00	IWM	ETF	37.38	37.38	37.38	37.38	200.0
2003-04-07 08:00:00	DIA	ETF	85.06	85.14	84.73	84.87	36600.0
2003-04-07 09:00:00	DIA	ETF	84.85	85.26	84.7	85.09	2656000.0
2003-04-07 10:00:00	DIA	ETF	85.1	85.4	84.48	84.55	2574400.0
2003-04-07 11:00:00	DIA	ETF	84.53	84.9	84.52	84.68	1107300.0
2003-04-07 12:00:00	DIA	ETF	84.68	84.8	84.39	84.64	755900.0
2003-04-07 13:00:00	DIA	ETF	84.68	84.83	84.48	84.62	601700.0
2003-04-07 14:00:00	DIA	ETF	84.62	84.71	83.94	84.01	786800.0
2003-04-07 15:00:00	DIA	ETF	84.0	84.04	83.05	83.11	2039000.0
2003-04-07 16:00:00	DIA	ETF	83.07	83.1	82.87	83.01	173300.0
2003-04-07 17:00:00	DIA	ETF	83.05	83.06	82.87	82.91	25300.0
2003-04-07 18:00:00	DIA	ETF	82.9	82.92	82.86	82.89	3800.0
2003-04-07 19:00:00	DIA	ETF	82.8	82.8	82.8	82.8	500.0
2003-04-07 09:00:00	TLT	ETF	86.22	86.22	85.92	86.05	166200.0
2003-04-07 10:00:00	TLT	ETF	86.05	86.26	86.0	86.25	106800.0
2003-04-07 11:00:00	TLT	ETF	86.32	86.33	86.19	86.25	16500.0
2003-04-07 12:00:00	TLT	ETF	86.3	86.38	86.3	86.37	17600.0
2003-04-07 13:00:00	TLT	ETF	86.31	86.31	86.13	86.26	9300.0

> showing 50 of 416 rows — these rows as CSV

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