PREVIEW / etf_daily / 2011-12-20

all etf daily files

  file:    by_date/etf_daily/2011/2011-12-20.parquet
  size:    37 KB
  rows:    901

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
2011-12-20	SPY	ETF	122.18	124.14	120.37	123.93	225418100.0
2011-12-20	QQQ	ETF	55.2	56.0	55.17	55.93	81758761.0
2011-12-20	IWM	ETF	72.55	73.97	72.51	73.86	74174400.0
2011-12-20	DIA	ETF	119.11	120.88	119.07	120.68	7867300.0
2011-12-20	GLD	ETF	156.82	157.43	156.58	156.98	9136300.0
2011-12-20	TLT	ETF	122.66	122.67	120.61	120.78	13945400.0
2011-12-20	AADR	ETF	27.62	27.65	27.58	27.65	1400.0
2011-12-20	AAXJ	ETF	49.07	49.79	49.03	49.69	310800.0
2011-12-20	ACTV	ETF	13.27	13.41	13.12	13.38	138123.0
2011-12-20	ACWI	ETF	41.21	41.79	41.17	41.72	962600.0
2011-12-20	ACWX	ETF	36.09	36.46	36.06	36.4	931108.0
2011-12-20	ADRE	ETF	37.4	37.89	37.4	37.73	40011.0
2011-12-20	AFK	ETF	26.44	26.93	26.44	26.93	24973.0
2011-12-20	AGEM	ETF	20.6	20.91	20.6	20.91	10743.0
2011-12-20	AGG	ETF	110.06	110.2	109.97	110.01	2779500.0
2011-12-20	AGQ	ETF	191.84	194.28	190.2	193.24	420475.0
2011-12-20	AGZ	ETF	112.72	113.213	112.62	112.82	85140.0
2011-12-20	AIA	ETF	38.4	38.9545	38.4	38.9	30129.0
2011-12-20	AIQ	ETF	4.95	5.25	4.8	5.1	17784.0
2011-12-20	AIS	ETF	1.83	1.89	1.76	1.83	2342167.0
2011-12-20	AIVI	ETF	39.01	39.4	39.01	39.3	177700.0
2011-12-20	AMJ	ETF	37.84	37.9	37.622	37.8	1209293.0
2011-12-20	AMLP	ETF	81.3	81.65	81.1	81.5	363480.0
2011-12-20	AOA	ETF	32.5	32.98	32.5	32.91	25600.0
2011-12-20	AOK	ETF	29.26	29.36	29.21	29.35	27443.0
2011-12-20	AOM	ETF	29.75	29.969	29.75	29.96	22060.0
2011-12-20	AOR	ETF	31.11	31.1592	31.04	31.14	9524.0
2011-12-20	ARB	ETF	35.17	35.75	35.02	35.62	155831.0
2011-12-20	ARGT	ETF	21.62	21.64	21.44	21.64	400.0
2011-12-20	ASEA	ETF	14.71	14.88	14.68	14.79	20700.0
2011-12-20	AWAY	ETF	21.09	21.7	20.38	20.71	986869.0
2011-12-20	BAB	ETF	28.79	28.79	28.5706	28.66	209159.0
2011-12-20	BAL	ETF	54.16	54.5	53.41	53.41	14633.0
2011-12-20	BALT	ETF	4.92	5.01	4.9001	5.0	76602.0
2011-12-20	BBH	ETF	34.6833	35.31	34.6767	35.2533	33000.0
2011-12-20	BCM	ETF	42.62	42.62	42.6	42.62	2080.0
2011-12-20	BIB	ETF	8.2675	8.3425	8.2675	8.3175	6480.0
2011-12-20	BICK	ETF	22.53	23.04	22.53	22.9305	18158.0
2011-12-20	BIL	ETF	91.68	91.68	91.66	91.68	235500.0
2011-12-20	BIS	ETF	5528.0	5528.0	5500.8	5500.8	5.6
2011-12-20	BITS	ETF	23.0	23.0	22.84	23.0	2025.0
2011-12-20	BIV	ETF	87.84	88.05	87.75	87.79	266000.0
2011-12-20	BJK	ETF	29.49	29.84	29.49	29.84	11900.0
2011-12-20	BKF	ETF	35.83	36.49	35.61	36.37	195478.0
2011-12-20	BKLN	ETF	23.78	23.81	23.68	23.7	136300.0
2011-12-20	BLNG	ETF	48.832	48.832	48.832	48.832	100.0
2011-12-20	BLV	ETF	93.15	93.15	92.05	92.11	94400.0
2011-12-20	BMVP	ETF	13.19	13.44	13.19	13.44	18659.0
2011-12-20	BND	ETF	84.11	84.11	83.85	83.85	1285400.0
2011-12-20	BNO	ETF	37.0	37.205	36.895	37.13	32800.0

> showing 50 of 901 rows — these rows as CSV

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