PREVIEW / etf_daily / 2020-01-08

all etf daily files

  file:    by_date/etf_daily/2020/2020-01-08.parquet
  size:    74 KB
  rows:    1,937

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
2020-01-08	SPY	ETF	322.94	325.78	322.67	324.45	68296000.0
2020-01-08	QQQ	ETF	215.47	218.14	215.16	217.15	26464212.0
2020-01-08	IWM	ETF	164.82	166.03	164.72	165.31	13832400.0
2020-01-08	DIA	ETF	285.32	288.67	285.08	287.4	3136700.0
2020-01-08	GLD	ETF	148.49	148.61	146.14	146.86	22248500.0
2020-01-08	TLT	ETF	137.93	138.31	136.32	136.74	10621700.0
2020-01-08	AAAU	ETF	15.75	15.75	15.49	15.56	133600.0
2020-01-08	AADR	ETF	54.07	54.63	54.07	54.48	184700.0
2020-01-08	AAXJ	ETF	73.44	74.27	73.38	73.84	1311300.0
2020-01-08	ACES	ETF	34.8	35.103	34.75	34.995	12400.0
2020-01-08	ACIO	ETF	25.644	25.69	25.609	25.609	11300.0
2020-01-08	ACSI	ETF	35.43	35.67	35.42	35.5348	2144.0
2020-01-08	ACTX	ETF	12.3901	13.2751	11.806	11.806	63.0
2020-01-08	ACWF	ETF	31.05	31.3198	31.05	31.2373	5503.0
2020-01-08	ACWI	ETF	79.37	80.03	79.32	79.75	2932900.0
2020-01-08	ACWV	ETF	95.64	96.0	95.64	95.74	478000.0
2020-01-08	ACWX	ETF	49.03	49.36	48.99	49.23	1544223.0
2020-01-08	ADME	ETF	30.52	30.69	30.52	30.598	9900.0
2020-01-08	ADRE	ETF	44.79	45.14	44.79	44.97	8752.0
2020-01-08	AESR	ETF	10.16	10.16	10.137	10.137	3400.0
2020-01-08	AFIF	ETF	9.7237	9.735	9.7237	9.735	50514.0
2020-01-08	AFK	ETF	20.11	20.4399	20.11	20.35	24619.0
2020-01-08	AFLG	ETF	20.485	20.485	20.485	20.485	100.0
2020-01-08	AFTY	ETF	17.567	17.611	17.567	17.568	1300.0
2020-01-08	AGG	ETF	112.85	112.94	112.55	112.67	7323100.0
2020-01-08	AGGY	ETF	52.46	52.469	52.306	52.38	169800.0
2020-01-08	AGNG	ETF	23.51	23.823	23.51	23.763	2200.0
2020-01-08	AGQ	ETF	33.46	33.5	32.25	32.48	634200.0
2020-01-08	AGZ	ETF	116.07	116.07	115.7342	115.87	13061.0
2020-01-08	AGZD	ETF	24.035	24.08	24.03	24.06	8200.0
2020-01-08	AIA	ETF	66.4	67.08	66.29	66.83	120135.0
2020-01-08	AIEQ	ETF	28.79	29.045	28.79	28.96	48800.0
2020-01-08	AIQ	ETF	18.36	18.5	18.3163	18.43	9070.0
2020-01-08	AIRR	ETF	28.95	29.04	28.92	28.945	5900.0
2020-01-08	AIVI	ETF	42.59	42.78	42.59	42.71	2700.0
2020-01-08	ALTY	ETF	14.87	14.894	14.8	14.85	21200.0
2020-01-08	AMJ	ETF	22.65	22.78	22.31	22.47	3726820.0
2020-01-08	AMLP	ETF	44.2	44.5	43.6	44.05	7765360.0
2020-01-08	AMOM	ETF	26.163	26.163	26.163	26.163	100.0
2020-01-08	AMUB	ETF	14.1469	14.1469	14.1469	14.1469	0.0
2020-01-08	AMZA	ETF	47.0	47.3	46.0	46.3	65460.0
2020-01-08	ANGL	ETF	29.95	29.95	29.87	29.95	213200.0
2020-01-08	AOA	ETF	58.06	58.37	58.05	58.23	65500.0
2020-01-08	AOK	ETF	36.34	36.3801	36.3214	36.3222	70217.0
2020-01-08	AOM	ETF	40.22	40.3	40.17	40.2	1084472.0
2020-01-08	AOR	ETF	47.93	48.0483	47.8819	47.92	96838.0
2020-01-08	ARCM	ETF	100.035	100.035	100.035	100.035	100.0
2020-01-08	ARGT	ETF	26.43	26.74	26.38	26.6	51600.0
2020-01-08	ARKF	ETF	24.62	24.98	24.62	24.88	25000.0
2020-01-08	ARKG	ETF	33.315	34.02	33.28	33.83	149500.0

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

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