PREVIEW / etf_daily / 2017-01-04

all etf daily files

  file:    by_date/etf_daily/2017/2017-01-04.parquet
  size:    54 KB
  rows:    1,382

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
2017-01-04	SPY	ETF	225.62	226.75	225.61	226.58	78744400.0
2017-01-04	QQQ	ETF	119.67	120.41	119.6561	120.19	19749074.0
2017-01-04	IWM	ETF	136.05	137.96	136.01	137.78	34499400.0
2017-01-04	DIA	ETF	198.76	199.36	198.6	199.15	4823200.0
2017-01-04	GLD	ETF	111.06	111.22	110.61	110.86	4904100.0
2017-01-04	TLT	ETF	119.76	120.24	119.45	120.1	6699600.0
2017-01-04	AADR	ETF	41.84	41.96	41.49	41.96	6800.0
2017-01-04	AAXJ	ETF	55.76	56.16	55.76	56.02	1122600.0
2017-01-04	ACSI	ETF	27.21	27.39	27.21	27.39	5936.0
2017-01-04	ACTX	ETF	23.6002	26.5502	23.0102	26.5502	1724.0
2017-01-04	ACWF	ETF	24.5799	24.58	24.5799	24.58	333.0
2017-01-04	ACWI	ETF	59.87	60.14	59.84	60.14	1087300.0
2017-01-04	ACWV	ETF	73.08	73.28	73.06	73.28	212600.0
2017-01-04	ACWX	ETF	40.7	40.94	40.7	40.94	1172681.0
2017-01-04	ADRE	ETF	32.93	33.14	32.9194	33.14	3417.0
2017-01-04	AFK	ETF	20.06	20.3503	19.97	20.15	7939.0
2017-01-04	AFTY	ETF	13.31	13.47	13.31	13.45	1300.0
2017-01-04	AGG	ETF	108.16	108.21	108.03	108.2	3297100.0
2017-01-04	AGGY	ETF	49.53	49.68	49.53	49.655	19800.0
2017-01-04	AGQ	ETF	34.1	34.5	33.83	34.21	222200.0
2017-01-04	AGZ	ETF	112.56	112.68	112.4349	112.59	10253.0
2017-01-04	AGZD	ETF	24.18	24.18	24.15	24.15	3000.0
2017-01-04	AIA	ETF	46.96	47.099	46.96	47.04	8254.0
2017-01-04	AIQ	ETF	9.6	9.6	9.55	9.6	19772.0
2017-01-04	AIRR	ETF	24.06	24.17	23.94	24.15	121600.0
2017-01-04	AIVI	ETF	37.75	37.85	37.67	37.82	14400.0
2017-01-04	ALTY	ETF	15.21	15.21	15.15	15.15	4300.0
2017-01-04	AMJ	ETF	31.9	32.09	31.71	31.98	2030301.0
2017-01-04	AMLP	ETF	63.7	64.0	63.4	63.9	1877220.0
2017-01-04	AMZA	ETF	109.8	110.17	108.81	110.0	101960.0
2017-01-04	ANGL	ETF	28.95	28.99	28.94	28.98	278600.0
2017-01-04	AOA	ETF	47.48	47.82	47.48	47.82	130200.0
2017-01-04	AOK	ETF	32.6	32.71	32.57	32.69	127108.0
2017-01-04	AOM	ETF	35.32	35.55	35.32	35.53	399737.0
2017-01-04	AOR	ETF	40.77	40.92	40.76	40.92	127686.0
2017-01-04	ARGT	ETF	23.77	23.89	23.66	23.86	22000.0
2017-01-04	ARKG	ETF	17.544	18.2	17.544	18.15	1000.0
2017-01-04	ARKK	ETF	20.755	21.36	20.755	21.36	900.0
2017-01-04	ARKQ	ETF	22.41	22.66	22.41	22.65	2100.0
2017-01-04	ARKW	ETF	25.66	26.17	25.66	26.17	3700.0
2017-01-04	ASEA	ETF	12.96	13.08	12.96	13.08	2000.0
2017-01-04	ASHR	ETF	24.25	24.47	24.25	24.47	1417800.0
2017-01-04	ASHS	ETF	33.4	33.64	33.37	33.64	8200.0
2017-01-04	ASHX	ETF	19.24	19.24	19.24	19.24	1200.0
2017-01-04	ATMP	ETF	23.9	23.94	23.45	23.91	41500.0
2017-01-04	BAB	ETF	29.2	29.21	29.12	29.18	123593.0
2017-01-04	BAL	ETF	47.95	48.9855	47.95	48.88	27631.0
2017-01-04	BBC	ETF	18.45	19.75	18.45	19.71	117115.0
2017-01-04	BBH	ETF	109.87	112.38	109.87	111.85	105800.0
2017-01-04	BBP	ETF	33.01	34.28	33.01	34.28	8000.0

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

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