PREVIEW / etf_daily / 2012-10-22

all etf daily files

  file:    by_date/etf_daily/2012/2012-10-22.parquet
  size:    38 KB
  rows:    939

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
2012-10-22	SPY	ETF	143.15	143.67	142.28	143.41	125578600.0
2012-10-22	QQQ	ETF	65.62	66.19	65.5	66.02	38621408.0
2012-10-22	IWM	ETF	81.64	81.97	81.35	81.83	30682000.0
2012-10-22	DIA	ETF	132.93	133.39	132.04	133.1	5591900.0
2012-10-22	GLD	ETF	167.08	167.63	167.03	167.58	6366200.0
2012-10-22	TLT	ETF	121.43	121.84	120.94	120.96	6910600.0
2012-10-22	AAXJ	ETF	56.87	57.09	56.57	56.9	274900.0
2012-10-22	ACTV	ETF	9.94	9.94	9.54	9.63	569010.0
2012-10-22	ACWI	ETF	47.21	47.3	46.88	47.24	257100.0
2012-10-22	ACWV	ETF	56.5	56.6	56.36	56.49	7400.0
2012-10-22	ACWX	ETF	40.22	40.27	39.98	40.27	136261.0
2012-10-22	ADRE	ETF	39.37	39.67	39.32	39.57	39637.0
2012-10-22	AFK	ETF	31.72	31.96	31.66	31.9	25753.0
2012-10-22	AGEM	ETF	22.75	22.77	22.65	22.65	3400.0
2012-10-22	AGG	ETF	111.9	111.96	111.8	111.8	438100.0
2012-10-22	AGQ	ETF	201.28	205.2	200.96	204.8	243375.0
2012-10-22	AGZ	ETF	113.5	113.61	113.49	113.61	8510.0
2012-10-22	AIA	ETF	45.06	45.06	44.8562	45.03	4056.0
2012-10-22	AIQ	ETF	6.8	7.1	6.8	6.85	3832.0
2012-10-22	AIVI	ETF	41.09	41.09	40.8	41.06	12700.0
2012-10-22	AMJ	ETF	40.61	41.05	40.59	40.89	284502.0
2012-10-22	AMLP	ETF	83.2	83.7	83.15	83.4	243100.0
2012-10-22	ANGL	ETF	26.89	26.99	26.89	26.99	1800.0
2012-10-22	AOA	ETF	36.71	36.79	36.56	36.75	13500.0
2012-10-22	AOK	ETF	30.46	30.5	30.43	30.47	23671.0
2012-10-22	AOM	ETF	31.6	31.6	31.5	31.5992	17148.0
2012-10-22	AOR	ETF	33.69	33.71	33.5695	33.7	7794.0
2012-10-22	ARB	ETF	36.6	36.94	36.29	36.78	119317.0
2012-10-22	ARGT	ETF	17.62	17.62	17.38	17.42	6800.0
2012-10-22	ASEA	ETF	16.88	16.88	16.74	16.79	3800.0
2012-10-22	AWAY	ETF	25.5	25.52	24.96	25.1	177182.0
2012-10-22	BAB	ETF	29.79	29.87	29.76	29.77	144647.0
2012-10-22	BAL	ETF	50.8	51.25	50.75	50.79	9381.0
2012-10-22	BALT	ETF	3.36	3.5	3.36	3.4	44577.0
2012-10-22	BBH	ETF	52.97	53.25	52.52	53.11	59000.0
2012-10-22	BCM	ETF	45.07	45.07	45.03	45.04	1241.0
2012-10-22	BIB	ETF	15.1425	15.1425	14.685	14.9725	104668.0
2012-10-22	BICK	ETF	23.79	24.0	23.79	23.891	6033.0
2012-10-22	BIL	ETF	91.62	91.64	91.62	91.62	78600.0
2012-10-22	BIS	ETF	2660.8	2705.6	2660.8	2670.4	104.5
2012-10-22	BIV	ETF	89.83	89.87	89.68	89.75	267400.0
2012-10-22	BJK	ETF	34.43	34.43	34.35	34.36	1300.0
2012-10-22	BKF	ETF	38.91	39.16	38.81	39.07	129402.0
2012-10-22	BKLN	ETF	24.93	24.93	24.91	24.93	1278900.0
2012-10-22	BLV	ETF	95.83	96.03	95.51	95.59	169900.0
2012-10-22	BMVP	ETF	15.96	16.0	15.88	15.92	6258.0
2012-10-22	BND	ETF	84.67	84.68	84.53	84.56	588400.0
2012-10-22	BNO	ETF	40.18	40.34	39.685	39.9	49200.0
2012-10-22	BOIL	ETF	1189000.0	1196600.0	1095600.0	1099400.0	24.8
2012-10-22	BOND	ETF	109.26	109.28	109.21	109.24	242242.0

> showing 50 of 939 rows — these rows as CSV

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