PREVIEW / etf_daily / 2021-06-18

all etf daily files

  file:    by_date/etf_daily/2021/2021-06-18.parquet
  size:    90 KB
  rows:    2,377

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
2021-06-18	SPY	ETF	417.09	417.83	414.7	414.92	118676300.0
2021-06-18	QQQ	ETF	343.63	344.8082	341.86	342.63	55414862.0
2021-06-18	IWM	ETF	223.7	225.74	221.13	222.13	54023700.0
2021-06-18	DIA	ETF	334.35	335.25	332.68	332.96	7126600.0
2021-06-18	GLD	ETF	166.14	166.72	164.87	164.93	15744300.0
2021-06-18	TLT	ETF	144.28	146.04	144.12	145.73	26616900.0
2021-06-18	AAA	ETF	25.03	25.04	25.03	25.04	1190.0
2021-06-18	AAAU	ETF	17.65	17.71	17.54	17.54	379700.0
2021-06-18	AADR	ETF	64.61	65.07	58.48	64.35	4400.0
2021-06-18	AAXJ	ETF	93.2	93.25	92.74	92.9	1116300.0
2021-06-18	ABEQ	ETF	27.23	27.26	27.144	27.144	22900.0
2021-06-18	ACES	ETF	71.66	72.47	70.98	71.53	185300.0
2021-06-18	ACIO	ETF	29.64	29.64	29.56	29.58	63200.0
2021-06-18	ACSI	ETF	48.25	48.25	48.25	48.25	2176.0
2021-06-18	ACTV	ETF	39.03	39.03	38.04	38.1111	4406.0
2021-06-18	ACTX	ETF	2.75	2.75	2.75	2.75	526.0
2021-06-18	ACVF	ETF	31.31	31.31	31.0	31.171	10000.0
2021-06-18	ACWF	ETF	37.17	37.18	37.06	37.08	4167.0
2021-06-18	ACWI	ETF	99.43	99.58	99.03	99.07	3506400.0
2021-06-18	ACWV	ETF	101.67	101.99	101.31	101.38	284900.0
2021-06-18	ACWX	ETF	57.18	57.255	56.92	56.95	1021069.0
2021-06-18	ADFI	ETF	9.74	9.755	9.71	9.755	4500.0
2021-06-18	ADIV	ETF	18.67	18.67	18.67	18.67	100.0
2021-06-18	ADME	ETF	38.926	38.926	38.81	38.82	72700.0
2021-06-18	ADRE	ETF	56.36	56.36	55.67	55.95	16488.0
2021-06-18	AESR	ETF	13.2	13.22	13.17	13.182	66100.0
2021-06-18	AFIF	ETF	9.7398	9.74	9.71	9.7284	20325.0
2021-06-18	AFK	ETF	22.0	22.0	21.69	21.69	77651.0
2021-06-18	AFLG	ETF	24.72	24.72	24.67	24.67	800.0
2021-06-18	AFMC	ETF	24.479	24.479	24.479	24.479	1500.0
2021-06-18	AFSM	ETF	25.454	25.454	25.454	25.454	800.0
2021-06-18	AFTY	ETF	22.79	22.79	22.65	22.703	3300.0
2021-06-18	AGG	ETF	115.05	115.39	114.91	115.29	5690400.0
2021-06-18	AGGY	ETF	52.14	52.3	52.1	52.27	109000.0
2021-06-18	AGNG	ETF	30.266	30.266	30.15	30.18	2100.0
2021-06-18	AGOX	ETF	25.25	25.595	25.25	25.437	17100.0
2021-06-18	AGQ	ETF	45.59	46.06	44.78	44.79	1051300.0
2021-06-18	AGZ	ETF	118.27	118.3757	118.0941	118.37	27298.0
2021-06-18	AGZD	ETF	23.56	23.6	23.495	23.505	22400.0
2021-06-18	AIA	ETF	90.34	90.34	89.73	89.73	98066.0
2021-06-18	AIEQ	ETF	40.18	40.29	39.955	40.12	32200.0
2021-06-18	AIQ	ETF	29.68	29.8	29.52	29.61	15688.0
2021-06-18	AIRR	ETF	39.49	40.045	39.28	39.38	58200.0
2021-06-18	AIVI	ETF	43.58	43.58	43.44	43.44	7500.0
2021-06-18	ALTL	ETF	41.13	41.6799	40.58	40.58	26961.0
2021-06-18	ALTY	ETF	13.57	13.59	13.45	13.47	34000.0
2021-06-18	AMJ	ETF	19.6	19.93	19.42	19.42	953642.0
2021-06-18	AMLP	ETF	36.44	36.77	35.8	35.82	3985500.0
2021-06-18	AMNA	ETF	33.775	33.775	33.775	33.775	8.0
2021-06-18	AMND	ETF	35.89	35.9	35.88	35.88	1000.0

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

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