PREVIEW / etf_daily / 2016-10-28

all etf daily files

  file:    by_date/etf_daily/2016/2016-10-28.parquet
  size:    53 KB
  rows:    1,324

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-28	SPY	ETF	213.14	213.93	211.71	212.54	140623200.0
2016-10-28	QQQ	ETF	117.47	118.11	116.74	117.1	35369254.0
2016-10-28	IWM	ETF	118.31	119.03	117.75	118.03	35473700.0
2016-10-28	DIA	ETF	181.82	182.32	180.67	181.36	3726600.0
2016-10-28	GLD	ETF	121.2	122.48	120.81	121.58	11639900.0
2016-10-28	TLT	ETF	130.39	130.93	130.33	130.45	7541000.0
2016-10-28	AADR	ETF	41.63	41.63	41.54	41.54	1400.0
2016-10-28	AAXJ	ETF	59.17	59.33	58.69	58.86	804500.0
2016-10-28	ACTX	ETF	12.3901	12.9801	9.6171	12.9801	1561.0
2016-10-28	ACWI	ETF	58.06	58.26	57.77	57.95	4880100.0
2016-10-28	ACWV	ETF	73.42	73.71	73.29	73.43	282000.0
2016-10-28	ACWX	ETF	40.71	40.83	40.57	40.71	2338887.0
2016-10-28	ADRE	ETF	35.47	35.53	35.201	35.3	5533.0
2016-10-28	AFK	ETF	20.39	20.8192	20.39	20.62	2707.0
2016-10-28	AFTY	ETF	13.53	13.53	13.51	13.514	3400.0
2016-10-28	AGG	ETF	111.11	111.26	111.08	111.16	1713800.0
2016-10-28	AGGY	ETF	51.271	51.35	51.24	51.25	4900.0
2016-10-28	AGQ	ETF	40.83	41.66	40.34	41.03	165300.0
2016-10-28	AGZ	ETF	114.91	115.03	114.75	114.98	13760.0
2016-10-28	AGZD	ETF	23.915	24.005	23.915	23.945	3200.0
2016-10-28	AIA	ETF	49.09	49.14	48.74	48.87	32238.0
2016-10-28	AIQ	ETF	9.0	9.2	8.0001	8.35	40450.0
2016-10-28	AIRR	ETF	19.36	19.519	19.36	19.42	2600.0
2016-10-28	AIVI	ETF	37.58	37.77	37.58	37.68	12400.0
2016-10-28	ALTY	ETF	15.06	15.11	14.94	14.94	2800.0
2016-10-28	AMJ	ETF	30.68	31.46	30.43	30.44	2528397.0
2016-10-28	AMLP	ETF	62.5	62.75	62.0	62.2	1338880.0
2016-10-28	AMZA	ETF	108.7	108.7	107.27	107.32	16630.0
2016-10-28	ANGL	ETF	29.08	29.14	28.95	29.0	114500.0
2016-10-28	AOA	ETF	46.6	46.68	46.4	46.5	26500.0
2016-10-28	AOK	ETF	32.83	32.91	32.8101	32.84	34814.0
2016-10-28	AOM	ETF	35.45	35.4792	35.3401	35.43	48177.0
2016-10-28	AOR	ETF	40.4	40.41	40.21	40.32	35167.0
2016-10-28	ARGT	ETF	24.07	24.07	23.67	23.88	246900.0
2016-10-28	ARKG	ETF	16.83	16.96	16.83	16.955	1000.0
2016-10-28	ARKK	ETF	20.09	20.12	19.98	19.98	1000.0
2016-10-28	ARKQ	ETF	20.87	21.024	20.87	20.87	1600.0
2016-10-28	ARKW	ETF	24.89	24.99	24.7	24.7	1200.0
2016-10-28	ASEA	ETF	13.57	13.59	13.57	13.59	600.0
2016-10-28	ASHR	ETF	24.67	24.74	24.61	24.65	488400.0
2016-10-28	ASHS	ETF	34.69	34.69	34.42	34.6	12900.0
2016-10-28	ATMP	ETF	22.78	22.8	22.42	22.45	49200.0
2016-10-28	BAB	ETF	30.67	30.72	30.55	30.67	144140.0
2016-10-28	BAL	ETF	46.71	47.03	46.71	47.02	5353.0
2016-10-28	BBC	ETF	18.51	18.66	18.12	18.3497	15951.0
2016-10-28	BBH	ETF	105.58	105.58	103.09	104.25	303700.0
2016-10-28	BBP	ETF	29.3	29.3	28.62	29.278	5700.0
2016-10-28	BCM	ETF	26.73	26.73	26.665	26.665	883.0
2016-10-28	BFOR	ETF	7.83	7.84	7.79	7.8	82000.0
2016-10-28	BIB	ETF	40.05	40.11	38.18	39.13	1299442.0

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

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