PREVIEW / etf_daily / 2009-06-17

all etf daily files

  file:    by_date/etf_daily/2009/2009-06-17.parquet
  size:    29 KB
  rows:    656

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-06-17	SPY	ETF	91.6	92.33	90.83	91.55	223445200.0
2009-06-17	QQQ	ETF	35.67	36.21	35.45	35.889	153421778.0
2009-06-17	IWM	ETF	50.5	51.37	50.0	50.77	71985300.0
2009-06-17	DIA	ETF	85.22	85.86	84.83	85.23	13494000.0
2009-06-17	GLD	ETF	91.61	92.39	90.15	92.35	12130100.0
2009-06-17	TLT	ETF	92.45	93.33	91.84	91.84	7197200.0
2009-06-17	AAXJ	ETF	43.21	43.4	42.5	43.18	330000.0
2009-06-17	ACWI	ETF	34.49	34.75	34.16	34.48	44800.0
2009-06-17	ACWX	ETF	33.55	33.71	33.24	33.52	34781.0
2009-06-17	ADRE	ETF	34.63	34.7048	33.9	34.34	348810.0
2009-06-17	AFK	ETF	27.39	27.59	27.39	27.55	12930.0
2009-06-17	AGG	ETF	101.5	101.77	101.34	101.53	454900.0
2009-06-17	AGQ	ETF	88.52	91.06	87.0	90.94	101600.0
2009-06-17	AGZ	ETF	107.0834	107.188	106.63	106.63	10885.0
2009-06-17	AIA	ETF	31.38	31.42	30.84	31.36	22644.0
2009-06-17	AIQ	ETF	34.7	35.65	33.8	35.5	76490.0
2009-06-17	AIS	ETF	0.68	0.75	0.63	0.7	347600.0
2009-06-17	AIVI	ETF	35.01	35.47	34.79	35.17	30200.0
2009-06-17	AMJ	ETF	22.3	22.3	21.57	21.8	317673.0
2009-06-17	AOA	ETF	25.06	25.17	24.85	25.02	6200.0
2009-06-17	AOK	ETF	25.56	25.8	25.56	25.64	25755.0
2009-06-17	AOM	ETF	25.5601	25.621	25.5	25.58	6130.0
2009-06-17	AOR	ETF	25.35	25.52	25.35	25.44	1865.0
2009-06-17	ARB	ETF	18.54	18.71	18.29	18.41	85426.0
2009-06-17	BAL	ETF	29.9	29.9	29.79	29.9	1000.0
2009-06-17	BBH	ETF	30.23	31.3533	30.23	31.0633	1172700.0
2009-06-17	BIL	ETF	91.76	91.76	91.72	91.76	153400.0
2009-06-17	BITS	ETF	19.12	19.12	18.56	19.04	442.0
2009-06-17	BIV	ETF	76.47	76.6	76.08	76.31	88200.0
2009-06-17	BJK	ETF	20.56	21.47	20.43	20.96	20100.0
2009-06-17	BKF	ETF	35.92	35.92	34.45	35.22	488468.0
2009-06-17	BLV	ETF	73.0	73.5	72.57	72.97	35100.0
2009-06-17	BMVP	ETF	10.763	10.924	10.763	10.823	45531.0
2009-06-17	BND	ETF	77.24	77.5	77.12	77.14	374700.0
2009-06-17	BNE	ETF	6.69	7.13	6.45	7.0	89728.0
2009-06-17	BOSS	ETF	15.71	15.71	15.71	15.71	100.0
2009-06-17	BRF	ETF	26.94	27.42	26.2614	27.21	99758.0
2009-06-17	BSV	ETF	78.88	78.9	78.69	78.78	253700.0
2009-06-17	BTF	ETF	47.75	47.85	47.05	47.4005	10707.400000000001
2009-06-17	BWX	ETF	26.87	27.07	26.765	26.9545	281636.0
2009-06-17	BWZ	ETF	34.87	34.93	34.6499	34.93	7867.0
2009-06-17	CBON	ETF	1.39	1.45	1.31	1.45	35227.0
2009-06-17	CEF	ETF	12.15	12.15	11.85	12.06	601100.0
2009-06-17	CEW	ETF	20.63	20.63	20.5	20.62	13919.0
2009-06-17	CGO	ETF	11.34	11.4	11.2127	11.38	29221.0
2009-06-17	CGW	ETF	15.21	15.33	14.98	15.27	81730.0
2009-06-17	CHB	ETF	0.43	0.45	0.4	0.41	397801.0
2009-06-17	CHI	ETF	10.53	10.63	10.39	10.56	103632.0
2009-06-17	CHIC	ETF	11.67	12.08	11.49	11.96	144967.0
2009-06-17	CHW	ETF	6.89	7.02	6.7	6.92	201257.0

> showing 50 of 656 rows — these rows as CSV

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