PREVIEW / etf_daily / 2013-08-01

all etf daily files

  file:    by_date/etf_daily/2013/2013-08-01.parquet
  size:    42 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-08-01	SPY	ETF	169.99	170.81	169.9	170.66	110438400.0
2013-08-01	QQQ	ETF	76.3	76.65	76.21	76.54	16879933.0
2013-08-01	IWM	ETF	104.68	105.35	103.75	105.07	34487100.0
2013-08-01	DIA	ETF	155.89	156.16	155.67	155.89	4872400.0
2013-08-01	GLD	ETF	127.84	127.89	126.33	126.61	10564300.0
2013-08-01	TLT	ETF	106.49	106.49	105.0	105.36	13568600.0
2013-08-01	AADR	ETF	34.11	34.23	34.05	34.23	1000.0
2013-08-01	AAXJ	ETF	56.49	56.89	56.42	56.78	1754600.0
2013-08-01	ACTV	ETF	8.57	8.68	8.29	8.31	699786.0
2013-08-01	ACWI	ETF	52.73	53.08	52.73	53.02	1998700.0
2013-08-01	ACWV	ETF	62.05	62.37	62.05	62.24	91200.0
2013-08-01	ACWX	ETF	42.99	43.2	42.98	43.14	541226.0
2013-08-01	ADRE	ETF	35.83	35.91	35.684	35.9	17436.0
2013-08-01	AFK	ETF	29.48	29.48	29.2402	29.4	23566.0
2013-08-01	AGEM	ETF	21.43	21.5647	21.43	21.5647	214.0
2013-08-01	AGG	ETF	106.84	106.85	106.4	106.49	1162600.0
2013-08-01	AGQ	ETF	68.8	68.88	67.6	67.88	255000.0
2013-08-01	AGZ	ETF	110.76	111.102	110.76	110.9182	17279.0
2013-08-01	AIA	ETF	44.45	44.7156	44.3858	44.54	66532.0
2013-08-01	AIQ	ETF	19.69	19.98	19.034	19.51	129294.0
2013-08-01	AIVI	ETF	42.71	42.86	42.64	42.79	45000.0
2013-08-01	ALTL	ETF	30.1799	30.1799	30.1799	30.1799	150.0
2013-08-01	AMJ	ETF	46.34	47.06	46.34	46.92	523640.0
2013-08-01	AMLP	ETF	89.55	90.0	89.3	89.7	853320.0
2013-08-01	ANGL	ETF	27.2	27.2	26.97	27.1	1400.0
2013-08-01	AOA	ETF	41.58	41.77	41.58	41.73	31900.0
2013-08-01	AOK	ETF	31.28	31.28	31.2001	31.24	22440.0
2013-08-01	AOM	ETF	33.15	33.16	33.03	33.14	41138.0
2013-08-01	AOR	ETF	36.61	36.69	36.6001	36.66	24589.0
2013-08-01	ARB	ETF	45.95	46.06	45.89	46.01	185122.0
2013-08-01	ARGT	ETF	17.68	17.81	17.68	17.8	3600.0
2013-08-01	ASEA	ETF	17.1	17.24	17.08	17.22	36400.0
2013-08-01	ATMP	ETF	26.77	26.79	26.66	26.74	28700.0
2013-08-01	AVIV	ETF	25.0	25.0765	24.06	24.26	283571.0
2013-08-01	AWAY	ETF	30.23	30.63	29.82	30.52	1091043.0
2013-08-01	BAB	ETF	27.66	27.66	27.44	27.46	338850.0
2013-08-01	BAL	ETF	54.44	54.84	54.0799	54.84	33557.0
2013-08-01	BALT	ETF	4.03	4.1	3.79	3.79	160614.0
2013-08-01	BBH	ETF	79.99	80.42	79.52	80.35	97700.0
2013-08-01	BCM	ETF	39.7951	39.7951	39.7951	39.7951	184.0
2013-08-01	BFOR	ETF	6.665	6.7325	6.665	6.7275	194400.0
2013-08-01	BIB	ETF	30.17	30.2473	29.7338	30.1275	136624.0
2013-08-01	BICK	ETF	21.8601	21.99	21.8601	21.99	500.0
2013-08-01	BIL	ETF	91.58	91.6	91.58	91.58	207450.0
2013-08-01	BIS	ETF	1150.8	1150.8	1134.44	1134.44	15.0
2013-08-01	BIV	ETF	83.23	83.23	82.78	82.86	278200.0
2013-08-01	BIZD	ETF	20.49	20.49	20.39	20.44	8200.0
2013-08-01	BJK	ETF	42.51	42.94	42.51	42.86	18100.0
2013-08-01	BKF	ETF	35.03	35.49	35.03	35.28	207112.0
2013-08-01	BKLN	ETF	24.95	24.96	24.93	24.94	3014200.0

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

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