PREVIEW / etf_1hour / 2003-12-16

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-12-16.parquet
  size:    19 KB
  rows:    501

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-12-16 08:00:00	SPY	ETF	107.47	107.59	107.47	107.57	17300.0
2003-12-16 09:00:00	SPY	ETF	107.56	107.85	107.55	107.78	4552000.0
2003-12-16 10:00:00	SPY	ETF	107.79	107.99	107.59	107.68	6812800.0
2003-12-16 11:00:00	SPY	ETF	107.7	107.87	107.52	107.79	4369800.0
2003-12-16 12:00:00	SPY	ETF	107.79	107.81	107.59	107.77	2242400.0
2003-12-16 13:00:00	SPY	ETF	107.78	107.96	107.67	107.84	3036400.0
2003-12-16 14:00:00	SPY	ETF	107.84	108.25	107.74	108.2	4202100.0
2003-12-16 15:00:00	SPY	ETF	108.2	108.31	108.02	108.17	4966200.0
2003-12-16 16:00:00	SPY	ETF	108.18	108.22	108.1	108.17	990500.0
2003-12-16 17:00:00	SPY	ETF	108.18	108.19	108.15	108.17	110100.0
2003-12-16 18:00:00	SPY	ETF	108.17	108.2	108.16	108.2	4800.0
2003-12-16 19:00:00	SPY	ETF	108.16	108.16	108.16	108.16	300.0
2003-12-16 08:00:00	QQQ	ETF	34.71	34.74	34.61	34.72	298600.0
2003-12-16 09:00:00	QQQ	ETF	34.72	34.91	34.63	34.75	11433600.0
2003-12-16 10:00:00	QQQ	ETF	34.74	34.93	34.55	34.61	15792600.0
2003-12-16 11:00:00	QQQ	ETF	34.61	34.68	34.42	34.621	13389200.0
2003-12-16 12:00:00	QQQ	ETF	34.62	34.65	34.46	34.61	5320100.0
2003-12-16 13:00:00	QQQ	ETF	34.608	34.77	34.52	34.65	7512300.0
2003-12-16 14:00:00	QQQ	ETF	34.65	34.96	34.55	34.91	14514100.0
2003-12-16 15:00:00	QQQ	ETF	34.91	35.023	34.73	34.9	15477300.0
2003-12-16 16:00:00	QQQ	ETF	34.89	34.9	34.85	34.86	1125300.0
2003-12-16 17:00:00	QQQ	ETF	34.86	34.89	34.85	34.88	83100.0
2003-12-16 18:00:00	QQQ	ETF	34.89	34.92	34.88	34.91	47400.0
2003-12-16 19:00:00	QQQ	ETF	34.93	34.94	34.92	34.92	6500.0
2003-12-16 09:00:00	IWM	ETF	53.32	53.385	52.945	52.995	752000.0
2003-12-16 10:00:00	IWM	ETF	52.99	53.225	52.83	52.89	1179400.0
2003-12-16 11:00:00	IWM	ETF	52.9	53.01	52.625	52.95	1419800.0
2003-12-16 12:00:00	IWM	ETF	52.975	52.975	52.795	52.875	505200.0
2003-12-16 13:00:00	IWM	ETF	52.875	53.185	52.82	53.105	697800.0
2003-12-16 14:00:00	IWM	ETF	53.11	53.5	53.05	53.4	1620200.0
2003-12-16 15:00:00	IWM	ETF	53.365	53.585	53.225	53.5785	1472600.0
2003-12-16 16:00:00	IWM	ETF	53.565	53.575	53.115	53.115	282200.0
2003-12-16 18:00:00	IWM	ETF	53.5	53.5	53.5	53.5	1600.0
2003-12-16 08:00:00	DIA	ETF	100.46	100.5	100.46	100.49	2500.0
2003-12-16 09:00:00	DIA	ETF	100.59	100.95	100.57	100.84	806100.0
2003-12-16 10:00:00	DIA	ETF	100.84	101.03	100.75	100.83	1024300.0
2003-12-16 11:00:00	DIA	ETF	100.83	101.06	100.78	100.986	523800.0
2003-12-16 12:00:00	DIA	ETF	100.99	101.02	100.81	100.97	408700.0
2003-12-16 13:00:00	DIA	ETF	100.956	101.18	100.88	101.06	388800.0
2003-12-16 14:00:00	DIA	ETF	101.07	101.48	100.97	101.43	908500.0
2003-12-16 15:00:00	DIA	ETF	101.43	101.56	101.23	101.45	1677500.0
2003-12-16 16:00:00	DIA	ETF	101.43	101.5	101.392	101.47	184300.0
2003-12-16 17:00:00	DIA	ETF	101.5	101.5	101.46	101.49	2800.0
2003-12-16 18:00:00	DIA	ETF	101.5	101.5	101.5	101.5	200.0
2003-12-16 09:00:00	TLT	ETF	85.4	85.65	85.4	85.65	131300.0
2003-12-16 10:00:00	TLT	ETF	85.62	85.62	85.27	85.43	19000.0
2003-12-16 11:00:00	TLT	ETF	85.47	85.75	85.45	85.75	144300.0
2003-12-16 12:00:00	TLT	ETF	85.72	85.86	85.72	85.75	73300.0
2003-12-16 13:00:00	TLT	ETF	85.76	85.81	85.67	85.81	16500.0
2003-12-16 14:00:00	TLT	ETF	85.8	85.82	85.73	85.78	52100.0

> showing 50 of 501 rows — these rows as CSV

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