PREVIEW / etf_daily / 2016-02-01

all etf daily files

  file:    by_date/etf_daily/2016/2016-02-01.parquet
  size:    50 KB
  rows:    1,242

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
2016-02-01	SPY	ETF	192.53	194.58	191.84	193.65	136061600.0
2016-02-01	QQQ	ETF	103.62	104.8	103.23	104.41	32750348.0
2016-02-01	IWM	ETF	102.14	103.09	101.25	102.49	33615700.0
2016-02-01	DIA	ETF	163.39	164.97	162.82	164.34	6977300.0
2016-02-01	GLD	ETF	107.54	108.15	107.53	108.05	10471800.0
2016-02-01	TLT	ETF	126.79	127.07	126.29	126.67	9948400.0
2016-02-01	AADR	ETF	36.24	36.64	36.24	36.37	16600.0
2016-02-01	AAXJ	ETF	49.13	49.42	48.92	49.3	1296100.0
2016-02-01	ACTX	ETF	6.1951	6.1951	4.72	5.31	162.0
2016-02-01	ACWF	ETF	21.3199	21.4799	21.3199	21.4799	1936.0
2016-02-01	ACWI	ETF	52.44	52.97	52.25	52.76	3367400.0
2016-02-01	ACWV	ETF	68.03	68.71	68.01	68.56	84900.0
2016-02-01	ACWX	ETF	37.01	37.41	36.91	37.28	1540595.0
2016-02-01	ADRE	ETF	26.73	27.0325	26.59	27.0	4172.0
2016-02-01	AFK	ETF	16.26	16.62	16.2	16.4601	37184.0
2016-02-01	AFTY	ETF	11.38	11.42	11.33	11.33	13000.0
2016-02-01	AGG	ETF	109.1	109.25	108.84	108.99	4512300.0
2016-02-01	AGGY	ETF	49.655	49.695	49.42	49.57	14400.0
2016-02-01	AGQ	ETF	28.72	29.2	28.52	28.97	158300.0
2016-02-01	AGZ	ETF	113.93	114.0799	113.7612	113.79	15087.0
2016-02-01	AGZD	ETF	23.645	23.645	23.64	23.64	1000.0
2016-02-01	AIA	ETF	38.48	38.73	38.38	38.66	20972.0
2016-02-01	AIQ	ETF	7.35	7.48	7.08	7.4	7226.0
2016-02-01	AIRR	ETF	15.09	15.16	14.95	15.16	4100.0
2016-02-01	AIVI	ETF	36.67	37.02	36.55	36.97	14400.0
2016-02-01	ALTY	ETF	13.1	13.18	13.1	13.18	300.0
2016-02-01	AMJ	ETF	25.11	25.47	24.47	25.24	6041431.0
2016-02-01	AMLP	ETF	50.75	51.75	49.4	51.05	3765260.0
2016-02-01	AMZA	ETF	85.6	87.3	81.5	85.8	19530.0
2016-02-01	ANGL	ETF	23.77	23.9	23.74	23.87	48700.0
2016-02-01	AOA	ETF	42.74	43.04	42.66	42.93	134400.0
2016-02-01	AOK	ETF	31.24	31.28	31.16	31.24	101924.0
2016-02-01	AOM	ETF	33.41	33.51	33.36	33.47	335014.0
2016-02-01	AOR	ETF	37.59	37.72	37.4701	37.66	568826.0
2016-02-01	ARGT	ETF	17.16	17.29	16.96	17.18	25400.0
2016-02-01	ARKG	ETF	16.79	16.79	16.79	16.79	100.0
2016-02-01	ARKK	ETF	16.875	16.875	16.875	16.875	100.0
2016-02-01	ARKQ	ETF	16.03	16.03	16.03	16.03	100.0
2016-02-01	ARKW	ETF	18.9	19.483	18.9	19.483	3700.0
2016-02-01	ASEA	ETF	11.87	11.9	11.85	11.9	3000.0
2016-02-01	ASET	ETF	23.6224	23.78	23.6174	23.75	18040.0
2016-02-01	ASHR	ETF	21.39	21.52	21.3	21.43	1785100.0
2016-02-01	ASHS	ETF	28.63	29.28	28.63	28.82	96800.0
2016-02-01	ATMP	ETF	16.36	16.82	16.18	16.63	278300.0
2016-02-01	BAB	ETF	29.83	29.8464	29.74	29.83	330034.0
2016-02-01	BAL	ETF	40.62	40.99	40.62	40.8321	9604.0
2016-02-01	BBC	ETF	19.03	19.3601	18.8	19.3601	2315.0
2016-02-01	BBH	ETF	100.0	103.02	100.0	102.41	122600.0
2016-02-01	BBP	ETF	23.73	24.11	23.67	24.11	4400.0
2016-02-01	BCM	ETF	23.09	23.09	22.96	22.985	19047.0

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

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