PREVIEW / etf_daily / 2015-10-30

all etf daily files

  file:    by_date/etf_daily/2015/2015-10-30.parquet
  size:    49 KB
  rows:    1,208

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
2015-10-30	SPY	ETF	209.06	209.44	207.74	207.93	131076900.0
2015-10-30	QQQ	ETF	113.89	114.08	113.3	113.33	27199231.0
2015-10-30	IWM	ETF	115.56	116.03	115.08	115.34	28018700.0
2015-10-30	DIA	ETF	177.64	177.83	176.45	176.49	6527500.0
2015-10-30	GLD	ETF	109.5	109.58	109.06	109.3	5543200.0
2015-10-30	TLT	ETF	122.24	122.81	122.02	122.78	11861400.0
2015-10-30	AADR	ETF	38.72	38.72	38.5	38.71	37400.0
2015-10-30	AAXJ	ETF	56.71	56.92	56.49	56.49	377800.0
2015-10-30	ACTX	ETF	9.4401	10.6201	8.2601	10.4431	706.0
2015-10-30	ACWI	ETF	58.4	58.47	58.06	58.07	1562800.0
2015-10-30	ACWV	ETF	70.77	70.89	70.56	70.57	243400.0
2015-10-30	ACWX	ETF	41.7	41.86	41.61	41.61	310524.0
2015-10-30	ADRE	ETF	30.85	31.1299	30.75	30.9801	19340.0
2015-10-30	AFK	ETF	20.3	20.45	20.27	20.28	19416.0
2015-10-30	AFTY	ETF	16.05	16.07	15.99	16.05	13200.0
2015-10-30	AGG	ETF	109.19	109.46	109.15	109.45	10577000.0
2015-10-30	AGQ	ETF	34.68	34.87	34.34	34.49	122700.0
2015-10-30	AGZ	ETF	113.8	114.05	113.5701	113.9	246553.0
2015-10-30	AGZD	ETF	24.02	24.07	23.98	24.01	2200.0
2015-10-30	AIA	ETF	45.68	45.72	45.53	45.59	33024.0
2015-10-30	AIQ	ETF	7.8	8.84	7.6	8.46	87719.0
2015-10-30	AIRR	ETF	16.87	16.87	16.76	16.76	1300.0
2015-10-30	AIVI	ETF	40.3	40.54	40.28	40.33	10000.0
2015-10-30	AMJ	ETF	33.01	33.7	32.4726	33.2	2892399.0
2015-10-30	AMLP	ETF	67.5	69.05	66.05	67.95	1022160.0
2015-10-30	AMZA	ETF	141.8	144.61	138.35	144.0	800.0
2015-10-30	ANGL	ETF	26.14	26.17	26.06	26.06	16300.0
2015-10-30	AOA	ETF	46.11	46.23	45.96	46.05	31600.0
2015-10-30	AOK	ETF	32.23	32.25	32.15	32.22	63131.0
2015-10-30	AOM	ETF	34.67	34.7999	34.6501	34.73	80360.0
2015-10-30	AOR	ETF	39.7	39.8347	39.64	39.64	142761.0
2015-10-30	ARGT	ETF	19.7	20.0	19.68	19.96	14000.0
2015-10-30	ARKG	ETF	19.75	19.83	19.75	19.83	300.0
2015-10-30	ARKK	ETF	19.96	20.02	19.9	19.9	700.0
2015-10-30	ARKQ	ETF	18.93	18.93	18.93	18.93	100.0
2015-10-30	ARKW	ETF	22.85	22.925	22.85	22.92	5300.0
2015-10-30	ASEA	ETF	12.98	12.98	12.95	12.97	2400.0
2015-10-30	ASHR	ETF	35.53	35.65	35.38	35.52	919900.0
2015-10-30	ASHS	ETF	42.8	43.03	42.8	42.95	19400.0
2015-10-30	ATMP	ETF	22.41	22.65	21.94	22.43	196800.0
2015-10-30	AWAY	ETF	31.3	32.31	31.206	31.56	1362225.0
2015-10-30	BAB	ETF	29.08	29.17	29.0311	29.14	84710.0
2015-10-30	BAL	ETF	41.85	42.24	41.77	42.24	1485.0
2015-10-30	BBC	ETF	27.73	27.73	27.1901	27.39	5975.0
2015-10-30	BBH	ETF	125.5	125.5	123.79	123.79	65700.0
2015-10-30	BBP	ETF	30.45	30.77	30.45	30.666	4600.0
2015-10-30	BCHP	ETF	18.02	18.0401	18.02	18.0401	1731.0
2015-10-30	BCM	ETF	26.75	26.87	26.75	26.87	2788.0
2015-10-30	BDCZ	ETF	20.18	20.2	20.06	20.06	900.0
2015-10-30	BFOR	ETF	7.87	7.895	7.8575	7.87	23200.0

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

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