PREVIEW / etf_daily / 2017-07-19

all etf daily files

  file:    by_date/etf_daily/2017/2017-07-19.parquet
  size:    56 KB
  rows:    1,428

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-07-19	SPY	ETF	246.02	247.0	246.01	246.99	51034300.0
2017-07-19	QQQ	ETF	143.53	144.19	143.5	143.98	33752309.0
2017-07-19	IWM	ETF	141.88	143.14	141.88	143.1	16985500.0
2017-07-19	DIA	ETF	215.89	216.34	215.66	216.32	1785800.0
2017-07-19	GLD	ETF	118.18	118.27	117.84	118.08	3205100.0
2017-07-19	TLT	ETF	124.78	125.01	124.59	124.8	5140900.0
2017-07-19	AADR	ETF	49.09	49.28	48.92	49.27	17000.0
2017-07-19	AAXJ	ETF	70.67	70.71	70.53	70.62	496600.0
2017-07-19	ACSI	ETF	28.87	28.91	28.87	28.91	15740.0
2017-07-19	ACTX	ETF	73.7507	76.7007	71.9806	76.7007	385.0
2017-07-19	ACWF	ETF	28.02	28.08	28.02	28.08	800.0
2017-07-19	ACWI	ETF	66.88	67.13	66.88	67.13	1640300.0
2017-07-19	ACWV	ETF	79.67	79.84	79.64	79.82	144000.0
2017-07-19	ACWX	ETF	46.81	46.94	46.81	46.92	106926.0
2017-07-19	ADRE	ETF	40.75	40.8	40.6508	40.68	4589.0
2017-07-19	AFK	ETF	22.65	22.8	22.5601	22.8	5405.0
2017-07-19	AFTY	ETF	16.181	16.21	16.181	16.21	3600.0
2017-07-19	AGG	ETF	109.72	109.75	109.63	109.7	1577700.0
2017-07-19	AGGY	ETF	50.79	50.79	50.739	50.77	8000.0
2017-07-19	AGNG	ETF	19.26	19.26	19.2	19.216	1700.0
2017-07-19	AGQ	ETF	32.48	32.61	32.01	32.36	83000.0
2017-07-19	AGZ	ETF	113.78	113.9	113.7159	113.82	45352.0
2017-07-19	AGZD	ETF	24.02	24.025	24.02	24.02	7000.0
2017-07-19	AIA	ETF	60.04	60.0407	59.91	60.01	35069.0
2017-07-19	AIQ	ETF	13.25	13.3	13.2	13.25	28480.0
2017-07-19	AIRR	ETF	23.81	24.14	23.81	24.11	27100.0
2017-07-19	AIVI	ETF	41.66	41.77	41.65	41.76	7900.0
2017-07-19	ALTY	ETF	15.61	15.62	15.61	15.62	3200.0
2017-07-19	AMJ	ETF	30.34	30.4411	30.18	30.31	1050192.0
2017-07-19	AMLP	ETF	60.4	60.65	60.25	60.5	1139900.0
2017-07-19	AMZA	ETF	97.9	98.2	97.5	98.0	89280.0
2017-07-19	ANGL	ETF	29.76	29.85	29.72	29.81	252100.0
2017-07-19	AOA	ETF	52.28	52.44	52.26	52.44	46600.0
2017-07-19	AOK	ETF	34.13	34.19	34.11	34.13	47186.0
2017-07-19	AOM	ETF	37.4	37.47	37.37	37.47	61974.0
2017-07-19	AOR	ETF	43.95	44.05	43.9368	44.05	55580.0
2017-07-19	ARCM	ETF	100.09	100.09	100.09	100.09	20.0
2017-07-19	ARGT	ETF	29.58	29.79	29.48	29.76	369800.0
2017-07-19	ARKG	ETF	22.08	22.368	22.08	22.197	7000.0
2017-07-19	ARKK	ETF	29.49	29.67	29.409	29.47	189800.0
2017-07-19	ARKQ	ETF	29.33	29.41	29.22	29.37	22000.0
2017-07-19	ARKW	ETF	36.95	37.12	36.83	36.88	173600.0
2017-07-19	ASEA	ETF	15.3	15.35	15.3	15.34	1000.0
2017-07-19	ASET	ETF	27.7	27.7	27.685	27.685	584.0
2017-07-19	ASHR	ETF	27.9	28.02	27.84	28.0	1867200.0
2017-07-19	ASHS	ETF	32.73	32.74	32.7	32.71	4900.0
2017-07-19	ASHX	ETF	21.03	21.039	21.021	21.03	1130.0
2017-07-19	ATMP	ETF	22.78	22.84	22.73	22.84	6400.0
2017-07-19	BAB	ETF	30.05	30.0855	30.0008	30.03	59344.0
2017-07-19	BAL	ETF	45.0	45.0	44.74	44.85	3125.0

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

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