PREVIEW / etf_1hour / 2003-12-29

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-12-29.parquet
  size:    19 KB
  rows:    507

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-29 08:00:00	SPY	ETF	110.11	110.11	110.05	110.07	53600.0
2003-12-29 09:00:00	SPY	ETF	110.04	110.34	110.04	110.34	2760900.0
2003-12-29 10:00:00	SPY	ETF	110.33	110.54	110.23	110.33	4187300.0
2003-12-29 11:00:00	SPY	ETF	110.33	110.45	110.11	110.44	3047000.0
2003-12-29 12:00:00	SPY	ETF	110.43	110.49	110.36	110.44	1128600.0
2003-12-29 13:00:00	SPY	ETF	110.4	110.7	110.39	110.54	1775500.0
2003-12-29 14:00:00	SPY	ETF	110.57	110.77	110.54	110.64	1439600.0
2003-12-29 15:00:00	SPY	ETF	110.62	111.17	110.61	111.15	3425900.0
2003-12-29 16:00:00	SPY	ETF	111.15	111.27	111.07	111.07	1828400.0
2003-12-29 17:00:00	SPY	ETF	111.08	111.15	111.06	111.15	32100.0
2003-12-29 18:00:00	SPY	ETF	111.13	111.14	111.08	111.08	40100.0
2003-12-29 19:00:00	SPY	ETF	111.12	111.12	111.12	111.12	400.0
2003-12-29 08:00:00	QQQ	ETF	36.04	36.08	36.02	36.03	67100.0
2003-12-29 09:00:00	QQQ	ETF	36.04	36.16	36.01	36.156	6196900.0
2003-12-29 10:00:00	QQQ	ETF	36.155	36.26	36.1	36.15	13091600.0
2003-12-29 11:00:00	QQQ	ETF	36.14	36.21	36.07	36.19	5345000.0
2003-12-29 12:00:00	QQQ	ETF	36.194	36.23	36.15	36.16	3222600.0
2003-12-29 13:00:00	QQQ	ETF	36.15	36.27	36.15	36.22	5259300.0
2003-12-29 14:00:00	QQQ	ETF	36.23	36.3	36.21	36.27	4961200.0
2003-12-29 15:00:00	QQQ	ETF	36.27	36.51	36.26	36.49	17254200.0
2003-12-29 16:00:00	QQQ	ETF	36.49	36.53	36.4	36.45	4893200.0
2003-12-29 17:00:00	QQQ	ETF	36.46	36.481	36.44	36.47	77700.0
2003-12-29 18:00:00	QQQ	ETF	36.47	36.49	36.45	36.45	15500.0
2003-12-29 19:00:00	QQQ	ETF	36.45	36.46	36.45	36.45	3900.0
2003-12-29 09:00:00	IWM	ETF	55.39	55.845	55.39	55.825	767400.0
2003-12-29 10:00:00	IWM	ETF	55.855	56.0	55.825	55.8865	342200.0
2003-12-29 11:00:00	IWM	ETF	55.8835	55.935	55.76	55.915	768600.0
2003-12-29 12:00:00	IWM	ETF	55.915	55.945	55.885	55.935	130200.0
2003-12-29 13:00:00	IWM	ETF	55.935	56.075	55.925	55.945	530400.0
2003-12-29 14:00:00	IWM	ETF	55.95	56.075	55.915	55.95	648600.0
2003-12-29 15:00:00	IWM	ETF	55.95	56.125	55.915	56.1	792600.0
2003-12-29 16:00:00	IWM	ETF	56.1	56.125	56.01	56.075	374200.0
2003-12-29 17:00:00	IWM	ETF	56.005	56.005	56.005	56.005	400.0
2003-12-29 08:00:00	DIA	ETF	103.6	103.62	103.57	103.6	9700.0
2003-12-29 09:00:00	DIA	ETF	103.63	103.82	103.62	103.81	673200.0
2003-12-29 10:00:00	DIA	ETF	103.8	103.98	103.72	103.76	1145800.0
2003-12-29 11:00:00	DIA	ETF	103.77	103.92	103.58	103.9	367500.0
2003-12-29 12:00:00	DIA	ETF	103.9	103.97	103.85	103.87	302400.0
2003-12-29 13:00:00	DIA	ETF	103.87	104.14	103.85	104.08	629400.0
2003-12-29 14:00:00	DIA	ETF	104.08	104.25	104.06	104.17	554000.0
2003-12-29 15:00:00	DIA	ETF	104.16	104.65	104.13	104.62	1711600.0
2003-12-29 16:00:00	DIA	ETF	104.62	104.76	104.52	104.58	425600.0
2003-12-29 17:00:00	DIA	ETF	104.56	104.63	104.54	104.63	9000.0
2003-12-29 19:00:00	DIA	ETF	104.61	104.66	104.61	104.66	300.0
2003-12-29 09:00:00	TLT	ETF	86.7	86.77	86.64	86.68	14700.0
2003-12-29 10:00:00	TLT	ETF	86.67	86.67	86.5	86.55	25200.0
2003-12-29 11:00:00	TLT	ETF	86.53	86.53	86.32	86.42	34400.0
2003-12-29 12:00:00	TLT	ETF	86.46	86.5	86.35	86.35	5100.0
2003-12-29 13:00:00	TLT	ETF	86.39	86.53	86.39	86.47	15500.0
2003-12-29 14:00:00	TLT	ETF	86.43	86.43	86.18	86.24	51300.0

> showing 50 of 507 rows — these rows as CSV

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