PREVIEW / etf_daily / 2009-12-11

all etf daily files

  file:    by_date/etf_daily/2009/2009-12-11.parquet
  size:    31 KB
  rows:    706

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-12-11	SPY	ETF	111.11	111.36	110.61	111.11	124854000.0
2009-12-11	QQQ	ETF	44.52	44.59	43.95	44.13	66643628.0
2009-12-11	IWM	ETF	60.03	60.27	59.48	60.17	50543400.0
2009-12-11	DIA	ETF	104.51	105.04	104.25	104.92	9235500.0
2009-12-11	GLD	ETF	110.6	110.82	108.72	109.32	28983100.0
2009-12-11	TLT	ETF	91.84	92.26	91.31	92.09	3053400.0
2009-12-11	AAXJ	ETF	55.7	56.08	55.49	55.57	187400.0
2009-12-11	ACWI	ETF	42.14	42.35	42.07	42.22	152700.0
2009-12-11	ACWX	ETF	40.768	40.9281	40.71	40.75	53476.0
2009-12-11	ADRE	ETF	44.49	44.49	44.05	44.22	74684.0
2009-12-11	AFK	ETF	28.18	28.36	27.873	28.0	5856.0
2009-12-11	AGG	ETF	104.74	104.76	104.56	104.62	517200.0
2009-12-11	AGQ	ETF	119.08	119.68	113.58	117.24	278900.0
2009-12-11	AGZ	ETF	108.622	108.64	108.37	108.62	11397.0
2009-12-11	AIA	ETF	39.6	39.83	39.6	39.81	8210.0
2009-12-11	AIQ	ETF	30.9	31.5	30.6	31.25	50281.0
2009-12-11	AIS	ETF	1.1	1.1	1.05	1.07	288667.0
2009-12-11	AIVI	ETF	43.91	43.91	43.61	43.68	19600.0
2009-12-11	AMJ	ETF	27.64	27.64	27.32	27.61	222578.0
2009-12-11	AOA	ETF	29.73	29.73	29.68	29.73	5800.0
2009-12-11	AOK	ETF	27.41	27.42	27.36	27.42	4350.0
2009-12-11	AOM	ETF	28.31	28.31	28.2	28.3	8002.0
2009-12-11	AOR	ETF	29.01	29.01	28.85	28.94	27522.0
2009-12-11	ARB	ETF	21.4	21.92	21.28	21.82	264468.0
2009-12-11	BAB	ETF	24.54	24.6	24.45	24.57	177840.0
2009-12-11	BAL	ETF	36.85	36.85	36.035	36.035	1440.0
2009-12-11	BBH	ETF	32.3533	32.66	32.3533	32.54	165300.0
2009-12-11	BIL	ETF	91.74	91.74	91.7	91.7	131850.0
2009-12-11	BITS	ETF	27.6	28.4	27.48	28.4	1800.0
2009-12-11	BIV	ETF	80.41	80.49	80.25	80.4	89400.0
2009-12-11	BJK	ETF	24.2	24.27	24.0	24.25	10000.0
2009-12-11	BKF	ETF	46.18	46.26	45.76	46.11	106244.0
2009-12-11	BLV	ETF	76.96	77.26	76.76	77.13	46500.0
2009-12-11	BMVP	ETF	12.41	12.46	12.37	12.43	10753.0
2009-12-11	BND	ETF	79.36	79.46	79.24	79.43	280200.0
2009-12-11	BNE	ETF	6.51	6.56	6.34	6.36	209218.0
2009-12-11	BRF	ETF	48.88	48.91	48.12	48.91	413384.0
2009-12-11	BSV	ETF	80.2	80.28	80.14	80.25	470100.0
2009-12-11	BTF	ETF	63.49999999999999	63.699999999999996	63.25	63.4	4123.8
2009-12-11	BWX	ETF	29.425	29.435	29.205	29.255	450598.0
2009-12-11	BWZ	ETF	37.35	37.45	37.0	37.09	87767.0
2009-12-11	BZQ	ETF	3712.0	3756.8	3696.0	3721.6	424.5
2009-12-11	CEF	ETF	13.97	14.15	13.69	13.79	1648600.0
2009-12-11	CEW	ETF	22.15	22.15	22.03	22.06	40546.0
2009-12-11	CGO	ETF	14.14	14.2473	14.11	14.2026	24659.0
2009-12-11	CGW	ETF	18.48	18.54	18.335	18.45	96831.0
2009-12-11	CHI	ETF	12.4	12.4	12.29	12.34	148781.0
2009-12-11	CHII	ETF	16.16	16.16	15.936	16.01	24163.0
2009-12-11	CHIQ	ETF	16.4	16.4	16.2	16.2515	58773.0
2009-12-11	CHIX	ETF	15.19	15.26	15.109	15.15	729567.0

> showing 50 of 706 rows — these rows as CSV

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