PREVIEW / etf_daily / 2020-04-24

all etf daily files

  file:    by_date/etf_daily/2020/2020-04-24.parquet
  size:    74 KB
  rows:    1,942

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-04-24	SPY	ETF	280.73	283.7	278.5	282.97	85063200.0
2020-04-24	QQQ	ETF	210.94	214.3	209.5	213.84	34303365.0
2020-04-24	IWM	ETF	121.53	123.32	120.09	122.41	27147500.0
2020-04-24	DIA	ETF	236.61	238.33	234.2	237.83	3568500.0
2020-04-24	GLD	ETF	163.13	163.31	160.89	162.64	11199300.0
2020-04-24	TLT	ETF	169.61	170.84	169.57	170.84	6211800.0
2020-04-24	AAAU	ETF	17.3	17.32	17.06	17.23	399900.0
2020-04-24	AADR	ETF	45.35	45.35	44.41	45.01	7100.0
2020-04-24	AAXJ	ETF	62.81	62.81	62.22	62.75	652500.0
2020-04-24	ABEQ	ETF	21.669	21.713	21.574	21.713	3800.0
2020-04-24	ACES	ETF	31.75	32.1	31.261	31.57	16600.0
2020-04-24	ACIO	ETF	23.79	23.892	23.79	23.892	9200.0
2020-04-24	ACSI	ETF	30.1456	30.1456	30.1456	30.1456	100.0
2020-04-24	ACTX	ETF	5.31	5.31	3.8645	4.72	1031.0
2020-04-24	ACWF	ETF	25.51	25.7977	25.4	25.785	2087.0
2020-04-24	ACWI	ETF	66.62	67.06	66.03	66.9	4069900.0
2020-04-24	ACWV	ETF	85.85	86.11	85.1	85.85	685600.0
2020-04-24	ACWX	ETF	38.97	39.02	38.58	39.01	5955829.0
2020-04-24	ADME	ETF	29.831	30.0	29.83	29.87	9500.0
2020-04-24	ADRE	ETF	35.33	35.33	34.8475	35.08	7878.0
2020-04-24	AESR	ETF	8.95	9.09	8.95	9.088	105600.0
2020-04-24	AFIF	ETF	9.821	9.821	9.75	9.78	616278.0
2020-04-24	AFK	ETF	14.0375	14.485	14.0375	14.45	8076.0
2020-04-24	AFLG	ETF	17.02	17.236	17.02	17.236	300.0
2020-04-24	AFTY	ETF	15.49	15.509	15.49	15.5	500.0
2020-04-24	AGG	ETF	117.22	117.39	117.2	117.36	3161600.0
2020-04-24	AGGY	ETF	53.14	53.19	53.04	53.18	176000.0
2020-04-24	AGNG	ETF	22.57	22.75	22.34	22.66	24500.0
2020-04-24	AGQ	ETF	21.7	21.76	20.7	21.28	364000.0
2020-04-24	AGZ	ETF	120.42	120.69	120.42	120.5	51477.0
2020-04-24	AGZD	ETF	23.18	23.715	23.145	23.18	16200.0
2020-04-24	AIA	ETF	58.32	58.44	58.01	58.36	38752.0
2020-04-24	AIEQ	ETF	25.22	25.629	25.184	25.49	7100.0
2020-04-24	AIQ	ETF	17.18	17.42	17.0435	17.42	15752.0
2020-04-24	AIRR	ETF	20.4	20.596	20.07	20.46	8800.0
2020-04-24	AIVI	ETF	32.3	32.44	32.12	32.37	5400.0
2020-04-24	ALTY	ETF	9.46	9.51	9.353	9.51	2500.0
2020-04-24	AMJ	ETF	12.6	12.87	12.14	12.28	2240100.0
2020-04-24	AMLP	ETF	23.75	24.25	22.8	23.2	5136060.0
2020-04-24	AMUB	ETF	7.88	8.02	7.64	7.726	65785.0
2020-04-24	AMZA	ETF	16.12	16.48	15.28	15.582	122500.0
2020-04-24	ANGL	ETF	26.82	26.94	26.52	26.65	842600.0
2020-04-24	AOA	ETF	50.05	50.42	49.68	50.22	92500.0
2020-04-24	AOK	ETF	34.89	34.9399	34.76	34.92	70745.0
2020-04-24	AOM	ETF	37.73	37.91	37.61	37.88	206110.0
2020-04-24	AOR	ETF	43.07	43.3348	42.89	43.25	445918.0
2020-04-24	ARCM	ETF	100.6	100.6	99.99	99.99	800.0
2020-04-24	ARGT	ETF	17.25	17.27	16.75	16.89	17300.0
2020-04-24	ARKF	ETF	23.22	23.47	23.1	23.42	31900.0
2020-04-24	ARKG	ETF	39.62	40.27	39.01	40.06	451200.0

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

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