PREVIEW / etf_daily / 2009-07-02

all etf daily files

  file:    by_date/etf_daily/2009/2009-07-02.parquet
  size:    29 KB
  rows:    660

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-02	SPY	ETF	91.13	92.36	89.76	89.81	212309900.0
2009-07-02	QQQ	ETF	36.09	36.1	35.5	35.6	113309764.0
2009-07-02	IWM	ETF	50.88	50.88	49.69	49.91	51688200.0
2009-07-02	DIA	ETF	84.0	84.04	82.95	82.99	16516500.0
2009-07-02	GLD	ETF	91.47	91.58	91.08	91.25	7365200.0
2009-07-02	TLT	ETF	94.33	94.61	94.0	94.3	2645100.0
2009-07-02	AAXJ	ETF	44.11	44.2	43.39	43.68	213200.0
2009-07-02	ACWI	ETF	34.44	34.45	33.88	33.9	424900.0
2009-07-02	ACWX	ETF	33.22	33.22	32.78	32.8	51021.0
2009-07-02	ADRE	ETF	34.58	34.58	34.0	34.0	86859.0
2009-07-02	AFK	ETF	26.7501	27.0	26.6601	27.0	5680.0
2009-07-02	AGG	ETF	101.75	102.16	101.75	102.01	533000.0
2009-07-02	AGQ	ETF	79.06	79.22	78.14	78.4	133400.0
2009-07-02	AGZ	ETF	107.13	108.02	107.13	107.9	18515.0
2009-07-02	AIA	ETF	31.98	31.98	31.63	31.65	26442.0
2009-07-02	AIQ	ETF	35.2	35.25	33.25	33.9	69562.0
2009-07-02	AIS	ETF	0.93	0.93	0.856	0.88	674596.0
2009-07-02	AIVI	ETF	35.01	35.65	34.46	34.67	11000.0
2009-07-02	AMJ	ETF	22.19	22.32	22.19	22.25	52814.0
2009-07-02	AOA	ETF	24.78	24.84	24.71	24.76	4300.0
2009-07-02	AOK	ETF	25.7	26.5	25.5968	25.62	22219.0
2009-07-02	AOM	ETF	25.51	25.91	25.4	25.4	2888.0
2009-07-02	AOR	ETF	25.54	25.54	25.2195	25.24	2320.0
2009-07-02	ARB	ETF	16.49	16.51	15.67	16.13	259101.0
2009-07-02	BAL	ETF	31.0001	31.729	31.0001	31.48	11650.0
2009-07-02	BBH	ETF	30.7767	30.8133	30.2367	30.2733	1335300.0
2009-07-02	BIL	ETF	91.76	91.76	91.74	91.76	100100.0
2009-07-02	BITS	ETF	21.04	21.04	19.632	20.56	2963.0
2009-07-02	BIV	ETF	77.19	77.26	77.0	77.23	73400.0
2009-07-02	BJK	ETF	20.33	20.44	20.05	20.17	3700.0
2009-07-02	BKF	ETF	35.42	35.42	34.88	35.0	651486.0
2009-07-02	BLV	ETF	74.53	75.34	74.32	74.74	12400.0
2009-07-02	BMVP	ETF	10.947	10.947	10.764	10.783	205240.0
2009-07-02	BND	ETF	77.3	77.54	77.27	77.41	373000.0
2009-07-02	BNE	ETF	6.9	6.98	6.47	6.7	171782.0
2009-07-02	BRF	ETF	27.91	28.07	27.68	27.98	120500.0
2009-07-02	BSV	ETF	79.11	79.25	78.97	79.19	238700.0
2009-07-02	BTF	ETF	47.300000000000004	47.5	47.099999999999994	47.24999999999999	9600.0
2009-07-02	BWX	ETF	27.36	27.42	27.25	27.35	320080.0
2009-07-02	BWZ	ETF	35.18	35.18	35.0	35.057	4066.0
2009-07-02	BZQ	ETF	9473.6	9577.6	9433.6	9568.0	68.0
2009-07-02	CBON	ETF	0.93	0.94	0.9	0.91	4481.0
2009-07-02	CEF	ETF	11.61	11.79	11.61	11.75	336500.0
2009-07-02	CEW	ETF	20.98	20.98	20.8401	20.91	13863.0
2009-07-02	CGO	ETF	11.56	11.95	11.56	11.65	21294.0
2009-07-02	CGW	ETF	15.61	15.61	15.32	15.39	58370.0
2009-07-02	CHB	ETF	0.32	0.33	0.3	0.32	408652.0
2009-07-02	CHI	ETF	10.47	10.52	10.25	10.32	119114.0
2009-07-02	CHIC	ETF	12.47	12.68	12.38	12.52	199367.0
2009-07-02	CHW	ETF	6.94	6.94	6.66	6.75	251440.0

> showing 50 of 660 rows — these rows as CSV

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