PREVIEW / etf_daily / 2015-08-12

all etf daily files

  file:    by_date/etf_daily/2015/2015-08-12.parquet
  size:    48 KB
  rows:    1,196

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
2015-08-12	SPY	ETF	207.11	209.14	205.36	208.92	172123700.0
2015-08-12	QQQ	ETF	109.38	110.735	108.22	110.52	41888960.0
2015-08-12	IWM	ETF	119.57	120.34	117.97	119.99	46500100.0
2015-08-12	DIA	ETF	172.83	174.4	171.4	174.21	8825600.0
2015-08-12	GLD	ETF	106.99	107.91	106.93	107.75	10022500.0
2015-08-12	TLT	ETF	124.93	125.71	124.0	124.07	8455200.0
2015-08-12	AADR	ETF	38.75	38.75	38.75	38.75	100.0
2015-08-12	AAXJ	ETF	56.49	56.75	56.3	56.7	4130100.0
2015-08-12	ACTX	ETF	1.77	2.36	1.77	1.77	454.0
2015-08-12	ACWI	ETF	58.81	59.27	58.41	59.21	813300.0
2015-08-12	ACWV	ETF	70.58	71.09	70.31	71.02	159200.0
2015-08-12	ACWX	ETF	43.1	43.39	42.91	43.37	554082.0
2015-08-12	ADRE	ETF	31.7	31.77	31.44	31.77	6118.0
2015-08-12	AFK	ETF	21.92	22.23	21.89	21.99	20598.0
2015-08-12	AFTY	ETF	18.0	18.04	17.79	18.02	127300.0
2015-08-12	AGG	ETF	109.55	109.71	109.35	109.35	1563900.0
2015-08-12	AGQ	ETF	34.89	35.68	34.85	35.32	211400.0
2015-08-12	AGZ	ETF	113.43	113.77	113.43	113.5499	8610.0
2015-08-12	AGZD	ETF	24.31	24.31	24.18	24.245	7600.0
2015-08-12	AIA	ETF	44.907	45.11	44.76	45.08	37223.0
2015-08-12	AIQ	ETF	14.99	14.99	14.5	14.69	15465.0
2015-08-12	AIRR	ETF	16.843	17.026	16.7	17.026	6700.0
2015-08-12	AIVI	ETF	42.75	43.07	42.55	43.07	133300.0
2015-08-12	AMJ	ETF	36.06	37.02	35.56	36.93	1924299.0
2015-08-12	AMLP	ETF	72.4	73.55	71.75	73.4	1972460.0
2015-08-12	AMZA	ETF	167.0	172.1	165.6	171.6	2380.0
2015-08-12	ANGL	ETF	26.54	26.64	26.53	26.64	12800.0
2015-08-12	AOA	ETF	46.67	46.9	46.42	46.85	38800.0
2015-08-12	AOK	ETF	32.36	32.39	32.2855	32.32	17542.0
2015-08-12	AOM	ETF	35.06	35.1	34.93	35.06	92774.0
2015-08-12	AOR	ETF	40.27	40.27	39.9575	40.24	57184.0
2015-08-12	ARGT	ETF	19.13	19.13	18.98	19.0	2500.0
2015-08-12	ARKG	ETF	21.41	21.668	21.3	21.668	2200.0
2015-08-12	ARKK	ETF	20.55	20.8	20.55	20.8	1600.0
2015-08-12	ARKQ	ETF	19.07	19.07	19.07	19.07	100.0
2015-08-12	ARKW	ETF	23.145	23.145	23.0	23.0	4200.0
2015-08-12	ASEA	ETF	13.33	13.33	13.21	13.29	31100.0
2015-08-12	ASHR	ETF	39.72	40.02	39.41	39.97	3175400.0
2015-08-12	ASHS	ETF	49.23	50.2	49.11	50.08	76100.0
2015-08-12	ATMP	ETF	24.48	25.39	24.48	25.38	90500.0
2015-08-12	AWAY	ETF	30.5	30.88	30.21	30.58	1375269.0
2015-08-12	BAB	ETF	29.34	29.5	29.19	29.2499	59518.0
2015-08-12	BAL	ETF	41.01	43.27	41.01	43.138	15476.0
2015-08-12	BBC	ETF	32.5	33.35	31.7001	33.28	14792.0
2015-08-12	BBH	ETF	134.32	137.0	132.3	136.64	140000.0
2015-08-12	BBP	ETF	33.42	34.421	33.06	34.33	26300.0
2015-08-12	BCHP	ETF	18.7101	18.88	18.7101	18.88	1169.0
2015-08-12	BCM	ETF	27.73	27.73	27.34	27.34	17925.0
2015-08-12	BFOR	ETF	8.1125	8.1625	8.0175	8.1625	76400.0
2015-08-12	BIB	ETF	86.59	90.45	83.75	90.05	1170676.0

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

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