PREVIEW / etf_1hour / 2003-09-09

all etf 1-hour files

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

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-09 08:00:00	SPY	ETF	103.65	103.65	103.48	103.51	30500.0
2003-09-09 09:00:00	SPY	ETF	103.49	103.49	103.2	103.25	5493300.0
2003-09-09 10:00:00	SPY	ETF	103.25	103.38	102.72	103.11	6730200.0
2003-09-09 11:00:00	SPY	ETF	103.12	103.46	103.02	103.27	3944100.0
2003-09-09 12:00:00	SPY	ETF	103.31	103.44	103.16	103.25	1995000.0
2003-09-09 13:00:00	SPY	ETF	103.22	103.25	103.01	103.21	2640500.0
2003-09-09 14:00:00	SPY	ETF	103.19	103.33	103.05	103.14	2303100.0
2003-09-09 15:00:00	SPY	ETF	103.11	103.16	102.68	102.927	4267000.0
2003-09-09 16:00:00	SPY	ETF	102.93	103.93	102.85	102.875	1178200.0
2003-09-09 17:00:00	SPY	ETF	102.87	102.96	102.87	102.96	131600.0
2003-09-09 18:00:00	SPY	ETF	102.95	102.97	102.92	102.97	12200.0
2003-09-09 19:00:00	SPY	ETF	102.91	102.96	102.91	102.94	600.0
2003-09-09 08:00:00	QQQ	ETF	34.4	34.46	34.39	34.41	61500.0
2003-09-09 09:00:00	QQQ	ETF	34.4	34.4	34.17	34.19	9655300.0
2003-09-09 10:00:00	QQQ	ETF	34.19	34.29	33.93	34.16	22361100.0
2003-09-09 11:00:00	QQQ	ETF	34.17	34.32	34.108	34.27	9914100.0
2003-09-09 12:00:00	QQQ	ETF	34.27	34.386	34.25	34.28	5004600.0
2003-09-09 13:00:00	QQQ	ETF	34.28	34.292	34.16	34.29	5799300.0
2003-09-09 14:00:00	QQQ	ETF	34.29	34.3	34.07	34.14	6378100.0
2003-09-09 15:00:00	QQQ	ETF	34.14	34.16	33.92	34.05	10261000.0
2003-09-09 16:00:00	QQQ	ETF	34.044	34.11	33.86	33.93	4075200.0
2003-09-09 17:00:00	QQQ	ETF	33.93	34.4763	33.91	33.94	2754100.0
2003-09-09 18:00:00	QQQ	ETF	33.95	33.98	33.94	33.95	23100.0
2003-09-09 19:00:00	QQQ	ETF	33.98	34.0	33.98	34.0	17800.0
2003-09-09 08:00:00	IWM	ETF	51.555	51.555	51.555	51.555	200.0
2003-09-09 09:00:00	IWM	ETF	51.525	51.59	51.4	51.445	498800.0
2003-09-09 10:00:00	IWM	ETF	51.38	51.53	51.2	51.375	530800.0
2003-09-09 11:00:00	IWM	ETF	51.365	51.58	51.31	51.57	497000.0
2003-09-09 12:00:00	IWM	ETF	51.57	51.62	51.525	51.565	186200.0
2003-09-09 13:00:00	IWM	ETF	51.565	51.58	51.455	51.575	135600.0
2003-09-09 14:00:00	IWM	ETF	51.59	51.6	51.44	51.47	194600.0
2003-09-09 15:00:00	IWM	ETF	51.475	51.475	51.055	51.19	1473000.0
2003-09-09 16:00:00	IWM	ETF	51.19	51.28	51.155	51.155	532600.0
2003-09-09 17:00:00	IWM	ETF	51.15	51.15	51.15	51.15	200.0
2003-09-09 08:00:00	DIA	ETF	96.05	96.07	95.84	95.85	7300.0
2003-09-09 09:00:00	DIA	ETF	95.85	95.85	95.65	95.71	454500.0
2003-09-09 10:00:00	DIA	ETF	95.69	95.84	95.4	95.7	874000.0
2003-09-09 11:00:00	DIA	ETF	95.73	95.99	95.58	95.851	478300.0
2003-09-09 12:00:00	DIA	ETF	95.87	95.98	95.7	95.789	276700.0
2003-09-09 13:00:00	DIA	ETF	95.78	95.81	95.62	95.7	298200.0
2003-09-09 14:00:00	DIA	ETF	95.73	95.8	95.52	95.58	542900.0
2003-09-09 15:00:00	DIA	ETF	95.59	95.62	95.15	95.36	992500.0
2003-09-09 16:00:00	DIA	ETF	95.37	95.46	95.29	95.3	124000.0
2003-09-09 17:00:00	DIA	ETF	95.69	95.69	95.69	95.69	1300.0
2003-09-09 19:00:00	DIA	ETF	95.28	95.28	95.27	95.27	400.0
2003-09-09 09:00:00	TLT	ETF	83.52	83.74	83.52	83.58	24400.0
2003-09-09 10:00:00	TLT	ETF	83.59	83.65	83.33	83.58	115500.0
2003-09-09 11:00:00	TLT	ETF	83.55	83.55	82.916	83.1	95900.0
2003-09-09 12:00:00	TLT	ETF	83.08	83.24	83.0	83.19	36400.0
2003-09-09 13:00:00	TLT	ETF	83.19	83.64	83.19	83.57	119900.0

> showing 50 of 436 rows — these rows as CSV

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