PREVIEW / etf_daily / 2012-11-15

all etf daily files

  file:    by_date/etf_daily/2012/2012-11-15.parquet
  size:    40 KB
  rows:    954

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-11-15	SPY	ETF	135.98	136.49	135.18	135.7	178128400.0
2012-11-15	QQQ	ETF	62.29	62.49	61.8	62.0299	55124159.0
2012-11-15	IWM	ETF	77.09	77.49	76.29	76.84	55966400.0
2012-11-15	DIA	ETF	125.57	126.05	125.01	125.51	7658000.0
2012-11-15	GLD	ETF	167.0	167.05	165.18	166.09	10023200.0
2012-11-15	TLT	ETF	126.1	127.02	126.0	126.48	5549600.0
2012-11-15	AADR	ETF	28.76	28.82	28.76	28.78	700.0
2012-11-15	AAXJ	ETF	55.62	55.82	55.38	55.68	159600.0
2012-11-15	ACTV	ETF	5.14	5.18	4.98	5.0	1056887.0
2012-11-15	ACWI	ETF	45.21	45.24	44.85	45.02	296400.0
2012-11-15	ACWV	ETF	54.67	54.86	54.61	54.77	7300.0
2012-11-15	ACWX	ETF	38.66	38.68	38.42	38.56	80884.0
2012-11-15	ADRE	ETF	37.39	37.51	37.198	37.34	58568.0
2012-11-15	AFK	ETF	30.585	30.829	30.4401	30.6	25703.0
2012-11-15	AGEM	ETF	21.73	21.73	21.47	21.6499	2333.0
2012-11-15	AGG	ETF	112.19	112.23	112.11	112.17	1532600.0
2012-11-15	AGQ	ETF	207.32	207.68	200.4	205.44	374925.0
2012-11-15	AGZ	ETF	113.94	114.04	113.93	114.04	17229.0
2012-11-15	AIA	ETF	43.82	43.94	43.61	43.91	14305.0
2012-11-15	AIQ	ETF	6.3	6.3	5.8	5.8	32371.0
2012-11-15	AIVI	ETF	38.62	38.66	38.31	38.44	44000.0
2012-11-15	ALTL	ETF	24.55	24.55	24.55	24.55	500.0
2012-11-15	AMJ	ETF	37.97	38.077	37.1	37.48	1943932.0
2012-11-15	AMLP	ETF	78.45	78.6	77.1	77.9	952280.0
2012-11-15	ANGL	ETF	26.44	26.44	26.27	26.3	14100.0
2012-11-15	AOA	ETF	35.36	35.4	35.17	35.33	16000.0
2012-11-15	AOK	ETF	30.1	30.16	30.07	30.1	23322.0
2012-11-15	AOM	ETF	31.04	31.0499	30.95	31.0244	13588.0
2012-11-15	AOR	ETF	32.79	32.82	32.65	32.65	137652.0
2012-11-15	ARB	ETF	35.29	35.6	34.64	35.08	99586.0
2012-11-15	ARGT	ETF	15.42	15.46	15.32	15.46	2800.0
2012-11-15	ASEA	ETF	16.42	16.42	16.24	16.32	7700.0
2012-11-15	AWAY	ETF	20.24	21.26	20.0	21.1365	892376.0
2012-11-15	BAB	ETF	30.4	30.55	30.38	30.49	241484.0
2012-11-15	BAL	ETF	46.51	47.189	46.48	47.08	18343.0
2012-11-15	BALT	ETF	3.08	3.11	2.85	3.01	218182.0
2012-11-15	BBH	ETF	51.25	51.25	50.39	50.94	37000.0
2012-11-15	BCM	ETF	43.82	43.82	43.82	43.82	113.0
2012-11-15	BIB	ETF	12.97	12.97	12.3375	12.68	81780.0
2012-11-15	BICK	ETF	23.03	23.04	22.86	22.92	4674.0
2012-11-15	BIL	ETF	91.62	91.64	91.62	91.64	304450.0
2012-11-15	BIS	ETF	3038.8	3096.8	3038.8	3039.2	280.5
2012-11-15	BIV	ETF	90.41	90.51	90.3	90.44	181100.0
2012-11-15	BJK	ETF	33.4	33.4	33.2	33.36	3900.0
2012-11-15	BKF	ETF	37.01	37.24	36.8501	37.01	94722.0
2012-11-15	BKLN	ETF	24.54	24.54	24.44	24.51	544100.0
2012-11-15	BLV	ETF	97.46	97.88	97.37	97.56	31000.0
2012-11-15	BMVP	ETF	15.2	15.24	15.11	15.19	35901.0
2012-11-15	BND	ETF	84.91	85.03	84.88	84.99	1045400.0
2012-11-15	BNO	ETF	39.97	40.1	39.295	39.495	99400.0

> showing 50 of 954 rows — these rows as CSV

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