PREVIEW / etf_daily / 2015-12-18

all etf daily files

  file:    by_date/etf_daily/2015/2015-12-18.parquet
  size:    50 KB
  rows:    1,251

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-12-18	SPY	ETF	202.77	202.93	199.83	200.02	251393500.0
2015-12-18	QQQ	ETF	111.58	111.88	109.83	109.83	53746061.0
2015-12-18	IWM	ETF	112.66	112.89	111.44	111.48	49876600.0
2015-12-18	DIA	ETF	173.84	173.91	170.89	171.0	10946100.0
2015-12-18	GLD	ETF	101.35	102.53	101.3	102.04	8345900.0
2015-12-18	TLT	ETF	123.08	123.52	122.82	123.23	10171700.0
2015-12-18	AADR	ETF	38.18	38.18	38.18	38.18	300.0
2015-12-18	AAXJ	ETF	54.24	54.36	54.01	54.07	732500.0
2015-12-18	ACTX	ETF	8.2601	8.8501	7.5521	8.8501	3174.0
2015-12-18	ACWF	ETF	22.86	23.08	22.86	23.065	4000.0
2015-12-18	ACWI	ETF	56.17	56.28	55.56	55.56	2607600.0
2015-12-18	ACWV	ETF	69.55	69.57	69.03	69.03	311800.0
2015-12-18	ACWX	ETF	39.6	39.65	39.37	39.37	4101111.0
2015-12-18	ADRE	ETF	29.56	29.56	29.21	29.21	16036.0
2015-12-18	AFK	ETF	17.66	17.81	17.567	17.78	42835.0
2015-12-18	AFTY	ETF	14.41	14.53	14.19	14.48	1023800.0
2015-12-18	AGG	ETF	108.35	108.46	108.25	108.38	4006400.0
2015-12-18	AGQ	ETF	27.34	28.64	27.34	28.25	204400.0
2015-12-18	AGZ	ETF	113.359	113.38	113.0601	113.33	12875.0
2015-12-18	AGZD	ETF	23.99	23.99	23.975	23.99	1600.0
2015-12-18	AIA	ETF	43.35	43.45	43.205	43.27	41495.0
2015-12-18	AIQ	ETF	9.03	9.38	8.71	9.3	47042.0
2015-12-18	AIRR	ETF	16.48	16.595	16.4	16.4	4400.0
2015-12-18	AIVI	ETF	37.76	37.86	37.56	37.56	25300.0
2015-12-18	ALTY	ETF	13.75	13.75	13.75	13.75	1500.0
2015-12-18	AMJ	ETF	25.23	25.79	24.17	25.49	7005065.0
2015-12-18	AMLP	ETF	51.45	52.85	51.25	52.2	6778720.0
2015-12-18	AMUB	ETF	16.2	16.2	16.17	16.17	300.0
2015-12-18	AMZA	ETF	89.1	93.96	89.1	92.7	2350.0
2015-12-18	ANGL	ETF	24.42	24.44	24.21	24.23	32200.0
2015-12-18	AOA	ETF	44.94	44.98	44.63	44.64	217100.0
2015-12-18	AOK	ETF	31.61	31.739	31.61	31.68	98011.0
2015-12-18	AOM	ETF	34.28	34.33	34.1	34.13	717134.0
2015-12-18	AOR	ETF	39.04	39.1	38.71	38.75	1016599.0
2015-12-18	ARGT	ETF	17.92	18.11	17.38	17.56	58000.0
2015-12-18	ARKG	ETF	20.37	20.37	20.29	20.29	600.0
2015-12-18	ARKK	ETF	21.0	21.0	20.86	20.93	1500.0
2015-12-18	ARKQ	ETF	19.37	19.37	19.37	19.37	400.0
2015-12-18	ARKW	ETF	23.6	23.6	23.33	23.377	2900.0
2015-12-18	ASEA	ETF	12.52	12.52	12.39	12.45	1400.0
2015-12-18	ASHR	ETF	28.4	28.66	28.4	28.6	2699700.0
2015-12-18	ASHS	ETF	42.7	43.05	42.46	42.71	78400.0
2015-12-18	ATMP	ETF	16.64	16.81	16.3	16.49	568400.0
2015-12-18	BAB	ETF	29.17	29.17	29.0	29.07	169033.0
2015-12-18	BAL	ETF	41.85	42.4071	41.85	42.389	2835.0
2015-12-18	BBC	ETF	29.4125	29.83	29.15	29.2005	5605.0
2015-12-18	BBH	ETF	123.75	124.8	123.18	123.45	62200.0
2015-12-18	BBP	ETF	30.42	30.71	30.332	30.53	5600.0
2015-12-18	BCM	ETF	23.689	23.689	23.585	23.626	1937.0
2015-12-18	BDCZ	ETF	20.12	20.12	20.01	20.01	300.0

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

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