PREVIEW / etf_daily / 2018-11-19

all etf daily files

  file:    by_date/etf_daily/2018/2018-11-19.parquet
  size:    64 KB
  rows:    1,679

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-11-19	SPY	ETF	273.05	273.38	268.07	269.1	103061700.0
2018-11-19	QQQ	ETF	166.74	166.9	161.54	162.06	67280478.0
2018-11-19	IWM	ETF	151.68	152.03	148.37	148.86	21540900.0
2018-11-19	DIA	ETF	253.61	253.78	248.84	249.86	4249600.0
2018-11-19	GLD	ETF	115.45	115.92	115.37	115.67	8508300.0
2018-11-19	TLT	ETF	114.41	115.02	114.41	115.02	7027200.0
2018-11-19	AAAU	ETF	12.21	12.24	12.2	12.23	17800.0
2018-11-19	AADR	ETF	45.36	45.36	44.55	44.6	7800.0
2018-11-19	AAXJ	ETF	65.6	65.73	65.02	65.14	520200.0
2018-11-19	ACES	ETF	24.67	24.67	24.32	24.535	7200.0
2018-11-19	ACSI	ETF	32.6607	32.68	32.28	32.28	1956.0
2018-11-19	ACTX	ETF	70.8006	70.8006	65.4906	66.6706	357.0
2018-11-19	ACWF	ETF	28.3627	28.3627	28.0754	28.1825	6970.0
2018-11-19	ACWI	ETF	69.38	69.41	68.32	68.53	11799700.0
2018-11-19	ACWV	ETF	85.85	85.91	84.94	85.21	229800.0
2018-11-19	ACWX	ETF	44.45	44.49	44.04	44.15	2469859.0
2018-11-19	ADRE	ETF	38.03	38.03	37.56	37.56	2941.0
2018-11-19	AFIF	ETF	9.9	10.06	9.9	10.0136	65278.0
2018-11-19	AFK	ETF	20.65	20.6799	20.4889	20.6	6449.0
2018-11-19	AFTY	ETF	14.53	14.58	14.43	14.49	4900.0
2018-11-19	AGG	ETF	104.61	104.73	104.61	104.65	4673200.0
2018-11-19	AGGY	ETF	47.53	47.6	47.53	47.6	70500.0
2018-11-19	AGNG	ETF	20.25	20.25	19.679	19.679	1500.0
2018-11-19	AGQ	ETF	23.08	23.23	23.0	23.14	372100.0
2018-11-19	AGZ	ETF	110.58	110.7374	110.5743	110.73	50335.0
2018-11-19	AGZD	ETF	23.81	23.86	23.735	23.79	50000.0
2018-11-19	AIA	ETF	56.74	56.86	56.22	56.37	25647.0
2018-11-19	AIEQ	ETF	26.34	26.469	25.56	25.65	47600.0
2018-11-19	AIQ	ETF	13.9	13.9	13.23	13.23	11268.0
2018-11-19	AIRR	ETF	25.24	25.335	24.88	24.92	20200.0
2018-11-19	AIVI	ETF	40.0	40.01	39.72	39.81	1800.0
2018-11-19	ALTY	ETF	14.52	14.52	14.429	14.47	4400.0
2018-11-19	AMJ	ETF	25.38	25.67	25.29	25.31	1364040.0
2018-11-19	AMLP	ETF	48.3	49.05	48.2	48.35	3677800.0
2018-11-19	AMZA	ETF	63.7	64.2	62.88	63.1	67830.0
2018-11-19	ANGL	ETF	27.34	27.43	27.23	27.35	346100.0
2018-11-19	AOA	ETF	51.52	51.64	50.98	51.0	156000.0
2018-11-19	AOK	ETF	33.27	33.3299	33.1	33.1	76144.0
2018-11-19	AOM	ETF	36.59	36.62	36.38	36.45	343346.0
2018-11-19	AOR	ETF	43.05	43.1299	42.661	42.77	374507.0
2018-11-19	ARCM	ETF	100.08	100.08	100.08	100.08	100.0
2018-11-19	ARGT	ETF	26.13	26.13	25.71	25.81	23800.0
2018-11-19	ARKG	ETF	29.12	29.135	27.745	27.94	72200.0
2018-11-19	ARKK	ETF	43.47	43.5	41.45	41.58	380700.0
2018-11-19	ARKQ	ETF	33.26	33.26	32.097	32.13	14500.0
2018-11-19	ARKW	ETF	52.47	52.5	49.7	49.75	286700.0
2018-11-19	ARVR	ETF	17.86	17.86	17.86	17.86	107.0
2018-11-19	ASET	ETF	26.95	26.97	26.9052	26.9052	653.0
2018-11-19	ASHR	ETF	24.15	24.17	23.89	23.92	1412400.0
2018-11-19	ASHS	ETF	24.87	24.87	24.53	24.62	49100.0

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

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