PREVIEW / etf_1hour / 2003-11-20

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-11-20.parquet
  size:    19 KB
  rows:    487

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-11-20 08:00:00	SPY	ETF	104.21	104.37	104.21	104.37	57000.0
2003-11-20 09:00:00	SPY	ETF	104.39	104.41	103.76	104.35	9617500.0
2003-11-20 10:00:00	SPY	ETF	104.35	104.85	104.32	104.72	7779500.0
2003-11-20 11:00:00	SPY	ETF	104.73	104.98	104.57	104.89	4927300.0
2003-11-20 12:00:00	SPY	ETF	104.88	105.13	104.68	105.04	2991200.0
2003-11-20 13:00:00	SPY	ETF	105.05	105.24	104.95	105.04	3289300.0
2003-11-20 14:00:00	SPY	ETF	105.03	105.12	104.63	104.66	4328300.0
2003-11-20 15:00:00	SPY	ETF	104.66	104.68	103.83	103.9	12247700.0
2003-11-20 16:00:00	SPY	ETF	103.88	103.94	103.72	103.87	5299000.0
2003-11-20 17:00:00	SPY	ETF	103.88	103.88	103.78	103.8	43300.0
2003-11-20 18:00:00	SPY	ETF	103.84	103.89	103.82	103.82	22400.0
2003-11-20 19:00:00	SPY	ETF	103.82	103.94	103.8	103.94	4700.0
2003-11-20 08:00:00	QQQ	ETF	33.98	34.06	33.95	34.05	305200.0
2003-11-20 09:00:00	QQQ	ETF	34.04	34.19	33.81	34.15	19460800.0
2003-11-20 10:00:00	QQQ	ETF	34.15	34.51	34.14	34.46	21609600.0
2003-11-20 11:00:00	QQQ	ETF	34.462	34.62	34.364	34.6	14765500.0
2003-11-20 12:00:00	QQQ	ETF	34.6	34.68	34.46	34.62	10793200.0
2003-11-20 13:00:00	QQQ	ETF	34.62	34.68	34.53	34.57	5918600.0
2003-11-20 14:00:00	QQQ	ETF	34.57	34.62	34.32	34.33	11480100.0
2003-11-20 15:00:00	QQQ	ETF	34.33	34.38	33.9	33.96	26053200.0
2003-11-20 16:00:00	QQQ	ETF	33.97	33.97	33.85	33.88	3576600.0
2003-11-20 17:00:00	QQQ	ETF	33.89	33.9	33.861	33.9	128800.0
2003-11-20 18:00:00	QQQ	ETF	33.9	33.92	33.88	33.91	44500.0
2003-11-20 19:00:00	QQQ	ETF	33.91	33.96	33.9	33.96	16600.0
2003-11-20 08:00:00	IWM	ETF	52.145	52.145	52.145	52.145	400.0
2003-11-20 09:00:00	IWM	ETF	52.13	52.304	52.001	52.275	812600.0
2003-11-20 10:00:00	IWM	ETF	52.296	52.755	52.2	52.675	869400.0
2003-11-20 11:00:00	IWM	ETF	52.75	52.75	52.525	52.655	601400.0
2003-11-20 12:00:00	IWM	ETF	52.67	52.795	52.52	52.75	299800.0
2003-11-20 13:00:00	IWM	ETF	52.78	52.87	52.64	52.675	312800.0
2003-11-20 14:00:00	IWM	ETF	52.675	52.71	52.285	52.285	808600.0
2003-11-20 15:00:00	IWM	ETF	52.293	52.345	51.89	52.045	2348000.0
2003-11-20 16:00:00	IWM	ETF	52.016	52.2	52.0	52.16	469400.0
2003-11-20 08:00:00	DIA	ETF	96.86	96.93	96.85	96.89	10000.0
2003-11-20 09:00:00	DIA	ETF	96.97	97.07	96.39	97.01	1159500.0
2003-11-20 10:00:00	DIA	ETF	97.02	97.29	96.97	97.17	795000.0
2003-11-20 11:00:00	DIA	ETF	97.17	97.44	97.04	97.37	525100.0
2003-11-20 12:00:00	DIA	ETF	97.39	97.55	97.15	97.48	468000.0
2003-11-20 13:00:00	DIA	ETF	97.49	97.7	97.48	97.54	523600.0
2003-11-20 14:00:00	DIA	ETF	97.54	97.61	97.2	97.2	343100.0
2003-11-20 15:00:00	DIA	ETF	97.22	97.28	96.556	96.65	1851000.0
2003-11-20 16:00:00	DIA	ETF	96.66	96.66	96.48	96.56	88400.0
2003-11-20 17:00:00	DIA	ETF	96.55	96.55	96.42	96.42	3100.0
2003-11-20 09:00:00	TLT	ETF	86.25	86.28	86.0	86.1	55800.0
2003-11-20 10:00:00	TLT	ETF	86.2	86.2	85.8	85.85	66900.0
2003-11-20 11:00:00	TLT	ETF	85.95	85.99	85.82	85.82	13400.0
2003-11-20 12:00:00	TLT	ETF	85.96	86.18	85.91	85.99	23900.0
2003-11-20 13:00:00	TLT	ETF	86.03	86.2	86.03	86.15	21000.0
2003-11-20 14:00:00	TLT	ETF	86.19	86.377	86.17	86.35	50800.0
2003-11-20 15:00:00	TLT	ETF	86.38	86.49	86.33	86.45	111000.0

> showing 50 of 487 rows — these rows as CSV

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