PREVIEW / etf_1hour / 2003-12-23

all etf 1-hour files

  file:    by_date/etf_1hour/2003/2003-12-23.parquet
  size:    19 KB
  rows:    509

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-23 08:00:00	SPY	ETF	109.56	109.64	109.51	109.54	32700.0
2003-12-23 09:00:00	SPY	ETF	109.54	109.7	109.38	109.56	5444600.0
2003-12-23 10:00:00	SPY	ETF	109.57	109.95	109.55	109.72	4090100.0
2003-12-23 11:00:00	SPY	ETF	109.7	109.83	109.67	109.75	3141300.0
2003-12-23 12:00:00	SPY	ETF	109.73	109.82	109.69	109.77	1928500.0
2003-12-23 13:00:00	SPY	ETF	109.78	109.79	109.5	109.7	2419400.0
2003-12-23 14:00:00	SPY	ETF	109.7	109.76	109.38	109.52	2437900.0
2003-12-23 15:00:00	SPY	ETF	109.51	109.87	109.47	109.79	2899400.0
2003-12-23 16:00:00	SPY	ETF	109.79	109.83	109.44	109.55	918600.0
2003-12-23 17:00:00	SPY	ETF	109.55	109.73	109.5	109.52	38400.0
2003-12-23 18:00:00	SPY	ETF	109.52	109.52	109.43	109.48	8600.0
2003-12-23 19:00:00	SPY	ETF	109.46	109.46	109.35	109.41	800.0
2003-12-23 08:00:00	QQQ	ETF	35.58	35.61	35.55	35.6	91600.0
2003-12-23 09:00:00	QQQ	ETF	35.59	35.76	35.53	35.707	9350600.0
2003-12-23 10:00:00	QQQ	ETF	35.709	35.98	35.709	35.8	13617200.0
2003-12-23 11:00:00	QQQ	ETF	35.8	35.948	35.79	35.86	10538200.0
2003-12-23 12:00:00	QQQ	ETF	35.87	35.93	35.82	35.92	3623500.0
2003-12-23 13:00:00	QQQ	ETF	35.93	35.93	35.83	35.88	3427500.0
2003-12-23 14:00:00	QQQ	ETF	35.88	35.92	35.73	35.84	5570000.0
2003-12-23 15:00:00	QQQ	ETF	35.84	36.02	35.81	35.96	9545400.0
2003-12-23 16:00:00	QQQ	ETF	35.93	35.97	35.8	35.86	1901100.0
2003-12-23 17:00:00	QQQ	ETF	35.87	35.89	35.823	35.86	62000.0
2003-12-23 18:00:00	QQQ	ETF	35.86	35.86	35.836	35.86	31700.0
2003-12-23 19:00:00	QQQ	ETF	35.86	35.86	35.82	35.82	11100.0
2003-12-23 09:00:00	IWM	ETF	54.72	54.9455	54.62	54.778	400600.0
2003-12-23 10:00:00	IWM	ETF	54.8	55.025	54.79	54.885	1841000.0
2003-12-23 11:00:00	IWM	ETF	54.885	54.955	54.825	54.865	634400.0
2003-12-23 12:00:00	IWM	ETF	54.865	54.9	54.81	54.845	309600.0
2003-12-23 13:00:00	IWM	ETF	54.805	54.85	54.755	54.79	280200.0
2003-12-23 14:00:00	IWM	ETF	54.825	54.88	54.63	54.775	469000.0
2003-12-23 15:00:00	IWM	ETF	54.786	55.195	54.75	55.17	971000.0
2003-12-23 16:00:00	IWM	ETF	55.175	55.245	55.105	55.105	104000.0
2003-12-23 18:00:00	IWM	ETF	55.115	55.115	55.115	55.115	2000.0
2003-12-23 08:00:00	DIA	ETF	103.48	103.57	103.44	103.49	11500.0
2003-12-23 09:00:00	DIA	ETF	103.48	103.67	103.354	103.53	1027000.0
2003-12-23 10:00:00	DIA	ETF	103.532	103.87	103.49	103.58	1560600.0
2003-12-23 11:00:00	DIA	ETF	103.6	103.72	103.52	103.57	499100.0
2003-12-23 12:00:00	DIA	ETF	103.6	103.67	103.36	103.5	1813600.0
2003-12-23 13:00:00	DIA	ETF	103.51	103.54	103.3	103.41	356300.0
2003-12-23 14:00:00	DIA	ETF	103.42	103.51	103.07	103.23	848800.0
2003-12-23 15:00:00	DIA	ETF	103.23	103.6	103.2	103.48	817000.0
2003-12-23 16:00:00	DIA	ETF	103.48	103.55	103.27	103.332	390900.0
2003-12-23 17:00:00	DIA	ETF	103.339	103.4	103.339	103.39	2800.0
2003-12-23 18:00:00	DIA	ETF	103.34	103.34	103.34	103.34	100.0
2003-12-23 19:00:00	DIA	ETF	103.22	103.35	103.22	103.25	2300.0
2003-12-23 09:00:00	TLT	ETF	86.53	86.64	86.36	86.5	60900.0
2003-12-23 10:00:00	TLT	ETF	86.48	86.7	86.46	86.46	100900.0
2003-12-23 11:00:00	TLT	ETF	86.46	86.58	86.42	86.47	87400.0
2003-12-23 12:00:00	TLT	ETF	86.47	86.52	86.27	86.27	83900.0
2003-12-23 13:00:00	TLT	ETF	86.33	86.37	86.02	86.12	38600.0

> showing 50 of 509 rows — these rows as CSV

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