PREVIEW / etf_daily / 2011-12-21

all etf daily files

  file:    by_date/etf_daily/2011/2011-12-21.parquet
  size:    37 KB
  rows:    896

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-21	SPY	ETF	123.93	124.36	122.75	124.17	194230900.0
2011-12-21	QQQ	ETF	55.64	55.64	54.4875	55.13	78552013.0
2011-12-21	IWM	ETF	73.53	74.39	72.73	74.16	59194600.0
2011-12-21	DIA	ETF	120.8	120.87	119.69	120.81	6679800.0
2011-12-21	GLD	ETF	156.98	157.53	156.13	157.16	11996100.0
2011-12-21	TLT	ETF	120.63	120.83	119.07	119.1	11600100.0
2011-12-21	AADR	ETF	27.65	27.77	27.49	27.77	15600.0
2011-12-21	AAXJ	ETF	49.78	50.02	49.31	50.01	279000.0
2011-12-21	ACTV	ETF	13.2	13.25	12.95	13.16	103658.0
2011-12-21	ACWI	ETF	41.55	41.74	41.26	41.69	1118200.0
2011-12-21	ACWV	ETF	50.43	50.92	50.43	50.92	4000.0
2011-12-21	ACWX	ETF	36.32	36.3316	35.97	36.33	1132958.0
2011-12-21	ADRE	ETF	37.64	37.76	37.23	37.7	39302.0
2011-12-21	AFK	ETF	26.7	26.74	26.416	26.53	35238.0
2011-12-21	AGEM	ETF	20.8	20.8399	20.58	20.8399	9424.0
2011-12-21	AGG	ETF	109.99	110.03	109.69	109.73	930000.0
2011-12-21	AGQ	ETF	190.68	193.72	187.8	191.72	479600.0
2011-12-21	AGZ	ETF	112.66	112.91	112.53	112.53	14717.0
2011-12-21	AIA	ETF	38.98	39.19	38.62	39.15	38111.0
2011-12-21	AIQ	ETF	5.0	5.3	4.9	5.3	15476.0
2011-12-21	AIS	ETF	1.79	1.85	1.75	1.85	1151759.0
2011-12-21	AIVI	ETF	38.89	38.91	38.49	38.89	156200.0
2011-12-21	AMJ	ETF	37.84	38.06	37.5	38.06	1276572.0
2011-12-21	AMLP	ETF	81.9	83.1	81.4	81.6	318560.0
2011-12-21	AOA	ETF	32.85	33.0	32.64	32.9	15500.0
2011-12-21	AOK	ETF	29.32	29.32	29.24	29.32	11529.0
2011-12-21	AOM	ETF	29.88	29.94	29.811	29.94	75330.0
2011-12-21	AOR	ETF	31.07	31.09	30.95	31.09	13055.0
2011-12-21	ARB	ETF	35.43	35.66	34.67	35.49	128411.0
2011-12-21	ARGT	ETF	21.42	21.42	21.42	21.42	150.0
2011-12-21	ASEA	ETF	14.75	14.78	14.66	14.75	2300.0
2011-12-21	AWAY	ETF	20.6	20.91	20.0	20.75	256098.0
2011-12-21	BAB	ETF	28.59	28.709	28.45	28.64	273615.0
2011-12-21	BAL	ETF	53.3708	53.9201	53.28	53.58	6566.0
2011-12-21	BALT	ETF	4.95	4.97	4.81	4.9	77896.0
2011-12-21	BBH	ETF	36.1233	36.1233	35.0433	35.25	22800.0
2011-12-21	BCM	ETF	42.39	42.97	42.39	42.95	35808.0
2011-12-21	BIB	ETF	8.3133	8.4	8.3133	8.3887	4000.0
2011-12-21	BICK	ETF	22.78	22.8188	22.56	22.7774	34324.0
2011-12-21	BIL	ETF	91.68	91.68	91.66	91.68	299450.0
2011-12-21	BIS	ETF	5596.8	5596.8	5414.4	5414.4	14.5
2011-12-21	BITS	ETF	22.92	23.0	22.32	22.96	6666.0
2011-12-21	BIV	ETF	87.73	87.82	87.51	87.58	155700.0
2011-12-21	BJK	ETF	29.82	30.05	29.56	29.96	14900.0
2011-12-21	BKF	ETF	36.25	36.35	35.73	36.26	147643.0
2011-12-21	BKLN	ETF	23.68	23.82	23.68	23.82	40800.0
2011-12-21	BLV	ETF	92.15	92.15	91.28	91.31	35100.0
2011-12-21	BMVP	ETF	13.47	13.54	13.38	13.5	5380.0
2011-12-21	BND	ETF	83.89	83.9	83.62	83.62	1065100.0
2011-12-21	BNO	ETF	37.155	37.5	36.96	37.43	113800.0

> showing 50 of 896 rows — these rows as CSV

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