PREVIEW / etf_daily / 2016-10-06

all etf daily files

  file:    by_date/etf_daily/2016/2016-10-06.parquet
  size:    52 KB
  rows:    1,303

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
2016-10-06	SPY	ETF	215.37	216.04	214.74	215.78	62927400.0
2016-10-06	QQQ	ETF	118.63	118.981	118.15	118.73	11987056.0
2016-10-06	IWM	ETF	123.75	124.02	122.82	123.82	18937100.0
2016-10-06	DIA	ETF	182.34	182.74	181.47	182.52	2368100.0
2016-10-06	GLD	ETF	119.69	119.98	119.24	119.66	17917700.0
2016-10-06	TLT	ETF	133.97	134.69	133.68	133.83	7839900.0
2016-10-06	AADR	ETF	40.23	40.33	40.23	40.33	1700.0
2016-10-06	AAXJ	ETF	60.77	61.1	60.62	61.1	578400.0
2016-10-06	ACTX	ETF	7.0801	7.0801	5.9001	5.9001	1881.0
2016-10-06	ACWI	ETF	58.95	59.05	58.77	59.0	1130600.0
2016-10-06	ACWV	ETF	74.64	74.84	74.4	74.71	353000.0
2016-10-06	ACWX	ETF	41.36	41.46	41.28	41.43	134260.0
2016-10-06	ADRE	ETF	35.37	35.46	35.26	35.46	4515.0
2016-10-06	AFK	ETF	20.4601	20.6899	20.4601	20.6899	1204.0
2016-10-06	AFTY	ETF	13.503	13.503	13.48	13.49	700.0
2016-10-06	AGG	ETF	111.57	111.67	111.45	111.56	2059400.0
2016-10-06	AGGY	ETF	51.62	51.67	51.58	51.583	23800.0
2016-10-06	AGNG	ETF	16.14	16.28	16.14	16.28	600.0
2016-10-06	AGQ	ETF	39.53	39.63	38.12	39.06	412300.0
2016-10-06	AGZ	ETF	115.06	115.2531	114.84	114.84	15941.0
2016-10-06	AGZD	ETF	24.02	24.04	24.005	24.005	2600.0
2016-10-06	AIA	ETF	50.44	50.78	50.37	50.78	39919.0
2016-10-06	AIQ	ETF	7.29	7.4	7.21	7.23	9172.0
2016-10-06	AIRR	ETF	20.42	20.6	20.343	20.54	9000.0
2016-10-06	AIVI	ETF	38.68	38.68	38.59	38.61	8400.0
2016-10-06	ALTY	ETF	15.257	15.257	15.195	15.25	2100.0
2016-10-06	AMJ	ETF	31.04	31.15	30.605	30.76	1228410.0
2016-10-06	AMLP	ETF	63.15	63.25	62.15	62.4	1061660.0
2016-10-06	AMZA	ETF	109.3	109.3	107.6	108.0	9750.0
2016-10-06	ANGL	ETF	28.92	28.95	28.85	28.88	81900.0
2016-10-06	AOA	ETF	47.15	47.27	47.06	47.24	17400.0
2016-10-06	AOK	ETF	33.13	33.16	33.05	33.13	32252.0
2016-10-06	AOM	ETF	35.82	35.82	35.67	35.76	61593.0
2016-10-06	AOR	ETF	40.77	40.85	40.7066	40.8	107015.0
2016-10-06	ARGT	ETF	24.3	24.32	24.16	24.29	46400.0
2016-10-06	ARKG	ETF	19.76	19.76	19.251	19.251	1300.0
2016-10-06	ARKK	ETF	22.24	22.24	21.82	21.82	600.0
2016-10-06	ARKQ	ETF	22.33	22.33	22.23	22.275	1200.0
2016-10-06	ARKW	ETF	25.74	25.74	25.387	25.5	900.0
2016-10-06	ASEA	ETF	14.09	14.09	13.93	14.07	9500.0
2016-10-06	ASET	ETF	25.81	25.81	25.81	25.81	292.0
2016-10-06	ASHR	ETF	24.52	24.65	24.52	24.57	740000.0
2016-10-06	ASHS	ETF	34.69	34.81	34.64	34.7	7800.0
2016-10-06	ATMP	ETF	23.05	23.05	22.74	22.83	28000.0
2016-10-06	BAB	ETF	31.02	31.09	31.0	31.04	171070.0
2016-10-06	BAL	ETF	44.49	44.7058	44.22	44.65	8995.0
2016-10-06	BBC	ETF	22.47	22.47	22.01	22.01	8900.0
2016-10-06	BBH	ETF	113.55	113.89	112.72	112.92	59800.0
2016-10-06	BBP	ETF	33.27	33.27	32.85	32.93	9100.0
2016-10-06	BFOR	ETF	8.0375	8.08	8.03	8.0725	28000.0

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

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