PREVIEW / etf_daily / 2018-12-24

all etf daily files

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

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-24	SPY	ETF	239.04	240.84	234.27	234.34	147311600.0
2018-12-24	QQQ	ETF	146.14	147.98	143.46	143.5	56163290.0
2018-12-24	IWM	ETF	127.73	128.47	125.84	125.88	28575700.0
2018-12-24	DIA	ETF	222.5	223.31	217.88	218.1	7024000.0
2018-12-24	GLD	ETF	119.57	120.14	119.57	120.02	9736400.0
2018-12-24	TLT	ETF	121.13	121.42	120.91	121.32	8377500.0
2018-12-24	AAAU	ETF	12.65	12.69	12.65	12.68	132300.0
2018-12-24	AADR	ETF	38.42	38.72	38.19	38.42	38900.0
2018-12-24	AAXJ	ETF	62.6	63.0	62.12	62.12	287300.0
2018-12-24	ACES	ETF	22.57	22.57	21.36	21.36	1200.0
2018-12-24	ACSI	ETF	28.1673	28.1673	27.893	27.893	2287.0
2018-12-24	ACTX	ETF	45.7254	47.2004	41.8904	46.0204	814.0
2018-12-24	ACWF	ETF	25.23	25.35	24.9675	24.98	34397.0
2018-12-24	ACWI	ETF	62.15	62.37	61.14	61.18	7077900.0
2018-12-24	ACWV	ETF	79.77	79.88	78.21	78.32	309700.0
2018-12-24	ACWX	ETF	41.14	41.28	40.66	40.69	3569963.0
2018-12-24	ADRE	ETF	35.32	35.32	34.9904	34.9904	2758.0
2018-12-24	AFIF	ETF	9.881	9.91	9.86	9.88	25543.0
2018-12-24	AFK	ETF	19.0	19.36	19.0	19.2181	30415.0
2018-12-24	AFTY	ETF	13.02	13.23	13.02	13.05	3400.0
2018-12-24	AGG	ETF	105.95	106.0	105.81	105.86	7196100.0
2018-12-24	AGGY	ETF	47.93	47.97	47.89	47.913	40600.0
2018-12-24	AGNG	ETF	18.17	18.269	18.03	18.13	4500.0
2018-12-24	AGQ	ETF	23.89	24.25	23.89	24.17	144700.0
2018-12-24	AGZ	ETF	111.62	111.7078	111.5804	111.68	31965.0
2018-12-24	AGZD	ETF	23.685	23.795	23.655	23.685	41600.0
2018-12-24	AIA	ETF	54.31	54.76	54.11	54.11	65764.0
2018-12-24	AIEQ	ETF	20.68	20.8	20.35	20.35	142200.0
2018-12-24	AIQ	ETF	12.46	12.46	12.24	12.2461	3350.0
2018-12-24	AIRR	ETF	20.63	20.91	20.46	20.46	75700.0
2018-12-24	AIVI	ETF	37.36	37.37	36.88	36.91	57500.0
2018-12-24	ALTY	ETF	13.18	13.19	12.93	12.93	5900.0
2018-12-24	AMJ	ETF	22.0	22.0	21.2	21.22	3371662.0
2018-12-24	AMLP	ETF	43.2	43.25	41.6	41.6	4437800.0
2018-12-24	AMUB	ETF	13.4838	13.4838	13.3363	13.3363	200.0
2018-12-24	AMZA	ETF	49.7	49.7	47.6	47.6	170970.0
2018-12-24	ANGL	ETF	26.48	26.66	26.25	26.29	243000.0
2018-12-24	AOA	ETF	47.58	47.77	47.04	47.04	568900.0
2018-12-24	AOK	ETF	32.58	32.65	32.36	32.3682	109126.0
2018-12-24	AOM	ETF	35.35	35.49	35.16	35.24	968979.0
2018-12-24	AOR	ETF	40.67	40.8153	40.34	40.34	563182.0
2018-12-24	ARGT	ETF	22.47	22.52	21.87	21.88	47900.0
2018-12-24	ARKG	ETF	22.32	22.76	21.976	22.4	142200.0
2018-12-24	ARKK	ETF	35.43	36.08	34.9	35.34	425800.0
2018-12-24	ARKQ	ETF	28.84	29.26	28.515	28.786	17400.0
2018-12-24	ARKW	ETF	44.82	45.61	44.271	44.63	209400.0
2018-12-24	ARVR	ETF	15.87	16.105	15.84	16.105	736.0
2018-12-24	ASEA	ETF	15.41	15.44	15.35	15.44	900.0
2018-12-24	ASET	ETF	25.15	25.16	24.969	24.969	825.0
2018-12-24	ASHR	ETF	21.8	21.94	21.76	21.81	1242300.0

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

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