PREVIEW / etf_daily / 2019-12-30

all etf daily files

  file:    by_date/etf_daily/2019/2019-12-30.parquet
  size:    73 KB
  rows:    1,936

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
2019-12-30	SPY	ETF	322.95	323.1	320.55	321.08	49729100.0
2019-12-30	QQQ	ETF	213.51	213.63	211.16	212.21	21829913.0
2019-12-30	IWM	ETF	165.98	166.21	164.57	165.44	14912700.0
2019-12-30	DIA	ETF	286.34	286.41	284.12	284.53	2552900.0
2019-12-30	GLD	ETF	142.56	142.8	142.46	142.63	4810600.0
2019-12-30	TLT	ETF	135.89	136.9	135.66	136.82	7979700.0
2019-12-30	AAAU	ETF	15.11	15.13	15.11	15.11	93400.0
2019-12-30	AADR	ETF	54.54	54.54	54.1	54.1	4000.0
2019-12-30	AAXJ	ETF	73.86	73.86	73.17	73.26	517600.0
2019-12-30	ACES	ETF	34.03	34.03	33.5	33.714	21700.0
2019-12-30	ACIO	ETF	25.6	25.6	25.55	25.57	13500.0
2019-12-30	ACSI	ETF	35.71	35.72	35.31	35.3481	1118.0
2019-12-30	ACTX	ETF	11.6467	12.3931	11.6467	11.806	481.0
2019-12-30	ACWF	ETF	31.24	31.28	31.1	31.16	20024.0
2019-12-30	ACWI	ETF	79.63	79.63	78.97	79.07	1798500.0
2019-12-30	ACWV	ETF	95.96	96.16	95.62	95.74	192400.0
2019-12-30	ACWX	ETF	49.34	49.3602	48.9	48.92	2573984.0
2019-12-30	ADME	ETF	30.61	30.63	30.515	30.59	11200.0
2019-12-30	ADRE	ETF	44.61	44.61	44.34	44.385	56641.0
2019-12-30	AESR	ETF	10.96	10.96	10.081	10.158	2100.0
2019-12-30	AFIF	ETF	9.93	9.93	9.6957	9.715	4938.0
2019-12-30	AFK	ETF	20.38	20.525	20.07	20.24	37361.0
2019-12-30	AFSM	ETF	20.479	20.479	20.479	20.479	100.0
2019-12-30	AFTY	ETF	17.385	17.385	17.25	17.265	8100.0
2019-12-30	AGG	ETF	112.42	112.65	112.34	112.63	3979100.0
2019-12-30	AGGY	ETF	52.21	52.32	52.19	52.32	226600.0
2019-12-30	AGNG	ETF	23.73	23.73	23.45	23.643	4300.0
2019-12-30	AGQ	ETF	31.71	32.03	31.65	31.88	398700.0
2019-12-30	AGZ	ETF	115.59	115.722	115.5	115.7153	11024.0
2019-12-30	AGZD	ETF	24.05	24.08	24.045	24.075	13400.0
2019-12-30	AIA	ETF	66.35	66.35	65.7738	65.7738	20293.0
2019-12-30	AIEQ	ETF	28.65	28.65	28.36	28.37	49600.0
2019-12-30	AIQ	ETF	18.1	18.1	17.7912	17.8386	11483.0
2019-12-30	AIRR	ETF	28.96	29.19	28.9	29.07	15900.0
2019-12-30	AIVI	ETF	42.8	42.8	42.48	42.48	13200.0
2019-12-30	ALTY	ETF	15.01	15.01	14.745	14.76	16300.0
2019-12-30	AMJ	ETF	21.99	22.04	21.6	21.63	3005170.0
2019-12-30	AMLP	ETF	42.9	43.1	42.15	42.2	6234060.0
2019-12-30	AMOM	ETF	25.912	25.912	25.912	25.912	100.0
2019-12-30	AMUB	ETF	13.6256	13.6256	13.6256	13.6256	104.0
2019-12-30	AMZA	ETF	45.7	46.1	44.9	45.0	92410.0
2019-12-30	ANGL	ETF	29.86	29.89	29.7	29.81	289200.0
2019-12-30	AOA	ETF	58.19	58.19	57.8	57.8	78800.0
2019-12-30	AOK	ETF	36.28	36.28	36.17	36.26	78378.0
2019-12-30	AOM	ETF	40.16	40.2	40.04	40.04	97775.0
2019-12-30	AOR	ETF	47.9	47.95	47.69	47.69	211025.0
2019-12-30	ARGT	ETF	27.22	27.39	26.59	26.76	64700.0
2019-12-30	ARKF	ETF	24.22	24.22	23.87	23.87	22200.0
2019-12-30	ARKG	ETF	34.4	34.48	33.299	33.43	152000.0
2019-12-30	ARKK	ETF	51.06	51.16	49.58	49.74	307100.0

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

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