PREVIEW / etf_daily / 2017-05-12

all etf daily files

  file:    by_date/etf_daily/2017/2017-05-12.parquet
  size:    55 KB
  rows:    1,385

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-05-12	SPY	ETF	239.09	239.43	238.67	238.98	53912700.0
2017-05-12	QQQ	ETF	138.37	138.63	138.23	138.6	19738629.0
2017-05-12	IWM	ETF	137.71	137.89	137.16	137.51	24111200.0
2017-05-12	DIA	ETF	208.97	209.28	208.82	209.01	1575100.0
2017-05-12	GLD	ETF	117.07	117.16	116.73	116.83	5434500.0
2017-05-12	TLT	ETF	121.01	121.49	120.98	121.39	7463900.0
2017-05-12	AADR	ETF	48.9	48.94	48.78	48.84	34400.0
2017-05-12	AAXJ	ETF	65.79	65.98	65.72	65.94	399500.0
2017-05-12	ACSI	ETF	28.3099	28.31	28.3099	28.31	478.0
2017-05-12	ACTX	ETF	74.3407	79.6507	71.3906	74.3407	238.0
2017-05-12	ACWF	ETF	26.545	26.545	26.545	26.545	100.0
2017-05-12	ACWI	ETF	64.95	65.04	64.88	65.01	967700.0
2017-05-12	ACWV	ETF	78.5	78.63	78.37	78.48	817200.0
2017-05-12	ACWX	ETF	45.36	45.52	45.36	45.5	261460.0
2017-05-12	ADRE	ETF	38.46	38.58	38.341	38.56	13872.0
2017-05-12	AFK	ETF	21.47	21.5	21.21	21.21	76272.0
2017-05-12	AFTY	ETF	13.977	13.99	13.96	13.96	6600.0
2017-05-12	AGG	ETF	108.81	108.94	108.78	108.92	1329700.0
2017-05-12	AGGY	ETF	50.19	50.25	50.13	50.24	20100.0
2017-05-12	AGNG	ETF	17.718	17.718	17.718	17.718	400.0
2017-05-12	AGQ	ETF	33.46	33.6	33.22	33.37	205500.0
2017-05-12	AGZ	ETF	113.19	113.44	113.12	113.26	24698.0
2017-05-12	AIA	ETF	55.33	55.62	55.33	55.62	27320.0
2017-05-12	AIQ	ETF	13.2	13.2	13.15	13.15	6702.0
2017-05-12	AIRR	ETF	23.93	23.93	23.64	23.66	33200.0
2017-05-12	AIVI	ETF	40.6	40.82	40.6	40.82	6700.0
2017-05-12	ALTY	ETF	15.4	15.41	15.39	15.41	12900.0
2017-05-12	AMJ	ETF	31.25	31.54	31.21	31.37	1086228.0
2017-05-12	AMLP	ETF	61.15	61.55	61.05	61.2	1681720.0
2017-05-12	AMZA	ETF	104.3	104.7	103.9	104.7	72050.0
2017-05-12	ANGL	ETF	29.6	29.62	29.58	29.6	117900.0
2017-05-12	AOA	ETF	50.98	51.03	50.86	51.03	32300.0
2017-05-12	AOK	ETF	33.65	33.7	33.5901	33.7	86066.0
2017-05-12	AOM	ETF	36.79	36.88	36.76	36.88	96127.0
2017-05-12	AOR	ETF	43.0	43.09	42.9896	43.09	92474.0
2017-05-12	ARCM	ETF	100.075	100.075	100.075	100.075	170000.0
2017-05-12	ARGT	ETF	30.25	30.6	30.25	30.41	48000.0
2017-05-12	ARKG	ETF	20.05	20.4	20.05	20.38	5400.0
2017-05-12	ARKK	ETF	26.57	26.789	26.4	26.711	30000.0
2017-05-12	ARKQ	ETF	28.43	28.47	28.138	28.42	66000.0
2017-05-12	ARKW	ETF	31.94	32.09	31.79	32.02	8400.0
2017-05-12	ASEA	ETF	14.85	14.95	14.78	14.93	25100.0
2017-05-12	ASET	ETF	26.9	26.92	26.8952	26.9	1895.0
2017-05-12	ASHR	ETF	24.48	24.54	24.43	24.52	1530100.0
2017-05-12	ASHS	ETF	30.7	30.85	30.69	30.82	9100.0
2017-05-12	ASHX	ETF	18.981	19.01	18.981	19.01	250.0
2017-05-12	ATMP	ETF	22.94	23.21	22.94	23.2	45300.0
2017-05-12	BAB	ETF	29.5	29.54	29.4446	29.54	88438.0
2017-05-12	BAL	ETF	52.52	53.8867	52.4701	52.56	30819.0
2017-05-12	BBC	ETF	21.962	22.253	21.9	22.2	6680.0

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

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