PREVIEW / etf_daily / 2015-09-18

all etf daily files

  file:    by_date/etf_daily/2015/2015-09-18.parquet
  size:    48 KB
  rows:    1,205

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-09-18	SPY	ETF	195.71	198.68	194.96	195.45	223657500.0
2015-09-18	QQQ	ETF	105.23	106.6	105.17	105.35	48383995.0
2015-09-18	IWM	ETF	115.76	116.84	115.4	115.72	42736100.0
2015-09-18	DIA	ETF	164.0	165.24	163.2	163.54	10400500.0
2015-09-18	GLD	ETF	109.1	109.38	108.82	109.21	6794300.0
2015-09-18	TLT	ETF	121.21	122.2	121.13	122.1	14963300.0
2015-09-18	AADR	ETF	37.25	37.25	37.17	37.17	900.0
2015-09-18	AAXJ	ETF	54.48	54.86	53.99	54.1	1071600.0
2015-09-18	ACTX	ETF	4.72	4.72	3.54	4.425	2149.0
2015-09-18	ACWF	ETF	23.16	23.17	23.16	23.16	1100.0
2015-09-18	ACWI	ETF	55.52	55.89	55.19	55.25	3958800.0
2015-09-18	ACWV	ETF	67.49	68.01	67.36	67.36	147100.0
2015-09-18	ACWX	ETF	40.43	40.5902	40.12	40.18	369902.0
2015-09-18	ADRE	ETF	29.3	29.3	28.71	28.73	13659.0
2015-09-18	AFK	ETF	20.53	20.7899	20.4	20.4	6862.0
2015-09-18	AFTY	ETF	15.07	15.13	14.83	14.89	79300.0
2015-09-18	AGG	ETF	109.26	109.39	109.15	109.28	4510600.0
2015-09-18	AGGY	ETF	49.86	49.87	49.78	49.83	1800.0
2015-09-18	AGQ	ETF	34.05	34.05	33.06	33.33	188100.0
2015-09-18	AGZ	ETF	113.7532	113.999	113.52	113.78	160442.0
2015-09-18	AGZD	ETF	24.0	24.0	24.0	24.0	200.0
2015-09-18	AIA	ETF	43.24	43.49	42.94	42.97	60115.0
2015-09-18	AIQ	ETF	12.67	12.78	11.9	11.915	105312.0
2015-09-18	AIRR	ETF	16.389	16.41	16.211	16.211	10300.0
2015-09-18	AIVI	ETF	39.78	39.95	39.6	39.6	9000.0
2015-09-18	ALTY	ETF	14.4	14.44	14.4	14.4	1100.0
2015-09-18	AMJ	ETF	33.29	33.58	33.17	33.48	2728105.0
2015-09-18	AMLP	ETF	69.05	69.65	68.45	69.25	1017140.0
2015-09-18	AMZA	ETF	156.9	156.9	152.2	152.2	1050.0
2015-09-18	ANGL	ETF	26.3	26.54	26.3	26.4	42700.0
2015-09-18	AOA	ETF	44.64	44.87	44.4	44.42	38300.0
2015-09-18	AOK	ETF	31.77	31.8599	31.72	31.83	24153.0
2015-09-18	AOM	ETF	34.1569	34.33	34.0801	34.24	82508.0
2015-09-18	AOR	ETF	38.87	38.95	38.68	38.73	70092.0
2015-09-18	ARGT	ETF	17.48	17.5	17.4	17.44	2500.0
2015-09-18	ARKG	ETF	21.9	21.9	21.9	21.9	100.0
2015-09-18	ARKK	ETF	20.5	20.56	20.43	20.43	10700.0
2015-09-18	ARKQ	ETF	18.44	18.47	18.43	18.47	1700.0
2015-09-18	ARKW	ETF	22.35	22.49	22.35	22.385	8000.0
2015-09-18	ASEA	ETF	12.84	12.84	12.67	12.67	276400.0
2015-09-18	ASHR	ETF	31.93	32.14	31.6	31.6	3531800.0
2015-09-18	ASHS	ETF	35.09	35.09	34.58	34.6	83200.0
2015-09-18	ATMP	ETF	22.72	22.81	22.58	22.72	12500.0
2015-09-18	AWAY	ETF	28.82	29.23	28.31	28.51	1536102.0
2015-09-18	BAB	ETF	28.76	28.93	28.65	28.88	79936.0
2015-09-18	BAL	ETF	41.2701	41.2701	40.2899	40.29	7227.0
2015-09-18	BBC	ETF	34.87	35.358	34.8341	35.304	9557.0
2015-09-18	BBH	ETF	131.98	133.02	130.98	131.15	116000.0
2015-09-18	BBP	ETF	33.6	33.62	33.08	33.08	14400.0
2015-09-18	BCHP	ETF	17.86	18.01	17.86	17.907	4593.0

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

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