PREVIEW / etf_daily / 2006-09-19

all etf daily files

  file:    by_date/etf_daily/2006/2006-09-19.parquet
  size:    18 KB
  rows:    362

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-09-19	SPY	ETF	132.12	132.13	131.07	131.81	92089100.0
2006-09-19	QQQ	ETF	40.24	40.25	39.52	39.85	159077217.0
2006-09-19	IWM	ETF	72.71	72.74	71.15	72.32	64200600.0
2006-09-19	DIA	ETF	115.55	115.56	114.68	115.34	8697300.0
2006-09-19	GLD	ETF	58.02	58.11	56.84	56.92	5287000.0
2006-09-19	TLT	ETF	87.86	88.3	87.84	88.3	1229600.0
2006-09-19	AAA	ETF	56.8	57.08	56.5	56.7	16400.0
2006-09-19	ADRE	ETF	32.6	32.6	31.59	31.84	371879.0
2006-09-19	AFK	ETF	25.03	25.08	24.99	25.0004	3800.0
2006-09-19	AGG	ETF	99.47	99.57	99.4	99.46	133100.0
2006-09-19	AIQ	ETF	41.8	42.2	40.2	41.0	27900.0
2006-09-19	AIS	ETF	1.11	1.21	1.11	1.16	243300.0
2006-09-19	ARB	ETF	38.0	38.04	37.16	37.64	124900.0
2006-09-19	BAB	ETF	80.4	80.4	78.91	79.84	65700.0
2006-09-19	BBC	ETF	10.87	10.87	10.2	10.31	150800.0
2006-09-19	BBH	ETF	59.5833	59.6233	59.1667	59.52	877200.0
2006-09-19	BITS	ETF	28.0804	28.2	27.44	27.64	9033.0
2006-09-19	BNE	ETF	14.47	14.59	14.13	14.41	104800.0
2006-09-19	BTF	ETF	94.45	94.45	94.0	94.19999999999999	4240.0
2006-09-19	CBON	ETF	32.53	32.64	32.29	32.4	98654.0
2006-09-19	CDL	ETF	9.43	9.45	9.21	9.36	223800.0
2006-09-19	CEF	ETF	8.09	8.2	7.95	7.97	583600.0
2006-09-19	CEW	ETF	25.28	25.31	25.28	25.31	2300.0
2006-09-19	CFO	ETF	9.85	9.85	9.8	9.8	17800.0
2006-09-19	CGO	ETF	15.45	15.5	15.1	15.25	36200.0
2006-09-19	CHB	ETF	7.02	7.27	6.7	7.08	1837800.0
2006-09-19	CHI	ETF	19.49	19.49	19.38	19.41	139500.0
2006-09-19	CHIC	ETF	26.78	26.85	26.05	26.55	628909.0
2006-09-19	CHY	ETF	16.72	16.88	16.63	16.67	151100.0
2006-09-19	CIL	ETF	25.58	25.58	25.55	25.55	1500.0
2006-09-19	CIZ	ETF	22.25	22.25	22.0	22.0	5000.0
2006-09-19	CN	ETF	35.79	35.79	34.75	35.17	32000.0
2006-09-19	CNXT	ETF	1.9	1.9	1.8	1.83	10078403.0
2006-09-19	COMB	ETF	10.0	10.0	10.0	10.0	300.0
2006-09-19	CPI	ETF	24.35	24.5	24.04	24.5	3500.0
2006-09-19	CPST	ETF	1.52	1.54	1.4	1.44	1855844.0
2006-09-19	CSA	ETF	20.8	20.8	20.4	20.45	13800.0
2006-09-19	CSB	ETF	28.34	28.48	28.31	28.38	12500.0
2006-09-19	CSQ	ETF	14.65	14.69	14.55	14.65	449700.0
2006-09-19	CTEC	ETF	62.599999999999994	64.19999999999999	60.849999999999994	61.849999999999994	9017.800000000001
2006-09-19	CYB	ETF	6.48	6.69	6.48	6.69	56000.0
2006-09-19	DBC	ETF	23.6	23.68	23.12	23.21	490700.0
2006-09-19	DBV	ETF	25.0	25.05	24.95	24.95	7000.0
2006-09-19	DDM	ETF	6.4583	6.4583	6.3767	6.45	404400.0
2006-09-19	DES	ETF	17.93	17.9433	17.72	17.9067	79500.0
2006-09-19	DEW	ETF	54.5	54.5	53.97	54.13	11100.0
2006-09-19	DFE	ETF	55.05	55.05	54.71	54.91	12600.0
2006-09-19	DFJ	ETF	49.63	49.63	49.09	49.09	600.0
2006-09-19	DGT	ETF	70.65	70.65	70.18	70.45	4100.0
2006-09-19	DHS	ETF	54.45	54.55	54.29	54.55	28400.0

> showing 50 of 362 rows — these rows as CSV

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