PREVIEW / etf_daily / 2020-06-08

all etf daily files

  file:    by_date/etf_daily/2020/2020-06-08.parquet
  size:    77 KB
  rows:    2,031

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-08	SPY	ETF	320.22	323.41	319.63	323.2	73641200.0
2020-06-08	QQQ	ETF	239.54	241.68	237.91	241.55	32937305.0
2020-06-08	IWM	ETF	152.35	153.39	151.63	153.09	33834300.0
2020-06-08	DIA	ETF	272.9	276.38	272.9	276.28	4667600.0
2020-06-08	GLD	ETF	158.9	159.86	158.47	159.72	9244400.0
2020-06-08	TLT	ETF	155.07	156.85	155.05	156.71	10346700.0
2020-06-08	AAAU	ETF	16.85	16.95	16.81	16.95	386900.0
2020-06-08	AADR	ETF	50.46	50.46	50.04	50.3	8400.0
2020-06-08	AAXJ	ETF	69.66	70.03	69.22	70.02	1180900.0
2020-06-08	ABEQ	ETF	23.44	23.44	21.1	23.36	1500.0
2020-06-08	ACES	ETF	39.8	39.84	39.297	39.82	26200.0
2020-06-08	ACIO	ETF	24.98	24.99	24.903	24.966	27200.0
2020-06-08	ACSI	ETF	35.8725	35.8725	35.8725	35.8725	228.0
2020-06-08	ACTX	ETF	4.248	4.7761	4.248	4.425	132.0
2020-06-08	ACWF	ETF	29.04	29.29	29.014	29.29	3012.0
2020-06-08	ACWI	ETF	76.76	77.38	76.44	77.34	1745700.0
2020-06-08	ACWV	ETF	91.07	91.59	90.74	91.58	388900.0
2020-06-08	ACWX	ETF	45.08	45.47	44.86	45.47	1487496.0
2020-06-08	ADME	ETF	32.183	32.46	32.183	32.46	38300.0
2020-06-08	ADRE	ETF	40.66	40.66	40.1501	40.6037	3406.0
2020-06-08	AESR	ETF	10.01	10.125	10.0	10.125	17900.0
2020-06-08	AFIF	ETF	9.81	9.83	9.801	9.801	25314.0
2020-06-08	AFK	ETF	16.51	16.84	16.51	16.72	15999.0
2020-06-08	AFLG	ETF	19.54	19.647	19.54	19.647	100.0
2020-06-08	AFMC	ETF	18.35	18.413	18.35	18.413	100.0
2020-06-08	AFSM	ETF	17.84	17.93	17.84	17.93	300.0
2020-06-08	AFTY	ETF	16.55	16.649	16.55	16.649	700.0
2020-06-08	AGG	ETF	116.81	117.11	116.75	117.03	8551800.0
2020-06-08	AGGY	ETF	53.28	53.43	53.26	53.43	386400.0
2020-06-08	AGNG	ETF	24.889	25.0	24.72	24.91	4600.0
2020-06-08	AGQ	ETF	27.51	28.2	27.26	28.14	314200.0
2020-06-08	AGZ	ETF	120.3	120.3584	120.0	120.1	52419.0
2020-06-08	AGZD	ETF	23.505	23.525	23.475	23.525	20000.0
2020-06-08	AIA	ETF	64.19	64.6299	63.884	64.51	63831.0
2020-06-08	AIEQ	ETF	27.6	27.97	27.56	27.97	30200.0
2020-06-08	AIQ	ETF	20.15	20.36	20.137	20.36	19013.0
2020-06-08	AIRR	ETF	26.56	26.66	26.26	26.288	14700.0
2020-06-08	AIVI	ETF	37.4	37.71	37.36	37.71	6400.0
2020-06-08	ALTY	ETF	12.13	12.29	12.073	12.29	14600.0
2020-06-08	AMJ	ETF	16.94	17.08	16.65	17.03	1671358.0
2020-06-08	AMLP	ETF	31.67	31.78	30.93	31.7	3149300.0
2020-06-08	AMOM	ETF	28.56	28.79	28.49	28.79	700.0
2020-06-08	AMUB	ETF	10.71	10.72	10.49	10.7114	42981.0
2020-06-08	AMZA	ETF	25.12	25.4	24.25	24.99	103100.0
2020-06-08	ANGL	ETF	29.22	29.27	29.09	29.21	1489200.0
2020-06-08	AOA	ETF	56.31	56.72	56.16	56.68	63300.0
2020-06-08	AOK	ETF	36.59	36.73	36.53	36.73	274076.0
2020-06-08	AOM	ETF	40.25	40.495	40.24	40.49	387005.0
2020-06-08	AOR	ETF	47.17	47.5	47.17	47.5	180220.0
2020-06-08	APRT	ETF	25.72	25.72	25.6939	25.6939	587.0

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

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