PREVIEW / etf_1hour / 2003-08-19

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-08-19.parquet
  size:    17 KB
  rows:    431

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-19 08:00:00	SPY	ETF	100.61	100.79	100.6	100.75	88600.0
2003-08-19 09:00:00	SPY	ETF	100.73	100.81	100.41	100.49	5169900.0
2003-08-19 10:00:00	SPY	ETF	100.45	100.94	100.2	100.83	8861500.0
2003-08-19 11:00:00	SPY	ETF	100.83	100.83	100.58	100.77	2732000.0
2003-08-19 12:00:00	SPY	ETF	100.74	100.87	100.31	100.45	2830300.0
2003-08-19 13:00:00	SPY	ETF	100.44	100.54	100.29	100.47	2272800.0
2003-08-19 14:00:00	SPY	ETF	100.47	100.53	100.0	100.2	4019300.0
2003-08-19 15:00:00	SPY	ETF	100.22	100.85	100.15	100.82	4909300.0
2003-08-19 16:00:00	SPY	ETF	100.83	100.9	100.68	100.7	1397800.0
2003-08-19 17:00:00	SPY	ETF	100.72	100.72	100.66	100.66	317800.0
2003-08-19 18:00:00	SPY	ETF	100.69	100.71	100.69	100.7	9400.0
2003-08-19 19:00:00	SPY	ETF	100.67	100.7	100.67	100.7	3400.0
2003-08-19 08:00:00	QQQ	ETF	32.07	32.15	32.06	32.13	182300.0
2003-08-19 09:00:00	QQQ	ETF	32.12	32.171	31.97	32.01	10413900.0
2003-08-19 10:00:00	QQQ	ETF	32.01	32.27	31.846	32.25	14647200.0
2003-08-19 11:00:00	QQQ	ETF	32.253	32.27	32.1	32.23	6866200.0
2003-08-19 12:00:00	QQQ	ETF	32.221	32.312	32.09	32.154	6651500.0
2003-08-19 13:00:00	QQQ	ETF	32.152	32.23	32.11	32.171	3432700.0
2003-08-19 14:00:00	QQQ	ETF	32.19	32.22	32.004	32.09	5088100.0
2003-08-19 15:00:00	QQQ	ETF	32.09	32.37	32.07	32.36	9136400.0
2003-08-19 16:00:00	QQQ	ETF	32.36	32.4	32.18	32.19	3589700.0
2003-08-19 17:00:00	QQQ	ETF	32.2	32.3	32.16	32.199	240300.0
2003-08-19 18:00:00	QQQ	ETF	32.2	32.21	32.17	32.2	96200.0
2003-08-19 19:00:00	QQQ	ETF	32.18	32.22	32.18	32.19	12900.0
2003-08-19 09:00:00	IWM	ETF	48.2	48.425	48.145	48.155	884000.0
2003-08-19 10:00:00	IWM	ETF	48.15	48.425	48.05	48.405	803400.0
2003-08-19 11:00:00	IWM	ETF	48.42	48.485	48.295	48.475	650800.0
2003-08-19 12:00:00	IWM	ETF	48.475	48.535	48.365	48.38	390000.0
2003-08-19 13:00:00	IWM	ETF	48.375	48.475	48.365	48.46	340400.0
2003-08-19 14:00:00	IWM	ETF	48.46	48.5	48.355	48.4	513200.0
2003-08-19 15:00:00	IWM	ETF	48.415	48.83	48.4	48.83	1306800.0
2003-08-19 16:00:00	IWM	ETF	48.83	48.955	48.78	48.925	232600.0
2003-08-19 08:00:00	DIA	ETF	94.41	94.54	94.31	94.5	5900.0
2003-08-19 09:00:00	DIA	ETF	94.48	94.52	94.047	94.09	1184200.0
2003-08-19 10:00:00	DIA	ETF	94.1	94.61	93.9	94.6	1071800.0
2003-08-19 11:00:00	DIA	ETF	94.57	94.57	94.27	94.43	578100.0
2003-08-19 12:00:00	DIA	ETF	94.38	94.49	93.98	94.12	754800.0
2003-08-19 13:00:00	DIA	ETF	94.11	94.22	93.94	94.1	830500.0
2003-08-19 14:00:00	DIA	ETF	94.038	94.12	93.62	93.83	1039500.0
2003-08-19 15:00:00	DIA	ETF	93.84	94.49	93.78	94.46	958000.0
2003-08-19 16:00:00	DIA	ETF	94.45	94.49	94.21	94.23	85400.0
2003-08-19 17:00:00	DIA	ETF	94.25	94.25	94.21	94.25	2200.0
2003-08-19 19:00:00	DIA	ETF	94.38	94.38	94.38	94.38	700.0
2003-08-19 09:00:00	TLT	ETF	82.55	82.69	82.5	82.59	83500.0
2003-08-19 10:00:00	TLT	ETF	82.64	83.0	82.55	82.91	127100.0
2003-08-19 11:00:00	TLT	ETF	82.8	83.05	82.71	83.0	146500.0
2003-08-19 12:00:00	TLT	ETF	83.05	83.6	83.04	83.36	212000.0
2003-08-19 13:00:00	TLT	ETF	83.35	83.4	83.16	83.28	163000.0
2003-08-19 14:00:00	TLT	ETF	83.33	83.59	83.28	83.57	162200.0
2003-08-19 15:00:00	TLT	ETF	83.53	83.6	83.43	83.59	96400.0

> showing 50 of 431 rows — these rows as CSV

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