PREVIEW / etf_daily / 2017-01-03

all etf daily files

  file:    by_date/etf_daily/2017/2017-01-03.parquet
  size:    54 KB
  rows:    1,376

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
2017-01-03	SPY	ETF	225.04	225.83	223.88	225.24	91366500.0
2017-01-03	QQQ	ETF	119.31	119.99	118.89	119.54	22307608.0
2017-01-03	IWM	ETF	136.49	136.83	134.5	135.52	29792400.0
2017-01-03	DIA	ETF	198.91	199.1	197.48	198.42	6669800.0
2017-01-03	GLD	ETF	109.62	111.0	109.37	110.47	7527400.0
2017-01-03	TLT	ETF	118.41	119.99	118.18	119.64	13217300.0
2017-01-03	AADR	ETF	40.98	41.68	40.98	41.25	4500.0
2017-01-03	AAXJ	ETF	55.46	55.75	55.32	55.47	1530500.0
2017-01-03	ACSI	ETF	27.1598	27.1598	26.973	27.11	6780.0
2017-01-03	ACTX	ETF	20.0602	29.5003	19.7652	26.5502	2476.0
2017-01-03	ACWF	ETF	24.3329	24.3329	24.33	24.33	636.0
2017-01-03	ACWI	ETF	59.61	59.72	59.35	59.63	2576700.0
2017-01-03	ACWV	ETF	72.8	72.81	72.57	72.8	260000.0
2017-01-03	ACWX	ETF	40.5	40.55	40.4	40.49	1904016.0
2017-01-03	ADRE	ETF	32.74	32.8999	32.65	32.7903	6567.0
2017-01-03	AFK	ETF	19.72	20.1593	19.72	19.78	49087.0
2017-01-03	AFTY	ETF	13.113	13.113	13.113	13.113	1100.0
2017-01-03	AGG	ETF	107.73	108.22	107.73	108.17	5079200.0
2017-01-03	AGGY	ETF	49.45	49.63	49.393	49.63	41100.0
2017-01-03	AGQ	ETF	32.64	34.42	32.53	33.66	293200.0
2017-01-03	AGZ	ETF	112.32	113.0	112.3	112.48	77649.0
2017-01-03	AGZD	ETF	24.205	24.205	24.025	24.095	9600.0
2017-01-03	AIA	ETF	46.68	46.97	46.67	46.79	98545.0
2017-01-03	AIQ	ETF	9.6	9.6	9.55	9.6	58769.0
2017-01-03	AIRR	ETF	23.95	24.0	23.584	23.799	45300.0
2017-01-03	AIVI	ETF	37.46	37.6	37.46	37.56	21900.0
2017-01-03	ALTY	ETF	15.21	15.21	14.94	14.94	3300.0
2017-01-03	AMJ	ETF	31.89	32.13	31.63	31.74	2842469.0
2017-01-03	AMLP	ETF	63.45	63.95	63.25	63.7	2591020.0
2017-01-03	AMZA	ETF	114.6	114.9	113.4	114.0	150400.0
2017-01-03	ANGL	ETF	28.84	28.9	28.8	28.89	320100.0
2017-01-03	AOA	ETF	47.36	47.51	47.26	47.44	527300.0
2017-01-03	AOK	ETF	32.59	32.59	32.4807	32.56	150812.0
2017-01-03	AOM	ETF	35.28	35.2979	35.21	35.28	684123.0
2017-01-03	AOR	ETF	40.65	40.69	40.53	40.69	1096910.0
2017-01-03	ARGT	ETF	23.22	23.77	23.22	23.68	33300.0
2017-01-03	ARKG	ETF	17.2	17.33	17.18	17.19	1800.0
2017-01-03	ARKK	ETF	20.458	20.458	20.435	20.437	600.0
2017-01-03	ARKQ	ETF	22.16	22.34	21.98	22.24	4000.0
2017-01-03	ARKW	ETF	25.33	25.6	25.33	25.424	3800.0
2017-01-03	ASEA	ETF	12.9	12.9	12.85	12.86	6400.0
2017-01-03	ASHR	ETF	23.8	23.89	23.76	23.89	846500.0
2017-01-03	ASHS	ETF	32.52	32.84	32.36	32.7	7500.0
2017-01-03	ASHX	ETF	18.69	19.0227	18.69	19.0227	475.0
2017-01-03	ATMP	ETF	23.89	23.91	23.56	23.75	76600.0
2017-01-03	BAB	ETF	29.0	29.15	28.99	29.12	106636.0
2017-01-03	BAL	ETF	46.911	47.249	46.9	47.19	14403.0
2017-01-03	BBC	ETF	18.4601	18.8	18.345	18.545	1885.0
2017-01-03	BBH	ETF	108.11	109.88	108.11	109.88	62700.0
2017-01-03	BBP	ETF	33.03	33.165	32.67	32.67	1700.0

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

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