PREVIEW / etf_daily / 2006-08-16

all etf daily files

  file:    by_date/etf_daily/2006/2006-08-16.parquet
  size:    18 KB
  rows:    360

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-08-16	SPY	ETF	129.32	129.89	129.04	129.7	71737600.0
2006-08-16	QQQ	ETF	37.99	38.61	37.84	38.58	135470050.0
2006-08-16	IWM	ETF	69.87	70.52	69.49	70.42	46160700.0
2006-08-16	DIA	ETF	112.75	113.55	112.68	113.38	6681000.0
2006-08-16	GLD	ETF	62.63	62.89	62.24	62.49	3332900.0
2006-08-16	TLT	ETF	86.57	86.64	86.46	86.55	838900.0
2006-08-16	AAA	ETF	57.14	57.65	57.06	57.44	7500.0
2006-08-16	ADRE	ETF	32.92	33.02	32.7675	33.01	647646.0
2006-08-16	AFK	ETF	25.16	25.19	25.16	25.19	700.0
2006-08-16	AGG	ETF	99.05	99.05	98.9	98.93	188300.0
2006-08-16	AIQ	ETF	32.75	32.95	32.15	32.3	20380.0
2006-08-16	AIS	ETF	0.89	0.91	0.88	0.89	100000.0
2006-08-16	AOM	ETF	5.95	5.95	5.85	5.89	3100.0
2006-08-16	ARB	ETF	36.6	36.7	35.98	35.99	154500.0
2006-08-16	BAB	ETF	72.61	73.4	72.33	73.4	92500.0
2006-08-16	BBC	ETF	12.16	12.49	12.01	12.35	150400.0
2006-08-16	BBH	ETF	59.03	59.5467	58.36	59.5	1908900.0
2006-08-16	BITS	ETF	26.88	27.5996	26.16	26.4	35504.0
2006-08-16	BKF	ETF	4.05	4.16	4.0	4.1599	54100.0
2006-08-16	BNE	ETF	15.2	15.5	15.18	15.35	126100.0
2006-08-16	BRF	ETF	14.06	14.0708	14.06	14.06	13300.0
2006-08-16	BTF	ETF	90.5	90.99999999999999	90.5	90.99999999999999	1360.0
2006-08-16	CBON	ETF	33.35	33.58	32.97	33.33	41980.0
2006-08-16	CDL	ETF	8.71	8.8	8.71	8.75	308100.0
2006-08-16	CEF	ETF	8.97	9.14	8.92	8.94	304900.0
2006-08-16	CEW	ETF	25.95	25.95	25.95	25.95	1400.0
2006-08-16	CFO	ETF	9.95	9.95	9.95	9.95	200.0
2006-08-16	CGO	ETF	15.36	15.65	15.33	15.61	54400.0
2006-08-16	CHB	ETF	5.66	5.81	5.6	5.8	1173400.0
2006-08-16	CHI	ETF	20.18	20.28	20.16	20.23	102500.0
2006-08-16	CHIC	ETF	27.0	27.63	26.65	27.24	700382.0
2006-08-16	CHY	ETF	16.28	16.31	16.22	16.3	152600.0
2006-08-16	CIZ	ETF	21.8	21.85	21.8	21.85	500.0
2006-08-16	CN	ETF	37.47	38.08	37.47	38.0	35400.0
2006-08-16	CNXT	ETF	1.8	1.89	1.75	1.87	23331333.0
2006-08-16	COMB	ETF	9.93	9.93	9.79	9.874	26834.0
2006-08-16	CPST	ETF	1.87	1.93	1.85	1.92	948025.0
2006-08-16	CSA	ETF	18.65	18.8	18.5	18.54	61000.0
2006-08-16	CSB	ETF	26.9	26.9	26.54	26.77	10500.0
2006-08-16	CSQ	ETF	14.35	14.4	14.29	14.39	356900.0
2006-08-16	CTEC	ETF	54.5	56.15	53.75	54.699999999999996	34023.8
2006-08-16	CYB	ETF	5.6	5.7	5.6	5.61	3800.0
2006-08-16	DBC	ETF	25.3	25.33	25.01	25.07	228200.0
2006-08-16	DDM	ETF	6.1392	6.2158	6.1317	6.2075	8468400.0
2006-08-16	DES	ETF	17.3667	17.44	17.3567	17.4333	36000.0
2006-08-16	DEW	ETF	54.27	54.27	54.25	54.25	2700.0
2006-08-16	DFE	ETF	54.8	55.22	54.8	55.22	6100.0
2006-08-16	DFJ	ETF	51.66	51.66	51.63	51.63	1800.0
2006-08-16	DGT	ETF	70.65	70.84	70.37	70.4	53100.0
2006-08-16	DHS	ETF	53.32	53.43	53.28	53.38	12800.0

> showing 50 of 360 rows — these rows as CSV

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