PREVIEW / etf_daily / 2007-06-12

all etf daily files

  file:    by_date/etf_daily/2007/2007-06-12.parquet
  size:    22 KB
  rows:    476

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
2007-06-12	SPY	ETF	150.67	151.54	149.55	149.65	233898000.0
2007-06-12	QQQ	ETF	46.57	47.04	46.45	46.54	154107381.0
2007-06-12	IWM	ETF	82.33	82.83	81.41	81.5	115376300.0
2007-06-12	DIA	ETF	133.69	134.46	132.92	132.92	19846200.0
2007-06-12	GLD	ETF	64.52	64.53	63.91	64.1	4073200.0
2007-06-12	TLT	ETF	82.91	83.42	82.2	82.35	9043900.0
2007-06-12	ADRE	ETF	44.5	44.52	43.78	43.84	170152.0
2007-06-12	AGG	ETF	97.55	97.57	97.11	97.2	380400.0
2007-06-12	AIQ	ETF	45.1	45.15	44.2	44.2	35380.0
2007-06-12	AIS	ETF	1.91	1.92	1.85	1.87	329800.0
2007-06-12	ARB	ETF	51.71	51.71	50.67	50.81	147700.0
2007-06-12	BBH	ETF	59.6	59.7667	59.3133	59.4433	722700.0
2007-06-12	BIL	ETF	91.72	91.72	91.64	91.64	3900.0
2007-06-12	BITS	ETF	32.4	32.64	31.88	31.96	12944.0
2007-06-12	BIV	ETF	73.04	73.06	72.8	72.82	31200.0
2007-06-12	BLV	ETF	71.7	71.71	71.27	71.33	24500.0
2007-06-12	BMVP	ETF	17.9133	17.9967	17.8067	17.82	56000.0
2007-06-12	BND	ETF	73.61	73.61	73.36	73.4	405400.0
2007-06-12	BNE	ETF	19.26	19.31	18.8652	19.1	259200.0
2007-06-12	BRF	ETF	14.51	14.52	14.49	14.5	12500.0
2007-06-12	BSV	ETF	74.58	74.6	74.46	74.47	77000.0
2007-06-12	BTF	ETF	110.19999999999999	110.19999999999999	107.94999999999999	109.0	2040.0
2007-06-12	CBON	ETF	29.52	29.89	29.03	29.05	44175.0
2007-06-12	CDL	ETF	8.39	8.39	8.18	8.27	10705400.0
2007-06-12	CEF	ETF	9.01	9.04	8.9	8.95	245100.0
2007-06-12	CGO	ETF	17.67	17.83	17.37	17.42	38400.0
2007-06-12	CGW	ETF	24.89	25.05	24.65	24.65	266700.0
2007-06-12	CHB	ETF	10.01	10.11	9.81	9.87	1909100.0
2007-06-12	CHI	ETF	20.22	20.22	19.8	19.9	84500.0
2007-06-12	CHIC	ETF	28.07	28.15	27.5	27.57	485640.0
2007-06-12	CHY	ETF	16.8	16.8	16.38	16.51	187300.0
2007-06-12	CN	ETF	52.85	52.85	51.991	52.21	46800.0
2007-06-12	CNXT	ETF	1.26	1.28	1.24	1.26	5216123.0
2007-06-12	CPI	ETF	23.62	23.62	23.61	23.61	500.0
2007-06-12	CPST	ETF	1.08	1.11	1.03	1.03	4595818.0
2007-06-12	CSA	ETF	19.72	20.0	19.26	19.51	150900.0
2007-06-12	CSB	ETF	31.19	31.21	30.9	30.93	19900.0
2007-06-12	CSD	ETF	30.54	30.54	30.22	30.29	19600.0
2007-06-12	CSQ	ETF	15.07	15.13	14.91	14.99	382400.0
2007-06-12	CTEC	ETF	103.45	106.4	102.55	104.89999999999999	123054.40000000001
2007-06-12	CVY	ETF	27.8	27.94	27.32	27.32	29400.0
2007-06-12	CWI	ETF	26.7133	26.8267	26.4533	26.5133	147600.0
2007-06-12	CZA	ETF	26.66	26.66	26.66	26.66	100.0
2007-06-12	DBA	ETF	26.91	27.1	26.72	26.97	277000.0
2007-06-12	DBB	ETF	26.15	26.41	26.05	26.4	38200.0
2007-06-12	DBC	ETF	25.84	25.92	25.73	25.91	124400.0
2007-06-12	DBE	ETF	28.2	28.22	28.0	28.17	6100.0
2007-06-12	DBO	ETF	26.41	26.41	26.3	26.37	3100.0
2007-06-12	DBP	ETF	25.55	25.61	25.51	25.51	3000.0
2007-06-12	DBS	ETF	25.75	25.86	25.75	25.77	800.0

> showing 50 of 476 rows — these rows as CSV

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