PREVIEW / etf_daily / 2012-04-18

all etf daily files

  file:    by_date/etf_daily/2012/2012-04-18.parquet
  size:    38 KB
  rows:    913

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-04-18	SPY	ETF	138.46	139.08	138.38	138.61	123884200.0
2012-04-18	QQQ	ETF	66.59	67.0	66.41	66.61	42536007.0
2012-04-18	IWM	ETF	80.41	80.67	79.83	80.21	49008100.0
2012-04-18	DIA	ETF	130.27	130.8	130.08	130.15	5057100.0
2012-04-18	GLD	ETF	159.49	160.12	159.07	159.31	7463000.0
2012-04-18	TLT	ETF	117.05	117.12	116.73	116.94	4074400.0
2012-04-18	AADR	ETF	30.63	30.63	30.55	30.55	600.0
2012-04-18	AAXJ	ETF	55.99	56.23	55.9	56.1	237800.0
2012-04-18	ACTV	ETF	16.85	16.88	16.63	16.72	119950.0
2012-04-18	ACWI	ETF	46.23	46.42	46.13	46.29	717500.0
2012-04-18	ACWV	ETF	54.08	54.08	54.08	54.08	200.0
2012-04-18	ACWX	ETF	39.68	39.99	39.68	39.83	187154.0
2012-04-18	ADRE	ETF	40.93	41.2871	40.93	41.2	16517.0
2012-04-18	AFK	ETF	28.7	28.8	28.646	28.764	14451.0
2012-04-18	AGEM	ETF	22.78	22.78	22.591	22.68	4834.0
2012-04-18	AGG	ETF	110.44	110.54	110.35	110.54	884300.0
2012-04-18	AGQ	ETF	206.36	208.08	204.04	206.64	216450.0
2012-04-18	AGZ	ETF	112.87	112.87	112.63	112.71	20833.0
2012-04-18	AIA	ETF	44.45	44.58	44.346	44.51	7834.0
2012-04-18	AIQ	ETF	7.2	7.2	6.95	7.05	7293.0
2012-04-18	AIS	ETF	2.94	2.99	2.8	2.95	1759094.0
2012-04-18	AIVI	ETF	39.99	40.24	39.94	40.03	28000.0
2012-04-18	AMJ	ETF	38.64	38.96	38.64	38.92	1370489.0
2012-04-18	AMLP	ETF	82.3	82.95	82.3	82.65	301140.0
2012-04-18	ANGL	ETF	25.55	28.29	25.52	25.52	17300.0
2012-04-18	AOA	ETF	35.86	35.93	35.82	35.92	6100.0
2012-04-18	AOK	ETF	30.06	30.09	30.0415	30.08	13006.0
2012-04-18	AOM	ETF	31.01	31.11	31.01	31.09	8707.0
2012-04-18	AOR	ETF	33.01	33.1	32.99	33.069	8388.0
2012-04-18	ARB	ETF	38.38	39.09	38.18	38.8	369633.0
2012-04-18	ARGT	ETF	18.88	19.18	18.5	18.5	5800.0
2012-04-18	ASEA	ETF	16.13	16.13	16.04	16.09	800.0
2012-04-18	AWAY	ETF	24.36	24.51	24.04	24.33	155235.0
2012-04-18	BAB	ETF	29.49	29.49	29.39	29.46	133024.0
2012-04-18	BAL	ETF	55.34	57.36	54.89	55.89	51323.0
2012-04-18	BALT	ETF	4.31	4.36	4.28	4.34	79096.0
2012-04-18	BBH	ETF	42.93	43.06	42.71	42.8	103400.0
2012-04-18	BCM	ETF	44.2199	44.2199	44.179	44.1999	2982.0
2012-04-18	BIB	ETF	11.2025	11.226	11.1137	11.161	52104.0
2012-04-18	BICK	ETF	25.74	25.8194	25.65	25.708	3843.0
2012-04-18	BIL	ETF	91.64	91.66	91.64	91.64	77500.0
2012-04-18	BIS	ETF	3862.4	3916.8	3862.4	3896.0	38.45
2012-04-18	BIV	ETF	87.61	87.68	87.54	87.65	257700.0
2012-04-18	BJK	ETF	36.35	36.72	36.35	36.61	13500.0
2012-04-18	BKF	ETF	40.22	40.5427	40.22	40.44	134842.0
2012-04-18	BKLN	ETF	24.45	24.47	24.38	24.38	108100.0
2012-04-18	BLV	ETF	91.14	91.18	90.93	91.02	19500.0
2012-04-18	BMVP	ETF	15.3367	15.3533	15.3367	15.3477	571.0
2012-04-18	BND	ETF	83.77	83.78	83.68	83.76	726200.0
2012-04-18	BNO	ETF	41.55	41.685	41.16	41.635	55800.0

> showing 50 of 913 rows — these rows as CSV

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