PREVIEW / etf_daily / 2020-03-16

all etf daily files

  file:    by_date/etf_daily/2020/2020-03-16.parquet
  size:    75 KB
  rows:    1,983

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-03-16	SPY	ETF	241.18	256.9	237.36	239.85	297240000.0
2020-03-16	QQQ	ETF	174.15	184.68	169.16	169.3	92054386.0
2020-03-16	IWM	ETF	108.62	111.3	101.43	103.62	59095700.0
2020-03-16	DIA	ETF	206.5	218.31	201.51	202.49	12407000.0
2020-03-16	GLD	ETF	137.56	142.96	136.12	141.64	24496000.0
2020-03-16	TLT	ETF	160.38	166.15	157.81	163.91	30496700.0
2020-03-16	AAAU	ETF	14.59	15.14	14.49	15.04	412100.0
2020-03-16	AADR	ETF	36.14	38.88	35.91	37.9	32500.0
2020-03-16	AAXJ	ETF	55.59	58.07	53.89	55.41	1835700.0
2020-03-16	ABEQ	ETF	19.96	20.76	19.316	19.323	14200.0
2020-03-16	ACES	ETF	28.8	28.8	26.0	26.25	58600.0
2020-03-16	ACIO	ETF	24.15	27.06	22.92	23.99	38500.0
2020-03-16	ACSI	ETF	26.95	27.04	26.0148	26.0148	1208.0
2020-03-16	ACTX	ETF	5.9001	6.0476	4.13	4.5843	1065.0
2020-03-16	ACWF	ETF	22.33	23.51	22.2495	22.2495	11910.0
2020-03-16	ACWI	ETF	53.8	60.34	53.8	56.84	6968800.0
2020-03-16	ACWV	ETF	72.57	79.28	71.89	75.51	806200.0
2020-03-16	ACWX	ETF	33.63	35.2934	32.9571	33.75	2439503.0
2020-03-16	ADME	ETF	27.738	28.459	27.22	27.77	33000.0
2020-03-16	ADRE	ETF	32.47	33.3	29.43	31.8489	26185.0
2020-03-16	AESR	ETF	8.01	8.01	7.601	7.601	1800.0
2020-03-16	AFIF	ETF	9.91	10.0382	9.91	10.0382	36833.0
2020-03-16	AFK	ETF	13.5	13.5	12.0	12.46	49626.0
2020-03-16	AFLG	ETF	15.28	15.75	14.791	14.791	7400.0
2020-03-16	AFMC	ETF	13.675	13.95	13.323	13.323	3700.0
2020-03-16	AFSM	ETF	13.34	13.36	12.597	12.597	3100.0
2020-03-16	AFTY	ETF	14.45	14.89	14.31	14.58	9700.0
2020-03-16	AGG	ETF	111.37	113.95	110.46	113.73	12310300.0
2020-03-16	AGGY	ETF	49.28	50.0	49.21	49.91	584000.0
2020-03-16	AGNG	ETF	18.5	18.7	17.912	17.912	3900.0
2020-03-16	AGQ	ETF	14.95	16.67	14.0	15.36	942900.0
2020-03-16	AGZ	ETF	120.61	123.1	120.04	120.76	133901.0
2020-03-16	AGZD	ETF	22.59	23.5	22.235	23.33	270400.0
2020-03-16	AIA	ETF	46.01	53.24	46.01	51.48	126865.0
2020-03-16	AIEQ	ETF	20.39	21.99	20.23	20.46	48600.0
2020-03-16	AIQ	ETF	12.89	14.15	12.75	13.94	82499.0
2020-03-16	AIRR	ETF	18.19	19.465	18.19	18.19	38400.0
2020-03-16	AIVI	ETF	28.31	29.27	27.75	28.36	51100.0
2020-03-16	ALTY	ETF	10.11	10.77	9.28	9.28	52600.0
2020-03-16	AMJ	ETF	9.28	9.77	8.8201	9.1	5475710.0
2020-03-16	AMLP	ETF	18.3	19.1	17.3	17.9	8680860.0
2020-03-16	AMOM	ETF	20.365	20.365	20.365	20.365	200.0
2020-03-16	AMUB	ETF	5.77	6.04	5.64	5.7857	12413.0
2020-03-16	AMZA	ETF	13.5	14.0	12.4	12.8	210930.0
2020-03-16	ANGL	ETF	25.94	26.16	23.5	25.05	1116300.0
2020-03-16	AOA	ETF	44.95	46.22	43.1	45.08	259800.0
2020-03-16	AOK	ETF	32.65	33.12	31.51	32.81	636957.0
2020-03-16	AOM	ETF	34.93	35.69	33.82	35.06	361653.0
2020-03-16	AOR	ETF	38.93	40.32	37.83	39.22	627251.0
2020-03-16	ARGT	ETF	16.69	17.01	16.22	16.45	85800.0

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

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