PREVIEW / etf_daily / 2006-01-04

all etf daily files

  file:    by_date/etf_daily/2006/2006-01-04.parquet
  size:    16 KB
  rows:    300

schema

  date         DATE
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

date	symbol	asset_type	open	high	low	close	volume
2006-01-04	SPY	ETF	126.86	127.49	126.7	127.3	51899600.0
2006-01-04	QQQ	ETF	41.41	41.74	41.3158	41.74	92780152.0
2006-01-04	IWM	ETF	68.11	68.65	67.88	68.42	29795200.0
2006-01-04	DIA	ETF	108.43	108.86	108.27	108.74	5844500.0
2006-01-04	GLD	ETF	52.87	53.34	52.62	53.3	5287900.0
2006-01-04	TLT	ETF	91.54	92.07	91.42	92.0	387600.0
2006-01-04	AAA	ETF	55.86	56.37	55.86	56.3	1200.0
2006-01-04	ADRE	ETF	120.95	120.95	119.77	120.5	38104.0
2006-01-04	AFK	ETF	25.2	25.27	25.19	25.19	10200.0
2006-01-04	AGG	ETF	100.69	100.88	100.61	100.88	284500.0
2006-01-04	AIQ	ETF	28.5	29.75	28.25	29.2	19080.0
2006-01-04	AIS	ETF	1.55	1.68	1.55	1.59	331000.0
2006-01-04	AOM	ETF	4.48	4.48	4.35	4.4	6200.0
2006-01-04	ARB	ETF	38.8	38.85	38.36	38.47	279500.0
2006-01-04	BAB	ETF	59.06	59.73	59.06	59.4	27800.0
2006-01-04	BBC	ETF	14.0	15.3	14.0	15.0	356600.0
2006-01-04	BBH	ETF	67.9933	68.7667	67.7733	68.5	2364000.0
2006-01-04	BCM	ETF	67.39	67.94	67.2	67.94	30000.0
2006-01-04	BITS	ETF	14.44	15.12	14.28	14.8	3578.0
2006-01-04	BKF	ETF	18.7	19.06	18.5	18.83	44900.0
2006-01-04	BNE	ETF	15.19	15.19	14.74	14.77	163600.0
2006-01-04	BRF	ETF	15.19	15.33	15.19	15.32	9900.0
2006-01-04	BTF	ETF	85.0	85.445	84.04999999999998	84.49999999999999	2380.0
2006-01-04	CBON	ETF	32.6992	32.6992	32.25	32.38	7311.0
2006-01-04	CDL	ETF	13.55	13.6	13.45	13.5	352300.0
2006-01-04	CEF	ETF	7.09	7.19	7.01	7.1	699700.0
2006-01-04	CEW	ETF	26.2	26.2	26.05	26.05	2400.0
2006-01-04	CFO	ETF	9.85	9.85	9.85	9.85	1500.0
2006-01-04	CGO	ETF	14.25	14.25	14.1	14.21	38000.0
2006-01-04	CHB	ETF	13.49	13.6	13.37	13.46	647500.0
2006-01-04	CHI	ETF	19.89	20.44	19.85	20.34	83200.0
2006-01-04	CHIC	ETF	21.42	21.68	21.19	21.36	738914.0
2006-01-04	CHIR	ETF	44.7801	44.85	44.58	44.79	752980.0
2006-01-04	CHY	ETF	15.93	16.08	15.92	16.05	114500.0
2006-01-04	CIL	ETF	25.28	25.28	25.28	25.28	2000.0
2006-01-04	CIZ	ETF	22.7	22.7	22.7	22.7	200.0
2006-01-04	CN	ETF	33.1	33.35	33.1	33.2	27300.0
2006-01-04	CNXT	ETF	2.37	2.58	2.36	2.58	17465918.0
2006-01-04	COMB	ETF	8.21	8.21	8.21	8.21	4100.0
2006-01-04	CPI	ETF	27.8	27.8	27.5	27.6	1100.0
2006-01-04	CPST	ETF	3.03	3.3101	3.03	3.24	4400114.0
2006-01-04	CSA	ETF	17.4	17.49	17.37	17.39	27800.0
2006-01-04	CSB	ETF	32.45	32.75	32.4	32.7	10500.0
2006-01-04	CSQ	ETF	13.7	13.87	13.67	13.82	474300.0
2006-01-04	CTEC	ETF	50.0	52.0	50.0	51.65	9180.0
2006-01-04	CURE	ETF	0.0338	0.0338	0.0262	0.03	4217240.0
2006-01-04	CYB	ETF	3.62	3.62	3.62	3.62	500.0
2006-01-04	DGT	ETF	66.25	66.75	66.25	66.6	4700.0
2006-01-04	DIG	ETF	16.8125	16.825	16.8125	16.8125	2080.0
2006-01-04	DIV	ETF	12.15	12.37	12.15	12.34	40400.0

> showing 50 of 300 rows — these rows as CSV

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