PREVIEW / etf_daily / 2012-03-09

all etf daily files

  file:    by_date/etf_daily/2012/2012-03-09.parquet
  size:    38 KB
  rows:    925

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-03-09	SPY	ETF	137.3	137.93	137.13	137.57	122836800.0
2012-03-09	QQQ	ETF	64.85	65.14	64.82	65.02	43117170.0
2012-03-09	IWM	ETF	80.52	82.15	80.46	81.6	61462900.0
2012-03-09	DIA	ETF	129.22	129.59	128.94	129.15	6248400.0
2012-03-09	GLD	ETF	163.64	166.57	163.25	166.38	13698200.0
2012-03-09	TLT	ETF	115.49	115.99	114.9	115.97	6975600.0
2012-03-09	AADR	ETF	30.42	30.44	30.36	30.39	1100.0
2012-03-09	AAXJ	ETF	57.52	57.64	57.3	57.45	269500.0
2012-03-09	ACTV	ETF	16.3	16.98	16.162	16.69	671094.0
2012-03-09	ACWI	ETF	46.61	46.72	46.46	46.6	426500.0
2012-03-09	ACWX	ETF	40.7	40.9	40.64	40.77	137799.0
2012-03-09	ADRE	ETF	43.06	43.236	42.96	43.03	21999.0
2012-03-09	AFK	ETF	30.21	30.359	30.13	30.269	14639.0
2012-03-09	AGEM	ETF	23.86	24.02	23.86	24.0	1198.0
2012-03-09	AGG	ETF	110.23	110.23	110.13	110.19	710900.0
2012-03-09	AGQ	ETF	233.96	248.6	231.88	245.64	704775.0
2012-03-09	AGZ	ETF	112.8	112.8693	112.65	112.71	34016.0
2012-03-09	AIA	ETF	44.8401	45.083	44.8401	44.92	14682.0
2012-03-09	AIQ	ETF	6.5	6.945	6.5	6.8	13083.0
2012-03-09	AIS	ETF	3.0	3.0	2.88	2.94	1833727.0
2012-03-09	AIVI	ETF	41.6	41.74	41.49	41.56	56300.0
2012-03-09	AMJ	ETF	40.41	40.54	40.3	40.53	726938.0
2012-03-09	AMLP	ETF	84.55	84.8	84.3	84.8	285100.0
2012-03-09	AOA	ETF	35.9	36.09	35.9	35.97	10500.0
2012-03-09	AOK	ETF	30.02	30.0999	30.02	30.04	17897.0
2012-03-09	AOM	ETF	31.08	31.15	31.04	31.07	34694.0
2012-03-09	AOR	ETF	33.01	33.1	32.91	33.05	14505.0
2012-03-09	ARB	ETF	33.97	34.7	33.77	34.47	162571.0
2012-03-09	ARGT	ETF	22.6	22.6	22.6	22.6	150.0
2012-03-09	ASEA	ETF	15.99	16.01	15.91	15.94	1700.0
2012-03-09	AWAY	ETF	25.46	26.06	25.25	25.91	181926.0
2012-03-09	BAB	ETF	29.38	29.43	29.3	29.43	130600.0
2012-03-09	BAL	ETF	53.91	55.0	53.75	53.98	25294.0
2012-03-09	BALT	ETF	4.0	4.18	3.979	4.03	150178.0
2012-03-09	BBH	ETF	42.26	42.47	42.26	42.33	58300.0
2012-03-09	BCM	ETF	45.95	46.38	45.95	46.3225	1040.0
2012-03-09	BIB	ETF	11.2188	11.2725	11.1676	11.203	21872.0
2012-03-09	BICK	ETF	27.44	27.59	27.44	27.46	9517.0
2012-03-09	BIL	ETF	91.64	91.66	91.64	91.66	194300.0
2012-03-09	BIS	ETF	3948.8	3948.8	3901.12	3929.6	10.0
2012-03-09	BITS	ETF	20.68	22.88	20.6	20.92	1523.0
2012-03-09	BIV	ETF	87.65	87.7	87.51	87.69	140900.0
2012-03-09	BJK	ETF	34.93	34.93	34.59	34.59	9000.0
2012-03-09	BKF	ETF	42.84	43.19	42.8	42.91	129488.0
2012-03-09	BKLN	ETF	24.52	24.57	24.49	24.53	1590900.0
2012-03-09	BLNG	ETF	52.9441	52.9441	52.9441	52.9441	110.0
2012-03-09	BLV	ETF	90.5	90.6	90.15	90.6	57400.0
2012-03-09	BMVP	ETF	15.193	15.279	15.177	15.247	6094.0
2012-03-09	BND	ETF	83.56	83.56	83.43	83.52	1251700.0
2012-03-09	BNO	ETF	43.765	44.195	43.655	44.045	54400.0

> showing 50 of 925 rows — these rows as CSV

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