PREVIEW / etf_daily / 2007-06-20

all etf daily files

  file:    by_date/etf_daily/2007/2007-06-20.parquet
  size:    22 KB
  rows:    487

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-20	SPY	ETF	153.58	153.58	150.96	151.14	177119700.0
2007-06-20	QQQ	ETF	47.83	47.92	47.24	47.31	161940832.0
2007-06-20	IWM	ETF	84.58	84.66	82.93	82.93	86929200.0
2007-06-20	DIA	ETF	136.61	136.62	134.69	134.85	16986200.0
2007-06-20	GLD	ETF	65.42	65.51	64.6	64.71	2591600.0
2007-06-20	TLT	ETF	84.02	84.08	83.59	83.62	3031700.0
2007-06-20	ADRE	ETF	46.42	46.52	45.4764	45.5	120787.0
2007-06-20	AGG	ETF	98.04	98.15	97.85	97.97	298700.0
2007-06-20	AIQ	ETF	45.7	46.15	44.75	45.8	50320.0
2007-06-20	AIS	ETF	2.01	2.02	1.93	1.95	132600.0
2007-06-20	ARB	ETF	50.73	50.83	49.88	49.92	172200.0
2007-06-20	BBH	ETF	60.0	60.0333	59.3467	59.3767	1181400.0
2007-06-20	BIL	ETF	91.84	91.9	91.84	91.88	3100.0
2007-06-20	BITS	ETF	32.1196	32.5056	31.64	31.68	6675.0
2007-06-20	BIV	ETF	73.55	73.57	73.42	73.42	15400.0
2007-06-20	BLV	ETF	72.48	72.5	72.32	72.34	28100.0
2007-06-20	BMVP	ETF	18.0933	18.0933	17.8104	17.8111	26100.0
2007-06-20	BND	ETF	74.03	74.04	73.75	73.75	70300.0
2007-06-20	BNE	ETF	20.01	20.02	19.72	19.82	273800.0
2007-06-20	BRF	ETF	14.4801	14.49	14.48	14.48	1600.0
2007-06-20	BSV	ETF	74.73	74.77	74.67	74.75	17000.0
2007-06-20	BTF	ETF	109.89999999999999	109.89999999999999	109.25	109.25	980.0
2007-06-20	CBON	ETF	29.96	29.97	29.03	29.16	58696.0
2007-06-20	CDL	ETF	6.61	6.62	6.31	6.32	7333361.0
2007-06-20	CEF	ETF	9.39	9.43	9.26	9.26	85500.0
2007-06-20	CGO	ETF	18.28	18.36	18.2	18.23	40100.0
2007-06-20	CGW	ETF	25.6	25.7	25.35	25.45	891500.0
2007-06-20	CHB	ETF	10.81	10.93	10.34	10.35	1278000.0
2007-06-20	CHI	ETF	19.92	20.03	19.89	19.95	88200.0
2007-06-20	CHIC	ETF	27.61	27.9	27.48	27.51	501834.0
2007-06-20	CHY	ETF	16.31	16.36	16.29	16.31	163500.0
2007-06-20	CN	ETF	56.7	56.7	55.4532	55.6	103600.0
2007-06-20	CNXT	ETF	1.27	1.34	1.25	1.32	19328415.0
2007-06-20	CPI	ETF	22.7501	22.7501	22.7501	22.7501	100.0
2007-06-20	CPST	ETF	1.05	1.09	1.03	1.06	1767794.0
2007-06-20	CSA	ETF	19.78	20.0999	19.78	19.94	36500.0
2007-06-20	CSB	ETF	33.33	33.3999	32.64	32.72	14200.0
2007-06-20	CSD	ETF	31.63	31.63	31.07	31.07	51800.0
2007-06-20	CSM	ETF	1.4175	1.4175	1.4175	1.4175	4000.0
2007-06-20	CSQ	ETF	15.45	15.45	15.16	15.26	430300.0
2007-06-20	CTEC	ETF	111.64999999999999	115.8	110.99999999999999	111.35	100794.20000000001
2007-06-20	CVY	ETF	28.3	28.32	27.87	27.88	14000.0
2007-06-20	CWI	ETF	27.6333	27.6333	27.2333	27.2333	11850.0
2007-06-20	CZA	ETF	27.38	27.38	27.38	27.38	400.0
2007-06-20	DBA	ETF	27.1	27.74	27.0	27.23	738600.0
2007-06-20	DBB	ETF	26.57	26.97	26.56	26.94	27200.0
2007-06-20	DBC	ETF	26.32	26.42	26.18	26.42	247600.0
2007-06-20	DBE	ETF	28.96	29.08	28.6	28.98	163200.0
2007-06-20	DBO	ETF	27.27	27.28	26.65	26.84	12800.0
2007-06-20	DBP	ETF	25.98	26.0	25.8	25.8	7400.0

> showing 50 of 487 rows — these rows as CSV

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