PREVIEW / etf_daily / 2018-12-31

all etf daily files

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

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-31	SPY	ETF	249.56	250.19	247.47	249.92	144299400.0
2018-12-31	QQQ	ETF	154.47	154.98	152.71	154.26	53015313.0
2018-12-31	IWM	ETF	133.72	134.05	131.8	133.9	29173400.0
2018-12-31	DIA	ETF	232.33	233.26	231.05	233.2	5079600.0
2018-12-31	GLD	ETF	120.98	121.26	120.83	121.25	8449400.0
2018-12-31	TLT	ETF	120.65	121.56	120.46	121.51	17409000.0
2018-12-31	AAAU	ETF	12.8	12.83	12.78	12.82	30300.0
2018-12-31	AADR	ETF	40.06	40.5	39.78	40.07	81100.0
2018-12-31	AAXJ	ETF	64.21	64.21	63.33	63.53	1324400.0
2018-12-31	ACES	ETF	23.45	23.45	22.53	22.705	27800.0
2018-12-31	ACSI	ETF	28.92	28.92	28.83	28.86	1887.0
2018-12-31	ACTX	ETF	45.4304	52.5105	45.4304	46.0204	452.0
2018-12-31	ACWF	ETF	26.08	26.08	25.88	25.97	32809.0
2018-12-31	ACWI	ETF	64.14	64.4	63.77	64.16	8905900.0
2018-12-31	ACWV	ETF	81.14	81.36	80.75	81.26	801700.0
2018-12-31	ACWX	ETF	42.21	42.23	41.76	41.96	6255563.0
2018-12-31	ADRE	ETF	36.82	36.82	36.03	36.0743	15247.0
2018-12-31	AFIF	ETF	9.8933	9.93	9.88	9.905	25656.0
2018-12-31	AFK	ETF	19.76	19.76	19.5	19.66	36535.0
2018-12-31	AFTY	ETF	13.13	13.21	13.09	13.11	2400.0
2018-12-31	AGG	ETF	106.12	106.51	106.11	106.49	9671800.0
2018-12-31	AGGY	ETF	48.11	48.22	48.069	48.22	100000.0
2018-12-31	AGNG	ETF	18.892	19.215	18.86	18.973	14600.0
2018-12-31	AGQ	ETF	26.01	26.49	25.89	26.37	140200.0
2018-12-31	AGZ	ETF	111.89	112.14	111.89	112.13	22616.0
2018-12-31	AGZD	ETF	23.655	23.76	23.62	23.63	24600.0
2018-12-31	AIA	ETF	55.9	55.9	55.08	55.3	70988.0
2018-12-31	AIEQ	ETF	21.77	21.919	21.61	21.82	93600.0
2018-12-31	AIQ	ETF	12.9986	12.9988	12.85	12.86	7768.0
2018-12-31	AIRR	ETF	21.58	21.69	21.365	21.69	115700.0
2018-12-31	AIVI	ETF	38.09	38.09	37.71	37.9	21300.0
2018-12-31	ALTY	ETF	13.41	13.426	13.29	13.29	3100.0
2018-12-31	AMJ	ETF	22.06	22.32	21.96	22.32	10112577.0
2018-12-31	AMLP	ETF	43.4	43.75	43.1	43.65	11057100.0
2018-12-31	AMUB	ETF	14.135	14.135	13.97	13.97	100.0
2018-12-31	AMZA	ETF	50.0	51.0	49.55	50.2	152920.0
2018-12-31	ANGL	ETF	26.72	26.79	26.67	26.67	215100.0
2018-12-31	AOA	ETF	48.7	49.67	48.29	48.55	443300.0
2018-12-31	AOK	ETF	32.82	32.91	32.6301	32.72	406882.0
2018-12-31	AOM	ETF	35.86	35.9999	35.5696	35.68	1046436.0
2018-12-31	AOR	ETF	41.6	41.66	41.06	41.31	659420.0
2018-12-31	ARCM	ETF	99.6	99.76	99.6	99.645	4400.0
2018-12-31	ARGT	ETF	23.26	23.5	23.03	23.47	58800.0
2018-12-31	ARKG	ETF	23.52	24.07	23.52	23.98	405500.0
2018-12-31	ARKK	ETF	37.0	37.309	36.64	37.19	645300.0
2018-12-31	ARKQ	ETF	29.68	29.93	29.235	29.49	30700.0
2018-12-31	ARKW	ETF	42.62	42.88	41.95	42.42	314700.0
2018-12-31	ASEA	ETF	15.14	15.24	15.14	15.24	1400.0
2018-12-31	ASET	ETF	25.44	25.44	25.17	25.32	28154.0
2018-12-31	ASHR	ETF	22.08	22.14	21.91	21.93	833100.0

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

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