PREVIEW / etf_daily / 2020-10-15

all etf daily files

  file:    by_date/etf_daily/2020/2020-10-15.parquet
  size:    80 KB
  rows:    2,110

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-10-15	SPY	ETF	343.71	348.02	343.13	347.5	60357700.0
2020-10-15	QQQ	ETF	287.25	290.71	286.54	290.1	42514177.0
2020-10-15	IWM	ETF	159.29	163.18	158.81	162.75	22865100.0
2020-10-15	DIA	ETF	282.03	285.4	281.66	285.04	3128000.0
2020-10-15	GLD	ETF	177.71	179.15	177.59	178.92	6815400.0
2020-10-15	TLT	ETF	163.04	163.19	161.64	161.84	9458800.0
2020-10-15	AAA	ETF	24.91	24.92	24.9	24.91	2160.0
2020-10-15	AAAU	ETF	18.84	19.01	18.84	18.99	461000.0
2020-10-15	AADR	ETF	56.93	57.78	56.93	57.5	5500.0
2020-10-15	AAXJ	ETF	78.81	79.44	78.64	79.3	1392600.0
2020-10-15	ABEQ	ETF	23.7	23.829	23.7	23.805	1600.0
2020-10-15	ACES	ETF	59.65	60.419	59.0	60.29	50800.0
2020-10-15	ACIO	ETF	26.87	27.2	26.87	27.15	14900.0
2020-10-15	ACSI	ETF	39.4566	39.4566	39.4566	39.4566	105.0
2020-10-15	ACTX	ETF	1.11	1.11	1.11	1.11	122.0
2020-10-15	ACWF	ETF	30.421	30.8063	30.421	30.8063	1019.0
2020-10-15	ACWI	ETF	81.6	82.49	81.55	82.4	7075900.0
2020-10-15	ACWV	ETF	92.84	93.55	92.84	93.47	191700.0
2020-10-15	ACWX	ETF	46.51	46.93	46.46	46.91	3266728.0
2020-10-15	ADME	ETF	34.11	34.69	34.11	34.646	7000.0
2020-10-15	ADRE	ETF	49.13	49.19	49.125	49.19	4011.0
2020-10-15	AESR	ETF	11.24	11.28	11.15	11.28	34500.0
2020-10-15	AFIF	ETF	9.75	9.82	9.75	9.8	18522.0
2020-10-15	AFK	ETF	17.9	18.04	17.79	18.03	4731.0
2020-10-15	AFLG	ETF	20.989	20.989	20.989	20.989	100.0
2020-10-15	AFSM	ETF	19.474	19.474	19.474	19.474	100.0
2020-10-15	AFTY	ETF	20.19	20.36	20.19	20.33	3500.0
2020-10-15	AGG	ETF	118.15	118.15	117.95	117.95	5459200.0
2020-10-15	AGGY	ETF	53.84	53.919	53.79	53.79	96300.0
2020-10-15	AGNG	ETF	26.078	26.12	26.03	26.09	2200.0
2020-10-15	AGQ	ETF	42.85	45.37	42.72	45.24	1701900.0
2020-10-15	AGZ	ETF	121.12	121.12	120.93	121.02	28973.0
2020-10-15	AGZD	ETF	23.395	23.5	23.395	23.48	9200.0
2020-10-15	AIA	ETF	73.91	74.46	73.82	74.4	86028.0
2020-10-15	AIEQ	ETF	32.2	32.61	31.94	32.54	8300.0
2020-10-15	AIQ	ETF	24.51	24.6191	24.33	24.6191	22552.0
2020-10-15	AIRR	ETF	27.4	27.983	27.4	27.983	6000.0
2020-10-15	AIVI	ETF	35.94	36.3	35.94	36.25	4500.0
2020-10-15	ALTL	ETF	25.62	25.7229	25.53	25.7062	2466.0
2020-10-15	ALTY	ETF	10.76	10.8	10.701	10.775	6900.0
2020-10-15	AMJ	ETF	11.82	12.055	11.63	11.96	706397.0
2020-10-15	AMLP	ETF	21.89	22.35	21.54	22.25	2069100.0
2020-10-15	AMNA	ETF	22.47	22.63	22.47	22.614	600.0
2020-10-15	AMND	ETF	23.8043	23.8043	23.8043	23.8043	4.0
2020-10-15	AMOM	ETF	36.47	37.036	36.47	37.036	1500.0
2020-10-15	AMUB	ETF	7.57	7.57	7.54	7.546	480.0
2020-10-15	AMZA	ETF	15.06	15.43	14.81	15.35	52100.0
2020-10-15	ANGL	ETF	29.96	30.1	29.91	30.06	539500.0
2020-10-15	AOA	ETF	58.66	59.35	58.66	59.23	37900.0
2020-10-15	AOK	ETF	37.7	37.7	37.41	37.58	108320.0

> showing 50 of 2,110 rows — these rows as CSV

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