PREVIEW / etf_daily / 2013-08-14

all etf daily files

  file:    by_date/etf_daily/2013/2013-08-14.parquet
  size:    41 KB
  rows:    1,013

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-14	SPY	ETF	169.53	169.8	168.7	168.74	79829200.0
2013-08-14	QQQ	ETF	77.07	77.18	76.7	76.81	29920959.0
2013-08-14	IWM	ETF	104.48	104.64	104.01	104.04	23629000.0
2013-08-14	DIA	ETF	154.27	154.43	153.11	153.32	6372100.0
2013-08-14	GLD	ETF	127.66	129.07	127.57	129.0	8713200.0
2013-08-14	TLT	ETF	104.94	105.36	104.87	105.15	6431600.0
2013-08-14	AADR	ETF	34.29	34.29	34.29	34.29	400.0
2013-08-14	AAXJ	ETF	57.16	57.18	57.01	57.09	134400.0
2013-08-14	ACTV	ETF	10.1	10.24	9.83	9.87	440923.0
2013-08-14	ACWI	ETF	53.21	53.27	53.03	53.07	1302000.0
2013-08-14	ACWV	ETF	62.07	62.11	61.8	61.92	33200.0
2013-08-14	ACWX	ETF	43.67	43.8	43.67	43.74	543705.0
2013-08-14	ADRE	ETF	36.08	36.266	36.08	36.08	16830.0
2013-08-14	AFK	ETF	29.69	29.7	29.6	29.6713	26261.0
2013-08-14	AGEM	ETF	21.8021	21.93	21.7601	21.7814	1771.0
2013-08-14	AGG	ETF	106.55	106.65	106.5	106.51	756200.0
2013-08-14	AGQ	ETF	80.84	83.6	80.8	83.56	464725.0
2013-08-14	AGZ	ETF	110.85	110.95	110.74	110.8	17700.0
2013-08-14	AIA	ETF	44.8601	44.94	44.81	44.81	72208.0
2013-08-14	AIQ	ETF	25.06	25.1	24.441	24.73	102754.0
2013-08-14	AIVI	ETF	43.48	43.6	43.48	43.55	18500.0
2013-08-14	ALTL	ETF	29.9418	29.9418	29.9418	29.9418	126.0
2013-08-14	AMJ	ETF	45.59	46.1	45.49	45.84	545580.0
2013-08-14	AMLP	ETF	87.3	87.35	86.65	87.0	527900.0
2013-08-14	ANGL	ETF	26.4	26.45	26.4	26.42	700.0
2013-08-14	AOA	ETF	41.64	41.68	41.56	41.56	22500.0
2013-08-14	AOK	ETF	31.1742	31.2	31.15	31.15	8146.0
2013-08-14	AOM	ETF	33.1199	33.12	33.03	33.06	20023.0
2013-08-14	AOR	ETF	36.58	36.6123	36.51	36.51	11897.0
2013-08-14	ARB	ETF	46.05	46.2	45.72	45.76	259470.0
2013-08-14	ARGT	ETF	19.17	19.25	19.17	19.2	6600.0
2013-08-14	ASEA	ETF	17.21	17.21	17.13	17.16	2100.0
2013-08-14	ATMP	ETF	26.36	26.36	26.06	26.1	105000.0
2013-08-14	AVIV	ETF	24.16	24.66	24.071	24.3	46587.0
2013-08-14	AWAY	ETF	30.7	31.42	30.5	31.26	654238.0
2013-08-14	BAB	ETF	27.57	27.65	27.4993	27.64	193278.0
2013-08-14	BAL	ETF	59.15	59.31	58.466	58.64	8196.0
2013-08-14	BALT	ETF	3.93	4.05	3.71	3.84	433761.0
2013-08-14	BBH	ETF	77.42	78.04	77.22	77.22	34800.0
2013-08-14	BCM	ETF	40.5207	40.556	40.5207	40.556	2423.0
2013-08-14	BFOR	ETF	6.675	6.7025	6.635	6.635	57600.0
2013-08-14	BIB	ETF	27.9225	28.53	27.9225	28.015	82172.0
2013-08-14	BICK	ETF	22.44	22.44	22.37	22.39	3300.0
2013-08-14	BIL	ETF	91.58	91.6	91.58	91.6	131400.0
2013-08-14	BIS	ETF	1202.0	1218.48	1193.28	1218.48	87.5
2013-08-14	BIV	ETF	82.95	83.02	82.87	82.92	139900.0
2013-08-14	BIZD	ETF	20.05	20.12	19.96	20.1	7800.0
2013-08-14	BJK	ETF	43.26	43.29	43.15	43.29	12900.0
2013-08-14	BKF	ETF	35.97	36.0	35.8295	35.87	154528.0
2013-08-14	BKLN	ETF	24.89	24.89	24.85	24.88	1533200.0

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

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