PREVIEW / etf_daily / 2018-12-18

all etf daily files

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

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-18	SPY	ETF	257.2	257.95	253.28	255.08	134515100.0
2018-12-18	QQQ	ETF	158.67	159.95	157.04	158.42	63642120.0
2018-12-18	IWM	ETF	138.26	139.18	136.29	136.85	42277200.0
2018-12-18	DIA	ETF	238.44	239.81	235.67	237.36	5349600.0
2018-12-18	GLD	ETF	117.85	118.2	117.81	118.15	7542900.0
2018-12-18	TLT	ETF	119.07	119.79	118.94	119.6	10018800.0
2018-12-18	AAAU	ETF	12.46	12.5	12.46	12.49	475500.0
2018-12-18	AADR	ETF	41.67	41.67	41.12	41.12	39800.0
2018-12-18	AAXJ	ETF	63.91	64.24	63.69	63.85	2664600.0
2018-12-18	ACES	ETF	23.375	23.48	23.356	23.356	1100.0
2018-12-18	ACSI	ETF	30.378	30.4	30.1261	30.1261	1321.0
2018-12-18	ACTX	ETF	53.9855	54.2805	51.9205	52.5105	1372.0
2018-12-18	ACWF	ETF	26.755	26.81	26.4	26.5627	233679.0
2018-12-18	ACWI	ETF	65.32	65.57	64.65	64.95	8860000.0
2018-12-18	ACWV	ETF	82.59	82.63	81.73	82.07	448700.0
2018-12-18	ACWX	ETF	42.41	42.53	42.14	42.22	4653571.0
2018-12-18	ADRE	ETF	36.94	36.94	36.4603	36.5937	4017.0
2018-12-18	AFIF	ETF	9.91	9.92	9.88	9.91	23846.0
2018-12-18	AFK	ETF	19.8	20.01	19.8	19.99	4591.0
2018-12-18	AFTY	ETF	13.92	13.92	13.839	13.868	1600.0
2018-12-18	AGG	ETF	105.63	105.84	105.63	105.84	6626100.0
2018-12-18	AGGY	ETF	48.03	48.2	48.03	48.1	207000.0
2018-12-18	AGNG	ETF	19.477	19.477	19.41	19.425	900.0
2018-12-18	AGQ	ETF	23.68	23.94	23.63	23.7	64400.0
2018-12-18	AGZ	ETF	111.35	111.47	110.85	111.43	39660.0
2018-12-18	AGZD	ETF	23.75	23.805	23.75	23.8	88400.0
2018-12-18	AIA	ETF	55.17	55.43	55.02	55.21	216283.0
2018-12-18	AIEQ	ETF	24.21	24.46	24.07	24.25	112700.0
2018-12-18	AIQ	ETF	13.3607	13.4207	13.3	13.3587	2405.0
2018-12-18	AIRR	ETF	22.22	22.48	22.11	22.11	32900.0
2018-12-18	AIVI	ETF	38.7	38.7	38.32	38.46	5800.0
2018-12-18	ALTY	ETF	13.57	13.741	13.57	13.61	16000.0
2018-12-18	AMJ	ETF	23.44	23.6401	22.73	22.95	5814382.0
2018-12-18	AMLP	ETF	46.1	46.4	44.55	44.95	6114260.0
2018-12-18	AMUB	ETF	14.4329	14.4329	14.4329	14.4329	0.0
2018-12-18	AMZA	ETF	56.4	57.09	54.2	54.9	158230.0
2018-12-18	ANGL	ETF	27.21	27.32	27.15	27.16	245300.0
2018-12-18	AOA	ETF	49.46	49.66	49.18	49.29	658300.0
2018-12-18	AOK	ETF	32.94	33.0599	32.8601	32.94	465869.0
2018-12-18	AOM	ETF	36.0617	36.1399	35.96	36.06	1400776.0
2018-12-18	AOR	ETF	41.82	41.99	41.6652	41.81	1756446.0
2018-12-18	ARGT	ETF	23.83	24.0	23.72	23.79	280900.0
2018-12-18	ARKG	ETF	26.57	26.664	25.51	25.845	99600.0
2018-12-18	ARKK	ETF	40.34	40.65	39.5	39.89	299500.0
2018-12-18	ARKQ	ETF	31.03	31.36	30.85	31.0	28700.0
2018-12-18	ARKW	ETF	49.64	50.25	49.25	49.64	102000.0
2018-12-18	ARVR	ETF	16.92	16.92	16.84	16.84	420.0
2018-12-18	ASEA	ETF	15.51	15.63	15.51	15.63	300.0
2018-12-18	ASET	ETF	26.32	26.3327	26.32	26.3327	434.0
2018-12-18	ASHR	ETF	22.86	22.88	22.72	22.8	1593300.0

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

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