PREVIEW / etf_daily / 2013-08-15

all etf daily files

  file:    by_date/etf_daily/2013/2013-08-15.parquet
  size:    42 KB
  rows:    1,022

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-08-15	SPY	ETF	167.41	167.43	166.09	166.38	152931800.0
2013-08-15	QQQ	ETF	75.98	75.99	75.29	75.51	39406562.0
2013-08-15	IWM	ETF	102.84	102.96	101.89	102.11	50044500.0
2013-08-15	DIA	ETF	152.1	152.1	150.97	151.12	10021900.0
2013-08-15	GLD	ETF	128.06	132.36	127.98	131.69	17226300.0
2013-08-15	TLT	ETF	104.1	104.63	103.69	103.73	11846300.0
2013-08-15	AADR	ETF	33.68	34.1	33.68	34.1	1600.0
2013-08-15	AAXJ	ETF	56.44	56.55	56.07	56.38	546000.0
2013-08-15	ACTV	ETF	9.62	9.87	9.37	9.39	413171.0
2013-08-15	ACWI	ETF	52.58	52.62	52.17	52.5	1234500.0
2013-08-15	ACWV	ETF	61.36	61.36	61.0	61.2	142300.0
2013-08-15	ACWX	ETF	43.26	43.46	42.98	43.39	282978.0
2013-08-15	ADRE	ETF	35.67	36.0095	35.59	35.901	20162.0
2013-08-15	AFK	ETF	29.65	29.7099	29.081	29.43	15957.0
2013-08-15	AGEM	ETF	21.53	21.64	21.5	21.64	1482.0
2013-08-15	AGG	ETF	106.23	106.34	106.06	106.13	765600.0
2013-08-15	AGQ	ETF	83.2	93.84	83.2	92.12	1197875.0
2013-08-15	AGZ	ETF	110.94	110.94	110.511	110.6177	14995.0
2013-08-15	AIA	ETF	44.48	44.56	44.18	44.46	120901.0
2013-08-15	AIQ	ETF	24.61	24.65	21.65	21.99	197080.0
2013-08-15	AIVI	ETF	42.95	43.33	42.82	43.32	38900.0
2013-08-15	AMJ	ETF	45.41	45.86	45.29	45.57	891842.0
2013-08-15	AMLP	ETF	86.8	87.25	86.45	86.9	675280.0
2013-08-15	ANGL	ETF	26.35	26.38	26.26	26.32	3800.0
2013-08-15	AOA	ETF	41.25	41.25	41.0	41.1	33000.0
2013-08-15	AOK	ETF	31.0	31.02	30.93	30.978	128470.0
2013-08-15	AOM	ETF	32.82	32.84	32.733	32.81	131341.0
2013-08-15	AOR	ETF	36.26	36.29	36.14	36.1999	209780.0
2013-08-15	ARB	ETF	45.75	45.97	45.51	45.71	193054.0
2013-08-15	ARGT	ETF	19.11	19.27	18.96	19.27	17000.0
2013-08-15	ASEA	ETF	16.84	16.92	16.74	16.9	11500.0
2013-08-15	ATMP	ETF	26.18	26.18	26.02	26.13	82500.0
2013-08-15	AVIV	ETF	24.01	24.2	23.5	23.7	119767.0
2013-08-15	AWAY	ETF	31.0	31.04	30.13	30.2	786101.0
2013-08-15	BAB	ETF	27.37	27.4	27.21	27.21	923720.0
2013-08-15	BAL	ETF	58.35	58.99	58.0	58.99	11386.0
2013-08-15	BALT	ETF	3.83	4.29	3.83	4.21	437872.0
2013-08-15	BBH	ETF	76.16	76.32	74.92	75.39	176800.0
2013-08-15	BCM	ETF	40.931	41.15	40.931	41.0755	2030.0
2013-08-15	BFOR	ETF	6.565	6.565	6.505	6.5225	247600.0
2013-08-15	BIB	ETF	27.5	27.505	26.4945	26.7575	208736.0
2013-08-15	BICK	ETF	22.23	22.25	22.05	22.1527	5116.0
2013-08-15	BIL	ETF	91.6	91.6	91.58	91.6	668500.0
2013-08-15	BIS	ETF	1249.92	1279.72	1249.92	1268.0	123.5
2013-08-15	BIV	ETF	82.48	82.71	82.36	82.52	290200.0
2013-08-15	BIZD	ETF	19.92	19.92	19.81	19.86	10300.0
2013-08-15	BJK	ETF	42.57	42.84	42.55	42.8	23300.0
2013-08-15	BKF	ETF	35.53	35.63	35.27	35.56	82835.0
2013-08-15	BKLN	ETF	24.8	24.8	24.73	24.78	2298100.0
2013-08-15	BLV	ETF	81.93	82.15	81.67	81.7	53800.0

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

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