PREVIEW / etf_daily / 2018-12-21

all etf daily files

  file:    by_date/etf_daily/2018/2018-12-21.parquet
  size:    68 KB
  rows:    1,740

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-21	SPY	ETF	246.74	249.71	239.98	240.7	255345600.0
2018-12-21	QQQ	ETF	153.06	154.09	146.72	147.57	141129408.0
2018-12-21	IWM	ETF	132.38	132.95	127.98	128.37	59404800.0
2018-12-21	DIA	ETF	229.01	232.47	223.85	224.09	10242700.0
2018-12-21	GLD	ETF	119.19	119.25	118.57	118.72	13629800.0
2018-12-21	TLT	ETF	121.14	121.21	120.39	120.72	9945100.0
2018-12-21	AAAU	ETF	12.61	12.61	12.54	12.55	25300.0
2018-12-21	AADR	ETF	40.15	40.23	38.93	39.05	96500.0
2018-12-21	AAXJ	ETF	63.28	63.63	62.48	62.7	1478100.0
2018-12-21	ACES	ETF	22.3	22.3	22.01	22.01	1400.0
2018-12-21	ACSI	ETF	29.3213	29.61	28.608	28.608	2210.0
2018-12-21	ACTX	ETF	56.0505	56.0505	44.8404	45.7254	773.0
2018-12-21	ACWF	ETF	25.73	26.01	25.3501	25.39	114527.0
2018-12-21	ACWI	ETF	63.44	64.06	62.15	62.29	13965000.0
2018-12-21	ACWV	ETF	80.73	81.54	79.62	79.81	1077500.0
2018-12-21	ACWX	ETF	41.55	41.76	40.99	41.03	7590141.0
2018-12-21	ADRE	ETF	36.1	36.1	35.315	35.365	5907.0
2018-12-21	AFIF	ETF	9.89	9.92	9.88	9.9001	15892.0
2018-12-21	AFK	ETF	19.34	20.15	19.21	19.25	8318.0
2018-12-21	AFTY	ETF	13.21	13.21	13.079	13.1	111100.0
2018-12-21	AGG	ETF	105.94	105.96	105.76	105.79	10381200.0
2018-12-21	AGGY	ETF	48.15	48.15	48.04	48.09	86400.0
2018-12-21	AGNG	ETF	18.848	19.12	18.39	18.64	5100.0
2018-12-21	AGQ	ETF	24.01	24.02	23.58	23.65	204000.0
2018-12-21	AGZ	ETF	111.61	111.63	111.461	111.5615	52094.0
2018-12-21	AGZD	ETF	23.76	23.89	23.76	23.775	85400.0
2018-12-21	AIA	ETF	54.98	55.3821	54.4104	54.56	157954.0
2018-12-21	AIEQ	ETF	23.27	23.525	22.63	22.72	215600.0
2018-12-21	AIQ	ETF	12.9112	12.9112	12.5501	12.5651	2148.0
2018-12-21	AIRR	ETF	21.43	21.43	20.75	20.82	84400.0
2018-12-21	AIVI	ETF	37.94	38.07	37.54	37.6	23700.0
2018-12-21	ALTY	ETF	13.3	13.426	13.15	13.15	5400.0
2018-12-21	AMJ	ETF	22.51	22.805	22.04	22.17	8539654.0
2018-12-21	AMLP	ETF	44.1	44.75	43.2	43.6	8810120.0
2018-12-21	AMUB	ETF	13.9049	13.9049	13.9049	13.9049	0.0
2018-12-21	AMZA	ETF	51.3	52.3	50.1	50.2	133690.0
2018-12-21	ANGL	ETF	26.68	26.81	26.52	26.57	472300.0
2018-12-21	AOA	ETF	48.37	48.7	47.64	47.79	242400.0
2018-12-21	AOK	ETF	32.68	32.7896	32.49	32.56	631116.0
2018-12-21	AOM	ETF	35.73	35.82	35.42	35.44	747796.0
2018-12-21	AOR	ETF	41.25	41.4206	40.7144	40.82	634487.0
2018-12-21	ARGT	ETF	23.14	23.31	22.55	22.62	48700.0
2018-12-21	ARKG	ETF	24.28	24.28	22.33	22.36	659800.0
2018-12-21	ARKK	ETF	38.02	38.02	35.67	35.85	737600.0
2018-12-21	ARKQ	ETF	30.04	30.135	29.03	29.33	23600.0
2018-12-21	ARKW	ETF	47.33	47.563	45.061	45.35	242300.0
2018-12-21	ARVR	ETF	15.87	16.0461	15.5	15.94	818.0
2018-12-21	ASEA	ETF	15.54	15.54	15.37	15.44	22500.0
2018-12-21	ASET	ETF	25.95	26.01	25.6097	25.6097	1939.0
2018-12-21	ASHR	ETF	22.0	22.03	21.68	21.68	3029000.0

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

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