PREVIEW / etf_daily / 2017-01-05

all etf daily files

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

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-05	SPY	ETF	226.27	226.58	225.48	226.4	78379000.0
2017-01-05	QQQ	ETF	120.16	120.95	120.1	120.87	20644254.0
2017-01-05	IWM	ETF	137.49	137.76	135.51	136.19	30286900.0
2017-01-05	DIA	ETF	198.95	199.27	197.9	198.75	4124500.0
2017-01-05	GLD	ETF	112.16	112.94	112.07	112.58	9606800.0
2017-01-05	TLT	ETF	120.45	122.03	120.17	121.98	13265800.0
2017-01-05	AADR	ETF	42.49	42.95	42.24	42.41	6200.0
2017-01-05	AAXJ	ETF	56.58	56.95	56.58	56.81	2471500.0
2017-01-05	ACSI	ETF	27.44	27.44	27.14	27.25	9320.0
2017-01-05	ACTX	ETF	26.5502	27.7302	25.9602	27.7302	1700.0
2017-01-05	ACWI	ETF	60.15	60.4	60.15	60.37	1717300.0
2017-01-05	ACWV	ETF	73.41	73.71	73.39	73.67	235100.0
2017-01-05	ACWX	ETF	41.07	41.35	41.07	41.29	646128.0
2017-01-05	ADRE	ETF	33.34	33.85	33.34	33.85	18633.0
2017-01-05	AFK	ETF	20.24	20.45	20.135	20.3005	9332.0
2017-01-05	AFTY	ETF	13.53	13.57	13.53	13.55	1600.0
2017-01-05	AGG	ETF	108.37	108.68	108.22	108.65	5165900.0
2017-01-05	AGGY	ETF	49.77	49.94	49.7	49.94	14200.0
2017-01-05	AGQ	ETF	34.91	35.33	34.51	34.88	273800.0
2017-01-05	AGZ	ETF	113.48	113.48	112.6086	112.83	78470.0
2017-01-05	AGZD	ETF	24.09	24.15	24.09	24.145	37800.0
2017-01-05	AIA	ETF	47.45	47.72	47.41	47.62	395677.0
2017-01-05	AIQ	ETF	9.575	9.65	9.55	9.65	92830.0
2017-01-05	AIRR	ETF	24.24	24.24	23.64	23.74	128100.0
2017-01-05	AIVI	ETF	38.04	38.36	38.04	38.32	6500.0
2017-01-05	ALTY	ETF	15.254	15.28	15.254	15.263	2000.0
2017-01-05	AMJ	ETF	32.0	32.265	32.0	32.13	2347789.0
2017-01-05	AMLP	ETF	63.85	64.15	63.8	64.0	1764600.0
2017-01-05	AMZA	ETF	110.0	110.5	109.4	110.0	47700.0
2017-01-05	ANGL	ETF	29.06	29.06	29.01	29.05	385800.0
2017-01-05	AOA	ETF	47.89	48.0	47.83	48.0	144200.0
2017-01-05	AOK	ETF	32.75	32.82	32.63	32.82	91669.0
2017-01-05	AOM	ETF	35.55	35.56	35.4738	35.49	225032.0
2017-01-05	AOR	ETF	40.98	41.11	40.92	41.11	465188.0
2017-01-05	ARGT	ETF	23.96	24.22	23.96	24.2	111500.0
2017-01-05	ARKG	ETF	18.14	18.14	17.77	17.927	1700.0
2017-01-05	ARKK	ETF	21.1	21.15	21.05	21.15	37400.0
2017-01-05	ARKQ	ETF	22.57	22.67	22.39	22.49	2600.0
2017-01-05	ARKW	ETF	26.31	26.37	26.135	26.35	11700.0
2017-01-05	ASEA	ETF	13.16	13.34	13.16	13.34	400.0
2017-01-05	ASET	ETF	26.05	26.05	26.01	26.01	800.0
2017-01-05	ASHR	ETF	24.52	24.68	24.52	24.66	2601400.0
2017-01-05	ASHS	ETF	33.97	34.04	33.97	34.02	3800.0
2017-01-05	ASHX	ETF	19.22	19.22	19.19	19.2	609.0
2017-01-05	ATMP	ETF	23.91	24.77	23.8	24.08	57800.0
2017-01-05	BAB	ETF	29.21	29.46	29.1962	29.39	211660.0
2017-01-05	BAL	ETF	48.88	49.2	48.64	48.7	5010.0
2017-01-05	BBC	ETF	19.79	19.8	19.43	19.62	2825.0
2017-01-05	BBH	ETF	112.08	112.77	111.59	112.59	35700.0
2017-01-05	BBP	ETF	34.47	34.5	34.0	34.3	6300.0

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

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