PREVIEW / etf_daily / 2017-07-25

all etf daily files

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

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-25	SPY	ETF	247.68	247.8	247.16	247.42	54915600.0
2017-07-25	QQQ	ETF	144.29	144.74	144.01	144.4	28120884.0
2017-07-25	IWM	ETF	143.62	144.25	143.21	144.05	21066400.0
2017-07-25	DIA	ETF	216.5	216.52	215.49	215.86	1924200.0
2017-07-25	GLD	ETF	118.99	119.32	118.79	118.92	6203000.0
2017-07-25	TLT	ETF	124.14	124.19	123.47	123.57	9743300.0
2017-07-25	AADR	ETF	49.72	49.72	49.07	49.51	32800.0
2017-07-25	AAXJ	ETF	71.0	71.0	70.77	70.81	390600.0
2017-07-25	ACSI	ETF	29.08	29.195	29.08	29.12	8313.0
2017-07-25	ACTX	ETF	74.3407	77.2907	74.3407	76.7007	98.0
2017-07-25	ACWF	ETF	28.13	28.1499	28.12	28.14	3918.0
2017-07-25	ACWI	ETF	67.22	67.34	67.18	67.2	1884300.0
2017-07-25	ACWV	ETF	80.2	80.2	80.02	80.1	77700.0
2017-07-25	ACWX	ETF	47.06	47.11	46.935	46.95	681121.0
2017-07-25	ADRE	ETF	40.91	41.0	40.8501	40.9101	11766.0
2017-07-25	AFK	ETF	22.82	23.063	22.82	22.9971	12919.0
2017-07-25	AFTY	ETF	16.27	16.27	16.2	16.2	900.0
2017-07-25	AGG	ETF	109.6	109.63	109.39	109.43	2601700.0
2017-07-25	AGGY	ETF	50.63	50.63	50.51	50.53	42600.0
2017-07-25	AGNG	ETF	19.196	19.196	19.14	19.14	700.0
2017-07-25	AGQ	ETF	33.2	33.56	32.91	33.12	78100.0
2017-07-25	AGZ	ETF	113.79	113.79	113.64	113.64	5482.0
2017-07-25	AGZD	ETF	23.96	24.0	23.96	23.98	12200.0
2017-07-25	AIA	ETF	60.36	60.36	60.13	60.13	29862.0
2017-07-25	AIQ	ETF	13.25	13.25	13.2	13.2	30184.0
2017-07-25	AIRR	ETF	23.99	24.267	23.98	24.24	15000.0
2017-07-25	AIVI	ETF	41.67	41.67	41.49	41.49	9800.0
2017-07-25	ALTY	ETF	15.74	15.765	15.709	15.73	2400.0
2017-07-25	AMJ	ETF	29.98	30.16	29.975	30.07	925338.0
2017-07-25	AMLP	ETF	60.0	60.25	59.85	59.95	1632540.0
2017-07-25	AMZA	ETF	97.1	97.6	97.0	97.4	78230.0
2017-07-25	ANGL	ETF	29.84	29.9	29.8	29.85	872500.0
2017-07-25	AOA	ETF	52.54	52.6	52.41	52.41	39200.0
2017-07-25	AOK	ETF	34.2	34.2	34.1	34.1399	56502.0
2017-07-25	AOM	ETF	37.54	37.54	37.4001	37.45	56410.0
2017-07-25	AOR	ETF	44.13	44.13	44.01	44.07	79859.0
2017-07-25	ARCM	ETF	100.05	100.05	100.05	100.05	20.0
2017-07-25	ARGT	ETF	29.69	29.76	29.6	29.75	108900.0
2017-07-25	ARKG	ETF	23.12	23.12	22.59	22.84	12600.0
2017-07-25	ARKK	ETF	30.5	30.51	30.12	30.3	98000.0
2017-07-25	ARKQ	ETF	29.99	29.99	29.635	29.896	21600.0
2017-07-25	ARKW	ETF	37.76	37.76	37.29	37.5	39900.0
2017-07-25	ASEA	ETF	15.41	15.56	15.4	15.4	39400.0
2017-07-25	ASET	ETF	27.6599	27.69	27.64	27.67	4982.0
2017-07-25	ASHR	ETF	28.02	28.05	27.94	27.96	676300.0
2017-07-25	ASHS	ETF	33.38	33.38	33.29	33.3	8500.0
2017-07-25	ATMP	ETF	22.86	22.86	22.7	22.79	30000.0
2017-07-25	BAB	ETF	30.08	30.08	29.94	29.98	136122.0
2017-07-25	BAL	ETF	45.3	45.4341	45.265	45.4279	4360.0
2017-07-25	BBC	ETF	25.95	25.95	25.0292	25.0649	14145.0

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

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