PREVIEW / etf_daily / 2015-08-10

all etf daily files

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

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-10	SPY	ETF	209.28	210.67	209.28	210.57	80270700.0
2015-08-10	QQQ	ETF	111.01	111.81	111.0	111.57	21500780.0
2015-08-10	IWM	ETF	120.33	121.52	120.31	121.26	28798900.0
2015-08-10	DIA	ETF	174.8	176.32	174.8	176.19	4504000.0
2015-08-10	GLD	ETF	105.03	106.27	104.92	105.72	5892600.0
2015-08-10	TLT	ETF	123.41	123.57	122.52	122.8	7461700.0
2015-08-10	AADR	ETF	39.74	39.9	39.74	39.9	11600.0
2015-08-10	AAXJ	ETF	58.59	59.2	58.59	59.15	2101100.0
2015-08-10	ACTX	ETF	1.77	1.77	1.18	1.77	3480.0
2015-08-10	ACWF	ETF	24.79	24.79	24.76	24.76	873.0
2015-08-10	ACWI	ETF	59.71	60.24	59.51	60.22	532400.0
2015-08-10	ACWV	ETF	71.35	71.75	71.35	71.62	290600.0
2015-08-10	ACWX	ETF	43.9	44.45	43.9	44.44	800196.0
2015-08-10	ADRE	ETF	32.46	32.94	32.46	32.94	3072.0
2015-08-10	AFK	ETF	22.13	22.5	22.0911	22.3549	24796.0
2015-08-10	AFTY	ETF	18.95	19.33	18.95	19.3	24800.0
2015-08-10	AGG	ETF	109.15	109.17	108.85	109.06	1280200.0
2015-08-10	AGQ	ETF	32.74	34.8	32.62	34.04	381600.0
2015-08-10	AGZ	ETF	113.095	113.309	113.095	113.2101	5768.0
2015-08-10	AGZD	ETF	24.355	24.355	24.31	24.31	5200.0
2015-08-10	AIA	ETF	46.5	46.95	46.5	46.91	39417.0
2015-08-10	AIQ	ETF	15.0	15.27	14.68	14.86	48992.0
2015-08-10	AIRR	ETF	17.01	17.148	17.01	17.13	28500.0
2015-08-10	AIVI	ETF	43.21	43.68	43.21	43.64	18400.0
2015-08-10	ALTY	ETF	14.76	14.89	14.71	14.89	3100.0
2015-08-10	AMJ	ETF	35.11	36.26	35.07	36.12	2578937.0
2015-08-10	AMLP	ETF	72.25	73.9	72.2	73.75	1653760.0
2015-08-10	AMZA	ETF	160.8	167.4	160.8	167.4	4780.0
2015-08-10	ANGL	ETF	26.67	26.77	26.65	26.72	7400.0
2015-08-10	AOA	ETF	47.17	47.51	47.17	47.51	29300.0
2015-08-10	AOK	ETF	32.54	32.54	32.37	32.403	24580.0
2015-08-10	AOM	ETF	35.12	35.23	35.01	35.22	38218.0
2015-08-10	AOR	ETF	40.41	40.62	40.38	40.62	50577.0
2015-08-10	ARGT	ETF	18.97	19.59	18.92	19.57	20200.0
2015-08-10	ARKG	ETF	22.05	22.05	21.88	21.89	1600.0
2015-08-10	ARKK	ETF	20.86	21.305	20.86	21.28	600.0
2015-08-10	ARKQ	ETF	19.4	19.4	19.4	19.4	100.0
2015-08-10	ARKW	ETF	23.9	23.9	23.9	23.9	200.0
2015-08-10	ASEA	ETF	13.98	14.08	13.98	14.08	2600.0
2015-08-10	ASHR	ETF	42.37	42.85	42.37	42.79	2956000.0
2015-08-10	ASHS	ETF	53.35	53.81	53.24	53.57	53700.0
2015-08-10	ATMP	ETF	24.28	24.69	24.25	24.61	147200.0
2015-08-10	AWAY	ETF	30.99	31.7	30.625	31.21	1631694.0
2015-08-10	BAB	ETF	29.46	29.48	29.12	29.12	53835.0
2015-08-10	BAL	ETF	40.97	41.96	40.97	41.15	27215.0
2015-08-10	BBC	ETF	33.7	34.23	33.55	33.71	16866.0
2015-08-10	BBH	ETF	136.45	138.39	136.45	136.54	136000.0
2015-08-10	BBP	ETF	34.57	35.22	34.41	34.53	56600.0
2015-08-10	BCM	ETF	27.985	28.03	27.952	27.952	7932.0
2015-08-10	BFOR	ETF	8.1475	8.255	8.1475	8.25	15600.0

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

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