PREVIEW / etf_1hour / 2003-07-24

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-07-24.parquet
  size:    17 KB
  rows:    427

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-24 08:00:00	SPY	ETF	99.4	100.08	99.4	99.95	295100.0
2003-07-24 09:00:00	SPY	ETF	99.95	99.99	99.46	99.65	5812900.0
2003-07-24 10:00:00	SPY	ETF	99.69	100.34	99.66	99.839	6137600.0
2003-07-24 11:00:00	SPY	ETF	99.85	100.16	99.76	99.93	2930800.0
2003-07-24 12:00:00	SPY	ETF	99.92	99.95	99.69	99.833	1837400.0
2003-07-24 13:00:00	SPY	ETF	99.83	100.05	99.77	99.95	1666600.0
2003-07-24 14:00:00	SPY	ETF	99.99	100.04	98.9	99.01	6997800.0
2003-07-24 15:00:00	SPY	ETF	99.01	99.09	98.37	98.5	7719600.0
2003-07-24 16:00:00	SPY	ETF	98.5	98.58	98.3	98.38	2079300.0
2003-07-24 17:00:00	SPY	ETF	98.39	98.41	98.33	98.34	344400.0
2003-07-24 18:00:00	SPY	ETF	98.35	98.38	98.313	98.38	2600.0
2003-07-24 19:00:00	SPY	ETF	98.4	98.4	98.36	98.36	1600.0
2003-07-24 20:00:00	SPY	ETF	98.32	98.32	98.32	98.32	200.0
2003-07-24 08:00:00	QQQ	ETF	31.59	32.05	31.59	31.96	389900.0
2003-07-24 09:00:00	QQQ	ETF	31.94	31.97	31.72	31.862	11303600.0
2003-07-24 10:00:00	QQQ	ETF	31.85	32.01	31.754	31.809	12346900.0
2003-07-24 11:00:00	QQQ	ETF	31.81	31.94	31.778	31.85	5344700.0
2003-07-24 12:00:00	QQQ	ETF	31.846	31.87	31.72	31.76	5222700.0
2003-07-24 13:00:00	QQQ	ETF	31.77	31.87	31.76	31.84	3100000.0
2003-07-24 14:00:00	QQQ	ETF	31.85	31.86	31.32	31.4	14318200.0
2003-07-24 15:00:00	QQQ	ETF	31.4	31.44	31.1	31.13	13820700.0
2003-07-24 16:00:00	QQQ	ETF	31.14	31.22	30.94	30.97	4265600.0
2003-07-24 17:00:00	QQQ	ETF	30.98	30.999	30.91	30.95	1116800.0
2003-07-24 18:00:00	QQQ	ETF	30.95	30.96	30.91	30.95	41700.0
2003-07-24 19:00:00	QQQ	ETF	30.95	31.0	30.92	30.94	17600.0
2003-07-24 09:00:00	IWM	ETF	46.92	46.94	46.73	46.895	288600.0
2003-07-24 10:00:00	IWM	ETF	46.895	47.195	46.895	46.945	997800.0
2003-07-24 11:00:00	IWM	ETF	46.975	47.055	46.875	46.94	394600.0
2003-07-24 12:00:00	IWM	ETF	46.92	46.92	46.8	46.865	226800.0
2003-07-24 13:00:00	IWM	ETF	46.885	46.91	46.83	46.88	75600.0
2003-07-24 14:00:00	IWM	ETF	46.92	46.925	46.45	46.45	796400.0
2003-07-24 15:00:00	IWM	ETF	46.465	46.54	46.34	46.42	600600.0
2003-07-24 16:00:00	IWM	ETF	46.37	46.485	46.37	46.485	21000.0
2003-07-24 08:00:00	DIA	ETF	92.27	92.83	92.27	92.78	10700.0
2003-07-24 09:00:00	DIA	ETF	92.77	92.77	92.19	92.44	1183100.0
2003-07-24 10:00:00	DIA	ETF	92.45	92.97	92.45	92.57	1421500.0
2003-07-24 11:00:00	DIA	ETF	92.61	92.8	92.45	92.58	350800.0
2003-07-24 12:00:00	DIA	ETF	92.569	92.64	92.36	92.47	226300.0
2003-07-24 13:00:00	DIA	ETF	92.45	92.63	92.38	92.53	224500.0
2003-07-24 14:00:00	DIA	ETF	92.52	92.58	91.55	91.62	1610700.0
2003-07-24 15:00:00	DIA	ETF	91.62	91.73	91.15	91.27	1123200.0
2003-07-24 16:00:00	DIA	ETF	91.22	91.29	91.08	91.14	105700.0
2003-07-24 17:00:00	DIA	ETF	91.15	91.2	91.15	91.15	4200.0
2003-07-24 18:00:00	DIA	ETF	91.15	91.18	91.15	91.18	3600.0
2003-07-24 19:00:00	DIA	ETF	91.18	91.18	91.18	91.18	100.0
2003-07-24 09:00:00	TLT	ETF	85.9	86.08	85.8	86.0	165900.0
2003-07-24 10:00:00	TLT	ETF	86.01	86.02	85.81	85.87	230100.0
2003-07-24 11:00:00	TLT	ETF	85.86	85.86	85.55	85.7	93300.0
2003-07-24 12:00:00	TLT	ETF	85.7	85.85	85.64	85.85	53000.0
2003-07-24 13:00:00	TLT	ETF	85.85	85.9	85.7	85.8	20600.0

> showing 50 of 427 rows — these rows as CSV

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