PREVIEW / etf_daily / 2015-10-08

all etf daily files

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

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-08	SPY	ETF	198.95	201.55	198.59	201.21	153055200.0
2015-10-08	QQQ	ETF	105.23	106.23	104.21	106.05	50188873.0
2015-10-08	IWM	ETF	114.38	115.75	113.95	115.51	43072200.0
2015-10-08	DIA	ETF	168.67	170.66	168.43	170.37	8160300.0
2015-10-08	GLD	ETF	109.16	110.27	109.06	109.14	5038200.0
2015-10-08	TLT	ETF	123.29	123.37	121.66	121.96	12882300.0
2015-10-08	AADR	ETF	37.29	37.45	37.15	37.29	2600.0
2015-10-08	AAXJ	ETF	56.01	57.02	56.01	56.93	845600.0
2015-10-08	ACTX	ETF	14.1601	14.1601	9.4401	11.8001	2734.0
2015-10-08	ACWI	ETF	56.47	57.16	56.36	57.11	1726400.0
2015-10-08	ACWV	ETF	68.68	69.42	68.67	69.36	31900.0
2015-10-08	ACWX	ETF	41.21	41.79	41.14	41.73	642940.0
2015-10-08	ADRE	ETF	29.77	30.08	29.77	30.08	6183.0
2015-10-08	AFK	ETF	20.91	21.16	20.83	21.1217	10540.0
2015-10-08	AFTY	ETF	15.3	15.67	15.29	15.61	27900.0
2015-10-08	AGG	ETF	109.7	109.7	109.3	109.42	2038700.0
2015-10-08	AGGY	ETF	49.93	49.98	49.93	49.93	500.0
2015-10-08	AGQ	ETF	35.13	36.1	35.01	35.49	250000.0
2015-10-08	AGZ	ETF	113.92	114.09	113.8	113.85	22652.0
2015-10-08	AGZD	ETF	23.99	24.0	23.975	23.975	1800.0
2015-10-08	AIA	ETF	44.67	45.39	44.67	45.31	18461.0
2015-10-08	AIQ	ETF	10.26	10.46	10.0	10.34	52841.0
2015-10-08	AIRR	ETF	16.34	16.92	16.34	16.92	21000.0
2015-10-08	AIVI	ETF	40.15	40.85	40.15	40.85	24000.0
2015-10-08	ALTY	ETF	14.51	14.51	14.51	14.51	200.0
2015-10-08	AMJ	ETF	34.19	34.754	33.6	34.56	2818504.0
2015-10-08	AMLP	ETF	69.8	70.85	69.1	70.55	1234560.0
2015-10-08	AMZA	ETF	152.2	155.4	150.0	155.4	540.0
2015-10-08	ANGL	ETF	26.08	26.1	25.89	26.1	15000.0
2015-10-08	AOA	ETF	45.22	45.52	45.06	45.47	21200.0
2015-10-08	AOK	ETF	31.88	32.0499	31.88	32.04	37659.0
2015-10-08	AOM	ETF	34.26	34.54	34.26	34.54	66180.0
2015-10-08	AOR	ETF	39.12	39.37	39.0401	39.37	126000.0
2015-10-08	ARGT	ETF	17.45	17.6	17.3	17.6	1600.0
2015-10-08	ARKG	ETF	18.68	18.68	18.68	18.68	200.0
2015-10-08	ARKK	ETF	19.39	19.39	19.39	19.39	200.0
2015-10-08	ARKQ	ETF	18.21	18.21	18.21	18.21	300.0
2015-10-08	ARKW	ETF	22.28	22.28	21.75	21.75	800.0
2015-10-08	ASEA	ETF	13.13	13.33	13.1	13.31	5300.0
2015-10-08	ASHR	ETF	33.59	34.07	33.43	34.06	2605300.0
2015-10-08	ASHS	ETF	38.57	38.8	38.24	38.71	22200.0
2015-10-08	ATMP	ETF	23.66	23.8	23.26	23.71	36400.0
2015-10-08	AWAY	ETF	27.57	27.9	27.35	27.51	1124294.0
2015-10-08	BAB	ETF	29.3	29.31	29.08	29.15	79646.0
2015-10-08	BAL	ETF	41.0	41.12	41.0	41.12	942.0
2015-10-08	BBC	ETF	27.56	27.56	26.31	27.03	3287.0
2015-10-08	BBH	ETF	115.74	116.78	112.49	116.13	199700.0
2015-10-08	BBP	ETF	28.64	28.71	27.64	28.35	9300.0
2015-10-08	BCM	ETF	27.51	27.77	27.51	27.734	1840.0
2015-10-08	BFOR	ETF	7.7125	7.805	7.7125	7.7925	208800.0

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

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