PREVIEW / etf_daily / 2012-05-10

all etf daily files

  file:    by_date/etf_daily/2012/2012-05-10.parquet
  size:    39 KB
  rows:    942

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-05-10	SPY	ETF	136.68	136.85	135.71	136.02	150600000.0
2012-05-10	QQQ	ETF	64.61	64.63	63.95	64.19	49448870.0
2012-05-10	IWM	ETF	79.32	79.55	78.63	79.1	45697800.0
2012-05-10	DIA	ETF	128.81	129.28	128.21	128.44	5325000.0
2012-05-10	GLD	ETF	155.16	155.57	154.64	154.77	7460100.0
2012-05-10	TLT	ETF	118.02	118.62	117.44	118.52	6300000.0
2012-05-10	AADR	ETF	29.12	29.12	29.12	29.12	100.0
2012-05-10	AAXJ	ETF	54.52	54.52	54.13	54.19	650000.0
2012-05-10	ACTV	ETF	14.92	15.02	14.78	14.87	340766.0
2012-05-10	ACWI	ETF	45.06	45.11	44.77	44.81	756000.0
2012-05-10	ACWV	ETF	54.19	54.25	53.93	54.09	43800.0
2012-05-10	ACWX	ETF	38.55	38.58	38.29	38.35	91745.0
2012-05-10	ADRE	ETF	39.45	39.59	39.262	39.29	22054.0
2012-05-10	AFK	ETF	29.32	29.5	29.29	29.29	148651.0
2012-05-10	AGEM	ETF	21.57	21.58	21.4505	21.4505	608.0
2012-05-10	AGG	ETF	110.72	110.76	110.63	110.71	527000.0
2012-05-10	AGQ	ETF	177.36	179.28	174.12	174.4	254050.0
2012-05-10	AGZ	ETF	113.09	113.14	113.0042	113.074	7993.0
2012-05-10	AIA	ETF	43.62	43.64	43.31	43.31	6222.0
2012-05-10	AIQ	ETF	6.7	9.3	6.6	6.85	179327.0
2012-05-10	AIS	ETF	3.21	3.21	3.11	3.13	478907.0
2012-05-10	AIVI	ETF	39.71	39.78	39.43	39.47	64600.0
2012-05-10	AMJ	ETF	38.82	39.1514	38.82	39.01	518200.0
2012-05-10	AMLP	ETF	80.95	81.45	80.95	81.35	421540.0
2012-05-10	ANGL	ETF	26.12	26.12	25.39	25.42	11600.0
2012-05-10	AOA	ETF	35.46	35.46	35.27	35.3	9300.0
2012-05-10	AOK	ETF	29.98	29.98	29.87	29.89	65328.0
2012-05-10	AOM	ETF	30.9	30.9	30.81	30.81	18507.0
2012-05-10	AOR	ETF	32.78	32.78	32.608	32.67	12827.0
2012-05-10	ARB	ETF	36.31	36.4	35.83	36.04	148758.0
2012-05-10	ARGT	ETF	17.62	17.62	17.42	17.42	400.0
2012-05-10	ASEA	ETF	15.96	16.01	15.9	15.96	11500.0
2012-05-10	AWAY	ETF	25.62	25.64	25.03	25.18	254534.0
2012-05-10	BAB	ETF	29.55	29.66	29.526	29.66	85062.0
2012-05-10	BAL	ETF	53.0	53.0	50.65	50.699	140336.0
2012-05-10	BALT	ETF	4.18	4.204	4.04	4.06	32129.0
2012-05-10	BBH	ETF	45.94	46.25	45.94	46.13	13600.0
2012-05-10	BCM	ETF	42.98	42.98	42.844	42.844	1180.0
2012-05-10	BIB	ETF	12.0645	12.2474	12.0645	12.2474	4640.0
2012-05-10	BICK	ETF	23.92	24.05	23.8076	23.81	6660.0
2012-05-10	BIL	ETF	91.64	91.66	91.64	91.66	457000.0
2012-05-10	BIS	ETF	3550.4	3550.576	3521.6	3524.8	9.5
2012-05-10	BIV	ETF	88.0	88.12	87.91	88.12	174300.0
2012-05-10	BJK	ETF	34.75	34.82	34.58	34.58	6000.0
2012-05-10	BKF	ETF	38.07	38.07	37.65	37.71	167689.0
2012-05-10	BKLN	ETF	24.77	24.78	24.68	24.68	4607100.0
2012-05-10	BLNG	ETF	47.7	47.95	47.7	47.95	460.0
2012-05-10	BLV	ETF	91.72	92.06	91.44	92.04	45200.0
2012-05-10	BMVP	ETF	15.07	15.12	15.04	15.06	5761.0
2012-05-10	BND	ETF	83.85	83.94	83.76	83.89	1650600.0

> showing 50 of 942 rows — these rows as CSV

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