PREVIEW / etf_daily / 2010-02-24

all etf daily files

  file:    by_date/etf_daily/2010/2010-02-24.parquet
  size:    32 KB
  rows:    727

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
2010-02-24	SPY	ETF	110.14	111.0	109.86	110.82	176350700.0
2010-02-24	QQQ	ETF	44.4099	44.79	44.32	44.61	86590986.0
2010-02-24	IWM	ETF	62.74	63.35	62.55	63.04	50476000.0
2010-02-24	DIA	ETF	103.18	103.95	102.99	103.7	9658700.0
2010-02-24	GLD	ETF	107.33	108.16	107.1	107.36	17207400.0
2010-02-24	TLT	ETF	90.55	90.88	90.18	90.69	4423200.0
2010-02-24	AAXJ	ETF	52.91	53.07	52.5	52.92	778200.0
2010-02-24	ACWI	ETF	40.7	41.08	40.64	40.97	179500.0
2010-02-24	ACWX	ETF	38.91	39.13	38.6902	39.02	104465.0
2010-02-24	ADRE	ETF	40.73	40.93	40.48	40.73	65784.0
2010-02-24	AFK	ETF	28.7199	28.7199	28.5	28.6235	1015.0
2010-02-24	AGG	ETF	104.31	104.41	104.17	104.3	542100.0
2010-02-24	AGQ	ETF	96.26	98.3	96.22	97.24	170200.0
2010-02-24	AGZ	ETF	108.67	108.69	108.538	108.69	15391.0
2010-02-24	AIA	ETF	38.03	38.29	37.98	38.063	22116.0
2010-02-24	AIQ	ETF	25.6	25.7	25.2	25.7	9908.0
2010-02-24	AIS	ETF	1.33	1.35	1.25	1.31	651866.0
2010-02-24	AIVI	ETF	40.16	40.56	39.96	40.34	8700.0
2010-02-24	AMJ	ETF	29.62	29.62	29.4	29.6	328204.0
2010-02-24	AOA	ETF	29.59	29.75	29.52	29.65	15600.0
2010-02-24	AOK	ETF	27.34	27.35	27.31	27.3399	4295.0
2010-02-24	AOM	ETF	27.89	27.9948	27.89	27.9899	22585.0
2010-02-24	AOR	ETF	28.51	28.7	28.51	28.61	4310.0
2010-02-24	ARB	ETF	22.16	22.36	22.0	22.17	250706.0
2010-02-24	BAB	ETF	24.76	24.85	24.69	24.78	288985.0
2010-02-24	BAL	ETF	38.15	38.25	37.9101	38.25	5150.0
2010-02-24	BBH	ETF	33.8767	34.1233	33.8767	33.9767	114900.0
2010-02-24	BIL	ETF	91.7	91.72	91.68	91.72	144950.0
2010-02-24	BITS	ETF	31.56	31.76	30.88	31.72	3285.0
2010-02-24	BIV	ETF	80.3	80.49	80.21	80.43	79700.0
2010-02-24	BJK	ETF	23.23	23.46	23.23	23.41	37000.0
2010-02-24	BKF	ETF	42.37	42.8	42.25	42.65	125179.0
2010-02-24	BLV	ETF	76.82	76.97	76.46	76.9	14400.0
2010-02-24	BMVP	ETF	12.53	12.58	12.5021	12.57	6248.0
2010-02-24	BND	ETF	79.39	79.47	79.31	79.41	378600.0
2010-02-24	BNE	ETF	11.12	11.18	11.07	11.15	64477755.0
2010-02-24	BRF	ETF	45.39	45.58	44.5	44.57	345052.0
2010-02-24	BSV	ETF	80.26	80.29	80.2	80.28	462900.0
2010-02-24	BTF	ETF	66.70049999999999	67.5	66.70049999999999	67.4995	7710.8
2010-02-24	BWX	ETF	27.98	28.105	27.8855	28.04	253576.0
2010-02-24	BWZ	ETF	35.53	35.56	35.36	35.425	40891.0
2010-02-24	BZQ	ETF	4297.6	4400.0	4235.2	4334.4	1210.0
2010-02-24	CEF	ETF	13.16	13.39	13.15	13.39	1600900.0
2010-02-24	CEW	ETF	21.66	21.71	21.6	21.7	97543.0
2010-02-24	CGO	ETF	14.16	14.5699	14.089	14.27	43959.0
2010-02-24	CGW	ETF	17.62	17.71	17.55	17.7	334448.0
2010-02-24	CHI	ETF	12.39	12.39	12.23	12.2701	148031.0
2010-02-24	CHIE	ETF	13.74	13.74	13.6901	13.6901	600.0
2010-02-24	CHII	ETF	14.46	14.624	14.4	14.6	7315.0
2010-02-24	CHIM	ETF	25.26	25.5	25.26	25.38	4224.0

> showing 50 of 727 rows — these rows as CSV

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