PREVIEW / etf_daily / 2010-02-12

all etf daily files

  file:    by_date/etf_daily/2010/2010-02-12.parquet
  size:    31 KB
  rows:    725

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-12	SPY	ETF	106.99	108.1	106.51	108.04	304622100.0
2010-02-12	QQQ	ETF	43.27	43.88	43.16	43.76	93943992.0
2010-02-12	IWM	ETF	60.0	61.1	59.81	61.02	65909800.0
2010-02-12	DIA	ETF	100.53	101.37	99.99	101.27	13643000.0
2010-02-12	GLD	ETF	106.08	107.1	105.57	107.04	14464200.0
2010-02-12	TLT	ETF	90.31	90.42	89.95	90.19	2833800.0
2010-02-12	AAXJ	ETF	52.12	52.31	51.63	52.19	101800.0
2010-02-12	ACWI	ETF	39.95	40.18	39.64	40.18	109700.0
2010-02-12	ACWX	ETF	38.05	38.32	37.81	38.32	91588.0
2010-02-12	ADRE	ETF	39.88	40.45	39.6899	40.43	125258.0
2010-02-12	AFK	ETF	28.6	28.77	28.2	28.616	7933.0
2010-02-12	AGG	ETF	104.24	104.26	104.02	104.02	506100.0
2010-02-12	AGQ	ETF	91.0	93.32	89.46	93.1	235550.0
2010-02-12	AGZ	ETF	108.35	108.53	108.3301	108.5	16006.0
2010-02-12	AIA	ETF	37.64	37.65	37.2701	37.65	7750.0
2010-02-12	AIQ	ETF	25.05	25.2975	24.4	25.05	13797.0
2010-02-12	AIS	ETF	1.12	1.2	1.1	1.2	248665.0
2010-02-12	AIVI	ETF	39.71	39.98	39.4	39.73	11300.0
2010-02-12	AMJ	ETF	28.47	28.78	28.34	28.78	367151.0
2010-02-12	AOA	ETF	28.73	29.04	28.73	29.04	9100.0
2010-02-12	AOK	ETF	27.13	27.1899	27.12	27.1899	1282.0
2010-02-12	AOM	ETF	27.65	27.72	27.6	27.696	9667.0
2010-02-12	AOR	ETF	28.1095	28.26	28.0499	28.26	18104.0
2010-02-12	ARB	ETF	24.77	24.82	23.97	24.36	299175.0
2010-02-12	BAB	ETF	24.65	24.6799	24.58	24.63	265741.0
2010-02-12	BAL	ETF	35.31	36.05	35.3	36.02	15400.0
2010-02-12	BBH	ETF	33.4867	33.71	33.3	33.6933	49800.0
2010-02-12	BIL	ETF	91.74	91.74	91.72	91.74	144400.0
2010-02-12	BITS	ETF	31.44	32.4	31.28	32.36	1647.0
2010-02-12	BIV	ETF	80.24	80.24	80.02	80.1	118100.0
2010-02-12	BJK	ETF	23.15	23.36	23.02	23.36	7600.0
2010-02-12	BKF	ETF	41.47	41.87	41.0307	41.86	219889.0
2010-02-12	BLV	ETF	76.21	76.42	76.02	76.18	34100.0
2010-02-12	BMVP	ETF	12.17	12.3	12.1	12.3	34056.0
2010-02-12	BND	ETF	79.29	79.39	79.2	79.23	387900.0
2010-02-12	BNE	ETF	6.23	6.33	6.17	6.24	238027.0
2010-02-12	BRF	ETF	44.0	44.37	43.62	43.97	260696.0
2010-02-12	BSV	ETF	80.2	80.3	80.14	80.23	457100.0
2010-02-12	BTF	ETF	65.99999999999999	65.99999999999999	65.05	65.89999999999999	6571.200000000001
2010-02-12	BWX	ETF	27.765	27.835	27.671	27.83	231968.0
2010-02-12	BWZ	ETF	35.39	35.6	35.39	35.54	52197.0
2010-02-12	BZQ	ETF	4625.6	4657.6	4427.2	4449.6	669.5
2010-02-12	CEF	ETF	13.13	13.34	13.05	13.33	690800.0
2010-02-12	CEW	ETF	21.65	21.7	21.565	21.69	172736.0
2010-02-12	CGO	ETF	13.65	14.02	13.43	13.6163	21106.0
2010-02-12	CGW	ETF	17.37	17.37	17.08	17.35	62566.0
2010-02-12	CHI	ETF	12.0	12.1	11.956	12.08	106515.0
2010-02-12	CHIE	ETF	13.63	13.75	13.52	13.75	500.0
2010-02-12	CHII	ETF	14.2	14.3625	14.2	14.3	6442.0
2010-02-12	CHIM	ETF	25.12	25.38	24.8	25.28	15748.0

> showing 50 of 725 rows — these rows as CSV

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