PREVIEW / etf_daily / 2006-01-18

all etf daily files

  file:    by_date/etf_daily/2006/2006-01-18.parquet
  size:    16 KB
  rows:    296

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-18	SPY	ETF	127.58	128.9	127.16	127.82	75067600.0
2006-01-18	QQQ	ETF	42.04	42.46	42.02	42.21	122426531.0
2006-01-18	IWM	ETF	69.39	70.0	69.3	69.88	30545300.0
2006-01-18	DIA	ETF	108.4	108.9	108.21	108.6	4962200.0
2006-01-18	GLD	ETF	54.64	54.73	54.01	54.07	4565200.0
2006-01-18	TLT	ETF	92.76	92.77	92.12	92.41	622100.0
2006-01-18	AAA	ETF	54.41	54.55	54.17	54.41	3700.0
2006-01-18	ADRE	ETF	120.0	120.446	119.04	120.3	33400.0
2006-01-18	AFK	ETF	25.31	25.38	25.31	25.32	3300.0
2006-01-18	AGG	ETF	101.35	101.35	101.0	101.2	142600.0
2006-01-18	AIQ	ETF	25.45	26.1	24.55	25.3	22180.0
2006-01-18	AIS	ETF	1.38	1.5	1.36	1.36	1349300.0
2006-01-18	AOM	ETF	5.34	5.7	5.23	5.62	62000.0
2006-01-18	ARB	ETF	39.0	39.63	38.91	39.5	180600.0
2006-01-18	BAB	ETF	56.71	56.86	56.3	56.8	35600.0
2006-01-18	BBC	ETF	15.25	16.2	15.25	15.7	247200.0
2006-01-18	BBH	ETF	66.7	67.1	66.5	66.9333	1352400.0
2006-01-18	BCM	ETF	68.9	68.94	67.9	68.56	44800.0
2006-01-18	BITS	ETF	15.6	15.8	15.0	15.8	6015.0
2006-01-18	BKF	ETF	17.1	17.15	15.57	16.71	210000.0
2006-01-18	BNE	ETF	14.13	14.35	13.99	14.28	140500.0
2006-01-18	BRF	ETF	15.4	15.41	15.21	15.41	13400.0
2006-01-18	BTF	ETF	85.0	85.0	84.74999999999999	84.8	1560.0
2006-01-18	CBON	ETF	32.65	32.77	32.38	32.56	62629.0
2006-01-18	CDL	ETF	12.92	13.04	12.91	12.99	103700.0
2006-01-18	CEF	ETF	7.26	7.27	7.0	7.01	656000.0
2006-01-18	CEW	ETF	26.37	26.37	26.37	26.37	200.0
2006-01-18	CGO	ETF	14.3	14.49	14.1	14.3	47700.0
2006-01-18	CHB	ETF	13.0	13.55	12.9	13.13	1080100.0
2006-01-18	CHI	ETF	19.92	20.39	19.92	20.3	121200.0
2006-01-18	CHIC	ETF	19.65	20.11	19.42	19.5	448285.0
2006-01-18	CHIR	ETF	44.76	44.85	44.7	44.8101	772556.0
2006-01-18	CHY	ETF	16.1	16.2	16.08	16.16	73200.0
2006-01-18	CIL	ETF	25.35	25.38	25.35	25.38	400.0
2006-01-18	CN	ETF	34.15	34.48	33.8	33.8	49800.0
2006-01-18	CNXT	ETF	3.04	3.21	3.01	3.2099	26536296.0
2006-01-18	COMB	ETF	8.35	8.35	8.35	8.35	1400.0
2006-01-18	CPI	ETF	29.5	29.72	29.5	29.71	1500.0
2006-01-18	CPST	ETF	3.47	3.51	3.27	3.43	3951328.0
2006-01-18	CSA	ETF	17.65	17.65	17.5	17.5	11300.0
2006-01-18	CSB	ETF	31.91	31.91	31.6	31.8	11800.0
2006-01-18	CSQ	ETF	13.98	14.14	13.95	13.96	474900.0
2006-01-18	CTEC	ETF	49.599999999999994	50.099999999999994	49.4	49.699999999999996	16469.600000000002
2006-01-18	CURE	ETF	0.03	0.0375	0.03	0.0375	7553592.0
2006-01-18	CYB	ETF	4.04	4.52	4.04	4.5	87900.0
2006-01-18	DGT	ETF	66.6	66.6	66.05	66.26	13600.0
2006-01-18	DIG	ETF	16.9375	16.9625	16.875	16.875	1040.0
2006-01-18	DIV	ETF	12.49	12.5	12.43	12.47	13800.0
2006-01-18	DRIV	ETF	33.2	33.2	31.83	32.35	1220171.0
2006-01-18	DSI	ETF	6.01	6.015	6.0	6.015	8800.0

> showing 50 of 296 rows — these rows as CSV

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