PREVIEW / etf_daily / 2015-10-06

all etf daily files

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

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-06	SPY	ETF	198.31	198.98	197.0	197.79	110274500.0
2015-10-06	QQQ	ETF	105.25	105.6	104.18	105.0	33051534.0
2015-10-06	IWM	ETF	113.21	113.67	111.78	112.49	34140000.0
2015-10-06	DIA	ETF	167.74	168.43	167.25	167.69	6661000.0
2015-10-06	GLD	ETF	109.8	110.26	109.63	109.86	7513900.0
2015-10-06	TLT	ETF	122.55	123.6	122.41	123.4	5687800.0
2015-10-06	AADR	ETF	37.3	37.3	36.82	36.94	3000.0
2015-10-06	AAXJ	ETF	55.0	55.17	54.77	54.92	1290500.0
2015-10-06	ACTX	ETF	11.8001	12.9801	9.4401	9.4401	984.0
2015-10-06	ACWF	ETF	23.16	23.16	22.98	23.02	827.0
2015-10-06	ACWI	ETF	55.98	56.2	55.8	55.99	3766700.0
2015-10-06	ACWV	ETF	68.7	68.79	68.31	68.51	57200.0
2015-10-06	ACWX	ETF	40.71	40.92	40.68	40.81	621214.0
2015-10-06	ADRE	ETF	29.4	29.62	29.4	29.49	15779.0
2015-10-06	AFK	ETF	20.6593	20.6593	20.512	20.64	13888.0
2015-10-06	AFTY	ETF	15.66	15.66	15.46	15.47	14700.0
2015-10-06	AGG	ETF	109.47	109.69	109.37	109.65	5013800.0
2015-10-06	AGQ	ETF	36.25	37.25	35.89	35.98	388200.0
2015-10-06	AGZ	ETF	114.0799	114.2899	113.885	113.9	117417.0
2015-10-06	AGZD	ETF	23.95	23.95	23.875	23.94	3200.0
2015-10-06	AIA	ETF	43.31	43.49	43.27	43.38	10916.0
2015-10-06	AIQ	ETF	10.88	10.9199	10.065	10.18	49620.0
2015-10-06	AIRR	ETF	16.1	16.17	16.02	16.05	31400.0
2015-10-06	AIVI	ETF	39.63	39.87	39.62	39.86	9300.0
2015-10-06	AMJ	ETF	33.86	34.35	33.53	33.58	2188944.0
2015-10-06	AMLP	ETF	69.15	70.2	68.75	69.15	1544420.0
2015-10-06	AMZA	ETF	152.5	155.7	147.15	147.9	1870.0
2015-10-06	ANGL	ETF	25.66	25.7	25.55	25.69	12800.0
2015-10-06	AOA	ETF	44.91	44.93	44.7	44.83	78700.0
2015-10-06	AOK	ETF	31.78	31.99	31.78	31.81	36393.0
2015-10-06	AOM	ETF	34.33	34.34	34.15	34.19	103316.0
2015-10-06	AOR	ETF	38.81	38.935	38.81	38.89	70664.0
2015-10-06	ARGT	ETF	17.03	17.06	17.01	17.01	2000.0
2015-10-06	ARKG	ETF	18.58	18.82	18.487	18.82	3800.0
2015-10-06	ARKK	ETF	19.23	19.23	19.23	19.23	100.0
2015-10-06	ARKQ	ETF	17.93	17.95	17.93	17.95	1900.0
2015-10-06	ARKW	ETF	21.786	21.786	21.786	21.786	400.0
2015-10-06	ASEA	ETF	12.67	12.67	12.59	12.63	12800.0
2015-10-06	ASHR	ETF	33.5	33.84	33.5	33.59	728000.0
2015-10-06	ASHS	ETF	37.93	38.23	37.8	38.1	95000.0
2015-10-06	ATMP	ETF	23.23	23.39	23.0	23.02	44800.0
2015-10-06	AWAY	ETF	27.7	28.11	27.16	27.2	1078619.0
2015-10-06	BAB	ETF	29.21	29.35	29.21	29.35	63204.0
2015-10-06	BAL	ETF	41.49	41.56	41.26	41.29	5802.0
2015-10-06	BBC	ETF	27.82	27.82	25.8907	26.96	11392.0
2015-10-06	BBH	ETF	116.07	116.2	110.44	113.69	276700.0
2015-10-06	BBP	ETF	29.05	29.05	27.415	28.1	13000.0
2015-10-06	BCM	ETF	27.54	27.638	27.48	27.638	9316.0
2015-10-06	BFOR	ETF	7.6775	7.68	7.605	7.6125	99600.0
2015-10-06	BIB	ETF	60.73	61.24	54.3	58.0	2646378.0

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

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