PREVIEW / etf_daily / 2013-08-16

all etf daily files

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

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-16	SPY	ETF	166.06	166.63	165.5	165.83	130868200.0
2013-08-16	QQQ	ETF	75.54	75.87	75.35	75.485	23824932.0
2013-08-16	IWM	ETF	101.81	102.38	101.55	101.68	36059500.0
2013-08-16	DIA	ETF	150.58	151.06	150.19	150.5	7035200.0
2013-08-16	GLD	ETF	132.56	133.27	131.39	132.58	14447100.0
2013-08-16	TLT	ETF	103.96	103.97	102.67	103.37	10175900.0
2013-08-16	AADR	ETF	34.01	34.08	33.95	33.95	1200.0
2013-08-16	AAXJ	ETF	56.69	56.7	56.2	56.24	647200.0
2013-08-16	ACTV	ETF	9.33	9.84	9.32	9.61	518575.0
2013-08-16	ACWI	ETF	52.52	52.62	52.33	52.43	680400.0
2013-08-16	ACWV	ETF	61.31	61.31	60.83	60.98	28300.0
2013-08-16	ACWX	ETF	43.56	43.56	43.38	43.41	430452.0
2013-08-16	ADRE	ETF	35.92	35.92	35.51	35.54	215558.0
2013-08-16	AFK	ETF	29.4671	29.52	29.2335	29.41	69909.0
2013-08-16	AGEM	ETF	21.4457	21.4457	21.4036	21.4036	381.0
2013-08-16	AGG	ETF	106.21	106.21	105.73	105.83	777300.0
2013-08-16	AGQ	ETF	94.6	95.64	92.04	93.76	819800.0
2013-08-16	AGZ	ETF	110.6678	110.6678	110.39	110.54	378638.0
2013-08-16	AIA	ETF	44.75	44.9306	44.6	44.63	85009.0
2013-08-16	AIQ	ETF	21.77	22.34	21.16	22.09	135206.0
2013-08-16	AIVI	ETF	43.4	43.59	43.36	43.57	38300.0
2013-08-16	ALTL	ETF	29.3876	29.3876	29.3876	29.3876	400.0
2013-08-16	AMJ	ETF	45.41	46.0	45.14	45.41	940990.0
2013-08-16	AMLP	ETF	86.95	87.05	86.55	86.75	430460.0
2013-08-16	ANGL	ETF	26.33	26.39	26.33	26.35	3600.0
2013-08-16	AOA	ETF	41.08	41.18	40.95	41.03	25000.0
2013-08-16	AOK	ETF	30.95	30.9999	30.89	30.95	17741.0
2013-08-16	AOM	ETF	32.82	32.82	32.68	32.69	53145.0
2013-08-16	AOR	ETF	36.19	36.23	36.05	36.1	15869.0
2013-08-16	ARB	ETF	45.56	45.64	45.42	45.5	255081.0
2013-08-16	ARGT	ETF	19.3	19.33	19.05	19.05	7500.0
2013-08-16	ASEA	ETF	16.85	16.85	16.74	16.75	10300.0
2013-08-16	ATMP	ETF	26.19	26.23	25.98	26.01	283000.0
2013-08-16	AVIV	ETF	23.7	23.86	22.64	23.14	236283.0
2013-08-16	AWAY	ETF	30.14	30.14	29.51	29.58	656198.0
2013-08-16	BAB	ETF	27.3	27.33	26.8	27.11	463464.0
2013-08-16	BAL	ETF	59.27	60.22	59.12	59.83	204796.0
2013-08-16	BALT	ETF	4.22	4.5	4.22	4.33	385361.0
2013-08-16	BBH	ETF	75.21	75.75	74.9	75.0	59900.0
2013-08-16	BCM	ETF	41.11	41.25	41.11	41.25	1541.0
2013-08-16	BFOR	ETF	6.535	6.5375	6.5025	6.5175	249200.0
2013-08-16	BIB	ETF	26.4775	26.9555	26.315	26.62	129312.0
2013-08-16	BICK	ETF	22.18	22.18	21.97	21.97	2073.0
2013-08-16	BIL	ETF	91.6	91.6	91.58	91.6	491950.0
2013-08-16	BIS	ETF	1280.0	1286.0	1260.04	1275.6	138.5
2013-08-16	BIV	ETF	82.55	82.61	82.08	82.21	253100.0
2013-08-16	BIZD	ETF	19.87	19.89	19.8	19.85	3400.0
2013-08-16	BJK	ETF	42.99	43.1	42.79	42.79	9000.0
2013-08-16	BKF	ETF	35.38	35.46	35.0	35.05	328328.0
2013-08-16	BKLN	ETF	24.72	24.77	24.72	24.76	2482100.0

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

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