PREVIEW / etf_daily / 2009-07-20

all etf daily files

  file:    by_date/etf_daily/2009/2009-07-20.parquet
  size:    29 KB
  rows:    670

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
2009-07-20	SPY	ETF	94.68	95.29	94.19	95.13	164179400.0
2009-07-20	QQQ	ETF	37.75	38.0	37.61	37.92	97168739.0
2009-07-20	IWM	ETF	52.25	52.74	52.03	52.54	42596800.0
2009-07-20	DIA	ETF	87.88	88.54	87.54	88.33	13142300.0
2009-07-20	GLD	ETF	93.61	93.8	92.91	93.28	13172100.0
2009-07-20	TLT	ETF	90.85	92.49	90.8	91.72	4436500.0
2009-07-20	AAXJ	ETF	47.58	51.15	47.56	51.15	183800.0
2009-07-20	ACWI	ETF	35.92	36.17	35.72	36.13	124600.0
2009-07-20	ACWX	ETF	34.82	35.06	34.61	35.04	84433.0
2009-07-20	ADRE	ETF	36.47	37.05	36.47	36.98	147756.0
2009-07-20	AFK	ETF	26.68	26.85	26.37	26.43	6233.0
2009-07-20	AGG	ETF	102.01	102.49	101.97	102.29	675400.0
2009-07-20	AGQ	ETF	81.8	81.98	80.36	81.12	164800.0
2009-07-20	AGZ	ETF	107.38	107.84	107.12	107.4356	7519.0
2009-07-20	AIA	ETF	34.81	35.16	34.7222	35.14	82804.0
2009-07-20	AIQ	ETF	32.95	33.0	31.5	31.8	54048.0
2009-07-20	AIS	ETF	0.75	0.81	0.75	0.8	252565.0
2009-07-20	AIVI	ETF	36.44	36.92	36.35	36.88	18700.0
2009-07-20	AMJ	ETF	23.9	24.1396	23.9	24.1199	113154.0
2009-07-20	AOA	ETF	25.78	26.46	25.0	25.99	31200.0
2009-07-20	AOK	ETF	25.8994	26.18	25.82	25.93	4495.0
2009-07-20	AOM	ETF	25.98	25.98	25.81	25.84	2808.0
2009-07-20	AOR	ETF	26.0	26.09	25.9099	26.09	46546.0
2009-07-20	ARB	ETF	17.55	17.78	16.73	17.27	530256.0
2009-07-20	BAL	ETF	33.09	33.75	33.09	33.5501	5015.0
2009-07-20	BBH	ETF	32.5533	32.7667	32.3133	32.63	798000.0
2009-07-20	BIL	ETF	91.72	91.74	91.72	91.72	269600.0
2009-07-20	BITS	ETF	22.48	22.8	22.16	22.68	750.0
2009-07-20	BIV	ETF	77.12	77.87	77.06	77.58	91100.0
2009-07-20	BJK	ETF	21.81	22.4	21.46	21.92	7900.0
2009-07-20	BKF	ETF	36.92	37.5216	36.905	37.45	661278.0
2009-07-20	BLV	ETF	73.68	74.35	73.17	73.95	10600.0
2009-07-20	BMVP	ETF	11.1933	11.2609	11.1781	11.25	16388.0
2009-07-20	BND	ETF	77.58	77.77	77.48	77.73	473200.0
2009-07-20	BNE	ETF	7.18	7.43	7.04	7.06	166527.0
2009-07-20	BOSS	ETF	16.7	16.85	16.7	16.85	100.0
2009-07-20	BRF	ETF	30.85	31.15	30.67	30.97	389674.0
2009-07-20	BSV	ETF	79.25	79.44	79.11	79.41	192000.0
2009-07-20	BTF	ETF	50.0	50.51499999999999	49.4	50.0	7073.200000000001
2009-07-20	BWX	ETF	27.715	27.745	27.625	27.635	308782.0
2009-07-20	BWZ	ETF	35.4471	35.72	35.4471	35.72	4010.0
2009-07-20	BZQ	ETF	8368.0	8368.0	8264.0	8264.0	320.0
2009-07-20	CBON	ETF	0.7	0.85	0.7	0.71	23571.0
2009-07-20	CEF	ETF	11.91	12.0	11.83	11.94	756900.0
2009-07-20	CEW	ETF	21.0	21.16	21.0	21.16	17772.0
2009-07-20	CGO	ETF	12.33	12.33	11.9601	12.05	43174.0
2009-07-20	CGW	ETF	15.82	16.08	15.75	16.079	61984.0
2009-07-20	CHB	ETF	0.31	0.31	0.29	0.3	248646.0
2009-07-20	CHI	ETF	10.61	10.75	10.61	10.75	137201.0
2009-07-20	CHIC	ETF	12.82	12.82	12.45	12.5	474822.0

> showing 50 of 670 rows — these rows as CSV

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