PREVIEW / etf_daily / 2022-02-18

all etf daily files

  file:    by_date/etf_daily/2022/2022-02-18.parquet
  size:    100 KB
  rows:    2,670

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
2022-02-18	SPY	ETF	437.33	438.66	431.82	434.23	132642900.0
2022-02-18	QQQ	ETF	346.41	346.81	339.14	341.51	80001513.0
2022-02-18	IWM	ETF	201.03	202.72	198.76	199.47	36255400.0
2022-02-18	DIA	ETF	342.9	344.2	339.67	340.98	6193700.0
2022-02-18	GLD	ETF	177.07	177.25	176.51	177.12	12760700.0
2022-02-18	TLT	ETF	137.52	138.37	137.16	138.23	17522600.0
2022-02-18	AAA	ETF	25.005	25.005	25.005	25.005	762.0
2022-02-18	AAAU	ETF	18.85	18.86	18.79	18.86	252900.0
2022-02-18	AADR	ETF	61.62	61.62	60.98	61.11	9500.0
2022-02-18	AAXJ	ETF	81.73	81.82	81.11	81.33	781600.0
2022-02-18	ABEQ	ETF	28.719	28.77	28.644	28.708	3600.0
2022-02-18	ACES	ETF	51.86	52.335	50.715	51.0	50700.0
2022-02-18	ACIO	ETF	30.935	30.935	30.71	30.79	24100.0
2022-02-18	ACSI	ETF	48.63	48.7595	48.63	48.7595	100.0
2022-02-18	ACT	ETF	21.99	22.29	21.5	21.58	236771.0
2022-02-18	ACTV	ETF	35.1	35.37	34.96	35.15	6504.0
2022-02-18	ACTX	ETF	0.87	0.87	0.87	0.87	532.0
2022-02-18	ACVF	ETF	32.775	32.775	32.46	32.509	6100.0
2022-02-18	ACWF	ETF	36.87	36.93	36.6099	36.7143	8263.0
2022-02-18	ACWI	ETF	99.32	99.52	98.15	98.55	4274300.0
2022-02-18	ACWV	ETF	101.51	102.06	101.25	101.51	561200.0
2022-02-18	ACWX	ETF	54.18	54.28	53.7601	53.92	3655260.0
2022-02-18	ADFI	ETF	9.19	9.2	9.12	9.195	5300.0
2022-02-18	ADIV	ETF	16.484	16.484	16.459	16.459	1000.0
2022-02-18	ADME	ETF	40.43	40.43	40.105	40.13	15500.0
2022-02-18	ADRE	ETF	46.44	46.44	45.92	46.11	4548.0
2022-02-18	AEMB	ETF	45.895	45.895	45.826	45.826	200.0
2022-02-18	AESR	ETF	13.0	13.0	12.88	12.898	8300.0
2022-02-18	AFIF	ETF	9.4	9.4	9.3801	9.3851	18600.0
2022-02-18	AFK	ETF	21.48	21.48	21.14	21.15	11848.0
2022-02-18	AFLG	ETF	25.72	25.79	25.6	25.643	500.0
2022-02-18	AFMC	ETF	24.51	24.534	24.51	24.534	100.0
2022-02-18	AFSM	ETF	25.01	25.05	25.01	25.033	400.0
2022-02-18	AFTY	ETF	20.22	20.22	20.209	20.209	300.0
2022-02-18	AGG	ETF	109.83	109.88	109.71	109.87	7110900.0
2022-02-18	AGGH	ETF	26.31	26.31	25.1359	25.1359	894.0
2022-02-18	AGGY	ETF	49.22	49.258	49.16	49.205	95900.0
2022-02-18	AGNG	ETF	26.48	26.48	26.26	26.295	700.0
2022-02-18	AGOV	ETF	96.0801	96.0801	95.9952	95.9952	355.0
2022-02-18	AGOX	ETF	23.45	23.695	23.409	23.41	82200.0
2022-02-18	AGQ	ETF	36.2	36.57	35.96	36.1	1211400.0
2022-02-18	AGZ	ETF	114.84	114.92	114.7436	114.92	16469.0
2022-02-18	AGZD	ETF	23.165	23.165	23.105	23.14	31600.0
2022-02-18	AHHX	ETF	9.65	9.75	9.64	9.6897	14399.0
2022-02-18	AHYB	ETF	47.97	47.97	47.93	47.93	600.0
2022-02-18	AIA	ETF	76.68	76.68	75.833	76.12	80985.0
2022-02-18	AIEQ	ETF	36.0	36.078	35.48	35.64	33200.0
2022-02-18	AIQ	ETF	27.11	27.11	26.56	26.697	18433.0
2022-02-18	AIRR	ETF	41.86	42.15	41.76	41.85	34000.0
2022-02-18	AIVI	ETF	42.46	42.63	42.4	42.45	1800.0

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

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