PREVIEW / etf_daily / 2009-09-16

all etf daily files

  file:    by_date/etf_daily/2009/2009-09-16.parquet
  size:    30 KB
  rows:    675

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-09-16	SPY	ETF	106.1	107.34	105.73	107.32	206406300.0
2009-09-16	QQQ	ETF	41.98	42.48	41.84	42.42	96888463.0
2009-09-16	IWM	ETF	60.81	61.8	60.62	61.79	39404000.0
2009-09-16	DIA	ETF	97.32	98.15	96.94	98.08	10580800.0
2009-09-16	GLD	ETF	100.01	100.02	99.5	99.91	16588200.0
2009-09-16	TLT	ETF	95.34	95.95	94.6	95.42	3732300.0
2009-09-16	AAXJ	ETF	52.58	53.42	52.45	53.42	458200.0
2009-09-16	ACWI	ETF	41.11	41.36	40.83	41.32	157100.0
2009-09-16	ACWX	ETF	40.3	40.45	40.03	40.4094	180610.0
2009-09-16	ADRE	ETF	41.36	41.59	40.89	41.57	365105.0
2009-09-16	AFK	ETF	28.82	28.82	28.14	28.48	22202.0
2009-09-16	AGG	ETF	104.11	104.14	103.89	104.01	594600.0
2009-09-16	AGQ	ETF	125.1	127.1	123.86	126.46	291000.0
2009-09-16	AGZ	ETF	107.8075	108.22	107.7	108.1	8027.0
2009-09-16	AIA	ETF	38.61	38.99	38.351	38.95	58460.0
2009-09-16	AIQ	ETF	27.8	29.35	26.9	29.2	86142.0
2009-09-16	AIS	ETF	1.12	1.12	1.06	1.1	344845.0
2009-09-16	AIVI	ETF	43.34	43.74	43.14	43.59	32500.0
2009-09-16	AMJ	ETF	24.84	25.18	24.81	25.18	202064.0
2009-09-16	AOA	ETF	29.33	29.42	29.22	29.42	11200.0
2009-09-16	AOK	ETF	27.32	27.32	27.0432	27.18	4353.0
2009-09-16	AOM	ETF	27.43	28.0	27.43	28.0	15760.0
2009-09-16	AOR	ETF	28.63	28.69	28.4744	28.69	14427.0
2009-09-16	ARB	ETF	19.08	19.28	18.92	19.28	141135.0
2009-09-16	BAL	ETF	33.0	33.08	32.78	33.0716	6602.0
2009-09-16	BBH	ETF	33.4667	33.9767	33.4667	33.94	226200.0
2009-09-16	BIL	ETF	91.7	91.72	91.7	91.7	167900.0
2009-09-16	BITS	ETF	21.96	22.08	21.64	21.92	4625.0
2009-09-16	BIV	ETF	79.78	79.82	79.26	79.58	170600.0
2009-09-16	BJK	ETF	27.02	27.18	26.1	26.38	114800.0
2009-09-16	BKF	ETF	41.39	42.0	41.15	42.0	165962.0
2009-09-16	BLV	ETF	78.35	78.67	77.96	78.33	21000.0
2009-09-16	BMVP	ETF	11.9967	12.1387	11.9849	12.1333	9738.0
2009-09-16	BND	ETF	78.9	79.01	78.75	78.96	535500.0
2009-09-16	BNE	ETF	7.22	7.42	7.045	7.38	143981.0
2009-09-16	BOSS	ETF	19.97	19.97	19.8	19.8	100.0
2009-09-16	BRF	ETF	39.96	40.17	39.72	39.98	418985.0
2009-09-16	BSV	ETF	79.84	79.84	79.62	79.68	417400.0
2009-09-16	BTF	ETF	58.8	59.85	58.75	59.74	7771.0
2009-09-16	BWX	ETF	29.125	29.25	28.97	29.165	652492.0
2009-09-16	BWZ	ETF	36.9871	37.26	36.9871	37.2	40534.0
2009-09-16	BZQ	ETF	5867.2	5867.2	5699.2	5716.8	66.0
2009-09-16	CEF	ETF	13.51	13.53	13.4	13.46	1017200.0
2009-09-16	CEW	ETF	21.62	21.78	21.62	21.75	41299.0
2009-09-16	CGO	ETF	13.88	14.25	13.88	14.2351	33684.0
2009-09-16	CGW	ETF	18.01	18.24	17.94	18.21	138771.0
2009-09-16	CHB	ETF	0.58	0.65	0.57	0.62	6227605.0
2009-09-16	CHI	ETF	11.53	11.78	11.53	11.77	181549.0
2009-09-16	CHIC	ETF	17.47	17.47	17.45	17.45	416837.0
2009-09-16	CHW	ETF	7.69	7.98	7.68	7.91	302592.0

> showing 50 of 675 rows — these rows as CSV

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