PREVIEW / etf_daily / 2013-09-11

all etf daily files

  file:    by_date/etf_daily/2013/2013-09-11.parquet
  size:    41 KB
  rows:    1,018

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
2013-09-11	SPY	ETF	168.64	169.4	168.35	169.4	94545900.0
2013-09-11	QQQ	ETF	77.69	78.11	77.59	78.06	28138594.0
2013-09-11	IWM	ETF	104.79	105.22	104.53	105.01	26412500.0
2013-09-11	DIA	ETF	151.82	153.18	151.77	153.15	7044000.0
2013-09-11	GLD	ETF	131.58	131.81	131.26	131.7	5046600.0
2013-09-11	TLT	ETF	102.92	103.31	102.19	103.29	8962400.0
2013-09-11	AADR	ETF	35.08	35.18	35.08	35.08	600.0
2013-09-11	AAXJ	ETF	58.49	58.87	58.38	58.8	446400.0
2013-09-11	ACTV	ETF	10.08	10.62	10.02	10.19	628526.0
2013-09-11	ACWI	ETF	53.28	53.66	53.28	53.65	565000.0
2013-09-11	ACWV	ETF	61.2	61.44	61.0	61.43	29700.0
2013-09-11	ACWX	ETF	44.13	44.5	44.13	44.5	242917.0
2013-09-11	ADRE	ETF	37.27	37.46	37.17	37.39	21500.0
2013-09-11	AFK	ETF	29.35	29.78	29.35	29.6499	41187.0
2013-09-11	AGEM	ETF	22.48	22.6156	22.3	22.44	19773.0
2013-09-11	AGG	ETF	105.44	105.66	105.39	105.66	2315600.0
2013-09-11	AGQ	ETF	92.24	92.84	91.84	92.4	276300.0
2013-09-11	AGZ	ETF	110.03	110.2	109.9807	110.05	9132.0
2013-09-11	AIA	ETF	46.93	47.0099	46.7431	46.98	17562.0
2013-09-11	AIQ	ETF	24.74	24.88	23.55	23.67	58025.0
2013-09-11	AIVI	ETF	44.43	44.81	44.43	44.81	31900.0
2013-09-11	ALTL	ETF	29.97	30.068	29.92	29.99	15000.0
2013-09-11	AMJ	ETF	45.26	45.26	44.56	44.82	380007.0
2013-09-11	AMLP	ETF	86.45	87.55	86.45	87.2	431640.0
2013-09-11	ANGL	ETF	26.26	26.33	26.24	26.25	2300.0
2013-09-11	AOA	ETF	41.57	41.75	41.56	41.73	10000.0
2013-09-11	AOK	ETF	31.08	31.15	31.0339	31.15	25635.0
2013-09-11	AOM	ETF	33.01	33.08	32.941	33.05	26954.0
2013-09-11	AOR	ETF	36.5	36.63	36.499	36.63	19001.0
2013-09-11	ARB	ETF	47.52	47.65	47.48	47.64	206124.0
2013-09-11	ARGT	ETF	19.71	19.71	19.57	19.57	2500.0
2013-09-11	ASEA	ETF	16.24	16.37	16.19	16.37	19900.0
2013-09-11	ATMP	ETF	25.82	25.82	25.69	25.8	17300.0
2013-09-11	AVIV	ETF	22.38	22.514	22.21	22.28	128469.0
2013-09-11	AWAY	ETF	32.0	32.325	31.72	31.87	625298.0
2013-09-11	BAB	ETF	26.94	27.1	26.9	27.03	92960.0
2013-09-11	BAL	ETF	54.16	54.2299	53.87	53.87	7862.0
2013-09-11	BALT	ETF	5.5	5.64	5.33	5.56	706566.0
2013-09-11	BBH	ETF	82.4	82.75	81.38	82.4	72800.0
2013-09-11	BCM	ETF	41.13	41.13	40.9904	41.0683	894.0
2013-09-11	BFOR	ETF	6.7125	6.7225	6.685	6.7125	130400.0
2013-09-11	BIB	ETF	31.83	31.83	30.885	31.7	136688.0
2013-09-11	BICK	ETF	23.74	23.7632	23.74	23.7632	236.0
2013-09-11	BIL	ETF	91.6	91.6	91.58	91.58	417200.0
2013-09-11	BIS	ETF	1068.96	1071.6	1064.0	1064.0	45.75
2013-09-11	BIV	ETF	81.57	81.77	81.45	81.7	182500.0
2013-09-11	BIZD	ETF	20.47	20.5	20.4	20.4	37900.0
2013-09-11	BJK	ETF	46.28	46.55	46.25	46.54	16000.0
2013-09-11	BKF	ETF	37.31	37.54	37.17	37.47	132579.0
2013-09-11	BKLN	ETF	24.81	24.82	24.79	24.82	1953300.0

> showing 50 of 1,018 rows — these rows as CSV

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