PREVIEW / etf_daily / 2020-06-16

all etf daily files

  file:    by_date/etf_daily/2020/2020-06-16.parquet
  size:    76 KB
  rows:    2,023

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-06-16	SPY	ETF	315.48	315.64	307.67	312.96	137627500.0
2020-06-16	QQQ	ETF	243.78	244.39	239.1	242.85	48890095.0
2020-06-16	IWM	ETF	146.69	146.69	141.03	144.38	48957000.0
2020-06-16	DIA	ETF	267.09	267.14	258.69	263.82	9238000.0
2020-06-16	GLD	ETF	161.85	162.69	161.36	162.25	7964000.0
2020-06-16	TLT	ETF	159.41	161.23	158.7	159.9	13698900.0
2020-06-16	AAAU	ETF	17.15	17.25	17.11	17.21	165800.0
2020-06-16	AADR	ETF	51.7	51.7	50.46	50.56	4400.0
2020-06-16	AAXJ	ETF	69.02	69.06	67.59	68.14	1517500.0
2020-06-16	ABEQ	ETF	22.46	22.55	22.41	22.421	15200.0
2020-06-16	ACES	ETF	39.8	39.8	38.4	38.75	42200.0
2020-06-16	ACIO	ETF	25.31	25.31	25.108	25.17	9700.0
2020-06-16	ACSI	ETF	34.24	34.24	33.9015	33.9015	320.0
2020-06-16	ACTX	ETF	4.248	4.248	4.1153	4.248	408.0
2020-06-16	ACWF	ETF	28.11	28.12	27.74	27.8	9022.0
2020-06-16	ACWI	ETF	74.94	74.94	73.2	74.28	2931700.0
2020-06-16	ACWV	ETF	89.38	89.4	87.62	88.26	237400.0
2020-06-16	ACWX	ETF	43.76	43.83	42.93	43.37	1324618.0
2020-06-16	ADME	ETF	32.19	32.25	31.95	32.004	11800.0
2020-06-16	ADRE	ETF	40.24	40.25	39.63	39.63	3287.0
2020-06-16	AESR	ETF	9.95	9.99	9.828	9.926	6300.0
2020-06-16	AFIF	ETF	9.785	9.7898	9.7698	9.775	11394.0
2020-06-16	AFK	ETF	16.64	16.65	16.2701	16.28	8523.0
2020-06-16	AFLG	ETF	19.16	19.16	18.95	18.96	5100.0
2020-06-16	AFMC	ETF	17.41	17.45	17.33	17.33	400.0
2020-06-16	AFSM	ETF	17.33	17.33	17.029	17.029	300.0
2020-06-16	AFTY	ETF	16.412	16.412	16.246	16.246	500.0
2020-06-16	AGG	ETF	117.98	118.0	117.59	117.74	5327400.0
2020-06-16	AGGY	ETF	53.74	53.74	53.565	53.68	156100.0
2020-06-16	AGNG	ETF	24.48	24.557	24.428	24.428	3100.0
2020-06-16	AGQ	ETF	26.75	27.41	26.74	26.96	289600.0
2020-06-16	AGZ	ETF	120.73	120.99	120.5638	120.63	1041290.0
2020-06-16	AGZD	ETF	23.57	23.57	23.475	23.52	5400.0
2020-06-16	AIA	ETF	63.95	64.13	62.89	63.26	56982.0
2020-06-16	AIEQ	ETF	27.95	27.95	27.561	27.699	55400.0
2020-06-16	AIQ	ETF	20.5	20.5	20.2	20.3008	17860.0
2020-06-16	AIRR	ETF	24.43	24.759	24.26	24.311	23000.0
2020-06-16	AIVI	ETF	36.42	36.42	36.0	36.1	4500.0
2020-06-16	ALTY	ETF	11.76	11.89	11.33	11.445	25200.0
2020-06-16	AMJ	ETF	16.09	16.09	15.02	15.17	3768827.0
2020-06-16	AMLP	ETF	29.45	29.73	28.01	28.22	9561900.0
2020-06-16	AMOM	ETF	29.144	29.19	29.008	29.008	600.0
2020-06-16	AMUB	ETF	10.01	10.01	9.5	9.53	56254.0
2020-06-16	AMZA	ETF	22.39	22.52	21.05	21.44	110400.0
2020-06-16	ANGL	ETF	29.1	29.32	28.91	29.06	1233300.0
2020-06-16	AOA	ETF	55.43	55.55	54.62	55.11	89000.0
2020-06-16	AOK	ETF	36.53	36.53	36.275	36.38	104093.0
2020-06-16	AOM	ETF	40.17	40.31	39.777	39.89	127814.0
2020-06-16	AOR	ETF	46.73	46.835	46.13	46.59	154422.0
2020-06-16	APRT	ETF	25.16	25.16	25.0095	25.0095	300.0

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

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