PREVIEW / etf_daily / 2018-12-27

all etf daily files

  file:    by_date/etf_daily/2018/2018-12-27.parquet
  size:    67 KB
  rows:    1,729

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
2018-12-27	SPY	ETF	242.57	248.29	238.96	248.07	186267300.0
2018-12-27	QQQ	ETF	150.57	153.18	147.08	153.05	85824343.0
2018-12-27	IWM	ETF	130.27	132.48	127.87	132.48	39527900.0
2018-12-27	DIA	ETF	225.54	231.37	222.53	231.26	7952000.0
2018-12-27	GLD	ETF	120.57	120.9	120.14	120.57	11874400.0
2018-12-27	TLT	ETF	121.26	121.38	119.98	120.04	12146500.0
2018-12-27	AAAU	ETF	12.85	12.85	12.72	12.75	14300.0
2018-12-27	AADR	ETF	39.48	39.59	38.59	39.59	45300.0
2018-12-27	AAXJ	ETF	62.6	63.33	62.32	63.31	1622100.0
2018-12-27	ACES	ETF	22.11	22.313	21.98	22.313	13200.0
2018-12-27	ACSI	ETF	28.6381	29.13	28.41	29.13	11227.0
2018-12-27	ACTX	ETF	48.6754	51.9205	46.9054	50.7405	452.0
2018-12-27	ACWF	ETF	25.52	25.9229	25.3271	25.9229	19774.0
2018-12-27	ACWI	ETF	62.71	63.75	61.94	63.74	13249900.0
2018-12-27	ACWV	ETF	79.47	80.81	78.89	80.75	1021000.0
2018-12-27	ACWX	ETF	41.07	41.7	40.85	41.7	7121054.0
2018-12-27	ADRE	ETF	35.43	36.062	35.43	36.062	5288.0
2018-12-27	AFIF	ETF	9.87	9.91	9.87	9.9	32462.0
2018-12-27	AFK	ETF	19.48	19.54	19.42	19.54	5603.0
2018-12-27	AFTY	ETF	13.1	13.11	12.973	13.06	6200.0
2018-12-27	AGG	ETF	105.95	106.06	105.77	105.83	10562200.0
2018-12-27	AGGY	ETF	47.89	47.98	47.87	47.9	80800.0
2018-12-27	AGNG	ETF	18.535	18.68	18.535	18.68	1700.0
2018-12-27	AGQ	ETF	25.5	25.73	25.31	25.69	149700.0
2018-12-27	AGZ	ETF	111.8	111.88	111.7311	111.75	74984.0
2018-12-27	AGZD	ETF	23.69	23.725	23.62	23.69	15000.0
2018-12-27	AIA	ETF	54.56	55.16	54.2375	55.16	301293.0
2018-12-27	AIEQ	ETF	21.37	21.73	20.91	21.73	110300.0
2018-12-27	AIQ	ETF	12.6	12.63	12.6	12.63	642.0
2018-12-27	AIRR	ETF	20.99	21.46	20.769	21.45	111200.0
2018-12-27	AIVI	ETF	37.06	37.52	36.9	37.5	69300.0
2018-12-27	ALTY	ETF	13.176	13.36	13.12	13.36	52000.0
2018-12-27	AMJ	ETF	22.0	22.21	21.22	22.01	10954056.0
2018-12-27	AMLP	ETF	43.4	43.65	41.55	43.35	12113100.0
2018-12-27	AMUB	ETF	13.8296	13.8296	13.8296	13.8296	0.0
2018-12-27	AMZA	ETF	50.1	50.6	47.61	49.9	202580.0
2018-12-27	ANGL	ETF	26.38	26.67	26.38	26.65	515700.0
2018-12-27	AOA	ETF	47.88	48.57	47.53	48.57	491700.0
2018-12-27	AOK	ETF	32.85	32.85	32.48	32.74	609444.0
2018-12-27	AOM	ETF	35.49	35.77	35.4	35.77	1296805.0
2018-12-27	AOR	ETF	40.88	41.34	40.6722	41.27	690327.0
2018-12-27	ARGT	ETF	22.61	23.34	22.25	23.34	39300.0
2018-12-27	ARKG	ETF	23.06	23.168	22.1	23.1	178700.0
2018-12-27	ARKK	ETF	36.09	36.4	34.75	36.4	525200.0
2018-12-27	ARKQ	ETF	29.15	29.22	28.29	29.22	40800.0
2018-12-27	ARKW	ETF	41.42	42.13	40.187	42.12	152700.0
2018-12-27	ASEA	ETF	15.63	15.63	15.5	15.62	6300.0
2018-12-27	ASET	ETF	25.12	25.1901	25.12	25.1501	2079.0
2018-12-27	ASHR	ETF	21.64	21.87	21.62	21.83	1668900.0
2018-12-27	ASHS	ETF	22.34	22.34	22.1	22.2	10100.0

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

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