PREVIEW / etf_daily / 2020-06-01

all etf daily files

  file:    by_date/etf_daily/2020/2020-06-01.parquet
  size:    75 KB
  rows:    1,999

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-01	SPY	ETF	303.62	306.21	303.06	305.55	55758300.0
2020-06-01	QQQ	ETF	232.4	234.45	232.0	234.06	26140125.0
2020-06-01	IWM	ETF	139.26	141.67	138.61	140.23	25567500.0
2020-06-01	DIA	ETF	253.78	255.55	252.7	255.27	2060800.0
2020-06-01	GLD	ETF	162.92	163.74	162.39	163.66	8140200.0
2020-06-01	TLT	ETF	162.1	162.44	161.67	162.28	13341400.0
2020-06-01	AAAU	ETF	17.3	17.37	17.24	17.37	388700.0
2020-06-01	AADR	ETF	48.68	50.0	48.68	49.84	11000.0
2020-06-01	AAXJ	ETF	65.28	66.16	65.22	66.09	795600.0
2020-06-01	ABEQ	ETF	22.44	22.458	22.44	22.458	700.0
2020-06-01	ACES	ETF	36.28	37.84	36.16	36.95	30100.0
2020-06-01	ACIO	ETF	24.557	24.705	24.557	24.7	8200.0
2020-06-01	ACSI	ETF	32.85	32.8807	32.85	32.8807	1013.0
2020-06-01	ACTX	ETF	4.3011	4.9796	4.248	4.2834	1357.0
2020-06-01	ACWF	ETF	27.77	27.8744	27.77	27.8739	26420.0
2020-06-01	ACWI	ETF	72.46	73.16	72.32	73.14	2545000.0
2020-06-01	ACWV	ETF	88.91	89.51	88.61	89.32	194200.0
2020-06-01	ACWX	ETF	42.29	42.82	42.2006	42.82	2478768.0
2020-06-01	ADME	ETF	31.867	31.98	31.867	31.93	5900.0
2020-06-01	ADRE	ETF	36.97	37.36	36.91	37.36	2740.0
2020-06-01	AESR	ETF	9.71	9.75	9.695	9.726	11300.0
2020-06-01	AFIF	ETF	9.84	9.84	9.8	9.8225	174843.0
2020-06-01	AFK	ETF	15.27	15.66	15.27	15.64	13378.0
2020-06-01	AFLG	ETF	18.74	18.74	18.74	18.74	100.0
2020-06-01	AFSM	ETF	16.606	16.606	16.606	16.606	100.0
2020-06-01	AFTY	ETF	15.82	16.11	15.82	16.096	3300.0
2020-06-01	AGG	ETF	117.35	117.4	117.24	117.37	5580000.0
2020-06-01	AGGY	ETF	53.5	53.5	53.22	53.49	181900.0
2020-06-01	AGNG	ETF	24.375	24.375	24.353	24.353	300.0
2020-06-01	AGQ	ETF	30.15	31.12	30.08	31.1	759900.0
2020-06-01	AGZ	ETF	121.03	121.03	120.7998	121.0	68328.0
2020-06-01	AGZD	ETF	23.4	23.4	23.32	23.345	85800.0
2020-06-01	AIA	ETF	59.93	60.81	59.93	60.76	57087.0
2020-06-01	AIEQ	ETF	27.59	27.74	27.456	27.61	15300.0
2020-06-01	AIQ	ETF	19.58	19.73	19.458	19.66	19744.0
2020-06-01	AIRR	ETF	23.172	23.45	23.12	23.189	7700.0
2020-06-01	AIVI	ETF	34.92	35.48	34.92	35.48	5900.0
2020-06-01	ALTY	ETF	10.78	10.97	10.77	10.945	9600.0
2020-06-01	AMJ	ETF	14.44	14.62	14.31	14.36	1347602.0
2020-06-01	AMLP	ETF	26.83	27.19	26.59	26.71	1762900.0
2020-06-01	AMOM	ETF	28.571	28.571	28.571	28.571	100.0
2020-06-01	AMUB	ETF	9.16	9.16	9.02	9.0307	11335.0
2020-06-01	AMZA	ETF	20.32	20.81	20.1	20.34	57300.0
2020-06-01	ANGL	ETF	28.18	28.38	27.79	28.06	2069400.0
2020-06-01	AOA	ETF	53.51	54.08	53.51	53.96	68400.0
2020-06-01	AOK	ETF	35.92	36.08	35.92	35.96	127273.0
2020-06-01	AOM	ETF	39.27	39.47	39.2334	39.41	355434.0
2020-06-01	AOR	ETF	45.44	45.78	45.4329	45.78	119970.0
2020-06-01	APRT	ETF	25.04	25.16	25.04	25.1248	99972.0
2020-06-01	APRW	ETF	25.0	25.13	25.0	25.085	99623.0

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

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