PREVIEW / etf_daily / 2009-06-19

all etf daily files

  file:    by_date/etf_daily/2009/2009-06-19.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-19	SPY	ETF	92.58	92.7	91.52	92.04	215655600.0
2009-06-19	QQQ	ETF	36.04	36.36	35.9101	36.16	122050096.0
2009-06-19	IWM	ETF	51.72	51.92	51.11	51.31	38711500.0
2009-06-19	DIA	ETF	85.96	86.1	84.92	85.31	13880400.0
2009-06-19	GLD	ETF	91.81	92.23	91.58	91.9	11812300.0
2009-06-19	TLT	ETF	90.33	91.7	90.21	91.69	4750700.0
2009-06-19	AAXJ	ETF	43.79	43.79	43.07	43.36	132100.0
2009-06-19	ACWI	ETF	34.97	35.02	34.63	34.76	325500.0
2009-06-19	ACWX	ETF	34.02	34.02	33.64	33.73	14318.0
2009-06-19	ADRE	ETF	34.61	34.6112	34.1701	34.1701	139095.0
2009-06-19	AFK	ETF	27.47	27.62	27.2121	27.28	4763.0
2009-06-19	AGG	ETF	100.66	101.25	100.66	101.24	584400.0
2009-06-19	AGQ	ETF	90.1	91.18	88.28	89.12	98600.0
2009-06-19	AGZ	ETF	105.9	106.77	105.9	106.72	23151.0
2009-06-19	AIA	ETF	31.32	31.76	31.32	31.51	25172.0
2009-06-19	AIQ	ETF	37.5	38.2	36.9	37.7	129800.0
2009-06-19	AIS	ETF	0.72	0.72	0.6709	0.72	87005.0
2009-06-19	AIVI	ETF	36.01	36.01	35.67	35.74	7100.0
2009-06-19	AMJ	ETF	22.09	22.09	21.78	21.91	47862.0
2009-06-19	AOA	ETF	25.57	25.99	25.28	25.32	21500.0
2009-06-19	AOK	ETF	25.65	25.66	25.6324	25.6324	3340.0
2009-06-19	AOM	ETF	25.7094	25.84	25.6799	25.72	3842.0
2009-06-19	AOR	ETF	25.6193	25.7	25.6	25.7	11377.0
2009-06-19	ARB	ETF	18.1	18.1	17.58	17.9	263295.0
2009-06-19	BAL	ETF	30.22	30.33	29.157	29.2486	8004.0
2009-06-19	BBH	ETF	31.7233	31.9533	31.2167	31.3533	821100.0
2009-06-19	BIL	ETF	91.72	91.76	91.7	91.76	232600.0
2009-06-19	BITS	ETF	19.12	19.12	18.64	18.6588	656.0
2009-06-19	BIV	ETF	75.33	76.0	75.33	75.97	86400.0
2009-06-19	BJK	ETF	21.18	21.68	20.93	20.95	6900.0
2009-06-19	BKF	ETF	35.63	35.64	34.86	34.86	609085.0
2009-06-19	BLV	ETF	72.26	72.94	72.01	72.89	15300.0
2009-06-19	BMVP	ETF	10.95	10.9667	10.8366	10.8667	21080.0
2009-06-19	BND	ETF	76.61	76.76	76.52	76.75	514800.0
2009-06-19	BNE	ETF	7.0	7.0	6.48	6.52	268838.0
2009-06-19	BOSS	ETF	15.5	15.5	15.33	15.33	400.0
2009-06-19	BRF	ETF	27.52	27.85	27.5	27.5	39546.0
2009-06-19	BSV	ETF	78.69	78.79	78.41	78.74	274700.0
2009-06-19	BTF	ETF	47.5	47.75	47.4	47.4	3644.0
2009-06-19	BWX	ETF	26.855	27.045	26.7875	26.885	166822.0
2009-06-19	BWZ	ETF	34.872	35.0438	34.7622	34.7622	683.0
2009-06-19	BZQ	ETF	9433.6	9441.6	9342.4	9350.4	15.6
2009-06-19	CBON	ETF	1.45	1.45	1.38	1.4	19920.0
2009-06-19	CEF	ETF	12.04	12.1	11.88	12.03	502400.0
2009-06-19	CEW	ETF	20.74	20.74	20.672	20.7	13601.0
2009-06-19	CGO	ETF	11.61	11.65	11.4	11.55	24128.0
2009-06-19	CGW	ETF	15.31	15.59	15.18	15.37	189057.0
2009-06-19	CHB	ETF	0.39	0.4	0.37	0.37	739242.0
2009-06-19	CHI	ETF	10.82	10.82	10.53	10.57	174815.0
2009-06-19	CHIC	ETF	12.01	12.28	11.83	11.96	270638.0

> showing 50 of 656 rows — these rows as CSV

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