PREVIEW / etf_daily / 2011-11-10

all etf daily files

  file:    by_date/etf_daily/2011/2011-11-10.parquet
  size:    37 KB
  rows:    881

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-11-10	SPY	ETF	124.79	124.94	123.02	124.32	231866500.0
2011-11-10	QQQ	ETF	57.4	57.42	56.23	56.78	66052381.0
2011-11-10	IWM	ETF	73.12	73.23	71.63	72.47	72175100.0
2011-11-10	DIA	ETF	118.96	119.55	117.88	118.89	9960400.0
2011-11-10	GLD	ETF	172.43	172.59	168.83	171.14	11848700.0
2011-11-10	TLT	ETF	116.78	117.61	115.21	116.36	11644600.0
2011-11-10	AAXJ	ETF	52.44	52.76	51.94	52.47	740800.0
2011-11-10	ACTV	ETF	13.12	13.34	12.68	12.87	35520.0
2011-11-10	ACWI	ETF	42.98	42.98	42.25	42.6	1037100.0
2011-11-10	ACWV	ETF	50.13	50.34	50.13	50.31	8000.0
2011-11-10	ACWX	ETF	38.11	38.11	37.37	37.74	617061.0
2011-11-10	ADRE	ETF	40.69	40.84	40.1	40.27	30306.0
2011-11-10	AFK	ETF	28.33	28.33	28.07	28.21	3382.0
2011-11-10	AGEM	ETF	22.41	22.41	22.14	22.14	3199.0
2011-11-10	AGG	ETF	109.9	110.16	109.67	109.92	1307800.0
2011-11-10	AGQ	ETF	264.48	265.24	249.0	262.64	393600.0
2011-11-10	AGZ	ETF	112.72	112.73	112.31	112.68	26383.0
2011-11-10	AIA	ETF	40.95	40.98	40.34	40.62	60497.0
2011-11-10	AIQ	ETF	6.45	6.7	6.3505	6.45	38657.0
2011-11-10	AIS	ETF	2.37	2.37	2.27	2.28	400941.0
2011-11-10	AIVI	ETF	40.59	40.72	40.04	40.48	76400.0
2011-11-10	AMJ	ETF	36.75	37.14	36.1	36.94	682352.0
2011-11-10	AMLP	ETF	78.4	78.75	77.95	78.65	235200.0
2011-11-10	AOA	ETF	33.07	33.07	32.69	32.88	20900.0
2011-11-10	AOK	ETF	29.32	29.32	29.26	29.29	24568.0
2011-11-10	AOM	ETF	29.94	29.97	29.84	29.92	47107.0
2011-11-10	AOR	ETF	31.15	31.15	30.9864	31.08	2788.0
2011-11-10	ARB	ETF	40.57	40.8	39.295	40.02	254633.0
2011-11-10	ARGT	ETF	22.32	22.38	22.32	22.38	1000.0
2011-11-10	ASEA	ETF	14.85	15.01	14.85	15.01	4300.0
2011-11-10	AWAY	ETF	33.01	33.9	33.01	33.73	69092.0
2011-11-10	BAB	ETF	28.3	28.63	28.3	28.54	148379.0
2011-11-10	BAL	ETF	61.59	61.7948	60.91	61.11	102545.0
2011-11-10	BALT	ETF	5.51	5.65	5.38	5.54	132130.0
2011-11-10	BBH	ETF	34.9067	35.1067	34.79	35.0733	27300.0
2011-11-10	BCM	ETF	45.02	45.02	45.0	45.0	400.0
2011-11-10	BIB	ETF	7.125	7.125	6.875	7.0075	20800.0
2011-11-10	BICK	ETF	25.5	25.5	25.0	25.14	6668.0
2011-11-10	BIL	ETF	91.68	91.7	91.68	91.7	362150.0
2011-11-10	BIS	ETF	6752.0	6752.0	6752.0	6752.0	2.25
2011-11-10	BIV	ETF	87.71	87.92	87.42	87.77	109600.0
2011-11-10	BJK	ETF	31.35	31.35	30.91	31.15	11900.0
2011-11-10	BKF	ETF	39.97	39.97	39.33	39.6	67419.0
2011-11-10	BKLN	ETF	24.02	24.13	24.02	24.12	52000.0
2011-11-10	BLNG	ETF	53.96	53.96	53.96	53.96	200.0
2011-11-10	BLV	ETF	91.24	91.68	90.0	90.93	37700.0
2011-11-10	BMVP	ETF	13.53	13.71	13.53	13.68	4130.0
2011-11-10	BND	ETF	83.61	83.77	83.45	83.65	2487500.0
2011-11-10	BNO	ETF	38.85	39.15	38.43	38.835	321800.0
2011-11-10	BRF	ETF	44.28	44.39	43.31	43.58	159857.0

> showing 50 of 881 rows — these rows as CSV

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