PREVIEW / etf_daily / 2022-03-22

all etf daily files

  file:    by_date/etf_daily/2022/2022-03-22.parquet
  size:    100 KB
  rows:    2,659

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-03-22	SPY	ETF	445.86	450.58	445.86	449.59	74650400.0
2022-03-22	QQQ	ETF	350.59	357.85	350.2	356.96	63345928.0
2022-03-22	IWM	ETF	206.31	208.79	205.8	207.5	24699900.0
2022-03-22	DIA	ETF	347.12	348.72	346.86	348.14	4430800.0
2022-03-22	GLD	ETF	179.6	179.71	178.32	179.36	9621800.0
2022-03-22	TLT	ETF	128.96	129.34	128.34	128.68	21830900.0
2022-03-22	AAA	ETF	24.84	24.84	24.84	24.84	56.0
2022-03-22	AAAU	ETF	19.13	19.13	18.99	19.1	372400.0
2022-03-22	AADR	ETF	59.71	59.74	59.65	59.72	1200.0
2022-03-22	AAXJ	ETF	75.98	76.65	75.93	76.36	1474100.0
2022-03-22	ABEQ	ETF	30.09	30.09	29.7	29.76	18400.0
2022-03-22	ACES	ETF	61.06	62.61	61.06	62.33	33600.0
2022-03-22	ACIO	ETF	31.16	31.7	31.16	31.37	38500.0
2022-03-22	ACSI	ETF	50.2959	50.2959	50.2959	50.2959	34.0
2022-03-22	ACT	ETF	22.47	23.12	22.33	22.5	106500.0
2022-03-22	ACTV	ETF	36.06	36.26	35.81	36.0195	17061.0
2022-03-22	ACTX	ETF	1.0	1.0	0.9999	1.0	1888.0
2022-03-22	ACVF	ETF	33.59	33.78	33.59	33.727	5700.0
2022-03-22	ACWF	ETF	37.08	37.31	37.08	37.226	7281.0
2022-03-22	ACWI	ETF	99.11	99.97	99.11	99.77	2323700.0
2022-03-22	ACWV	ETF	103.52	104.04	103.52	103.8	1030800.0
2022-03-22	ACWX	ETF	52.4	52.66	52.4	52.6	1343030.0
2022-03-22	ADFI	ETF	8.995	9.03	8.99	9.006	8000.0
2022-03-22	ADIV	ETF	15.63	15.68	15.63	15.68	1000.0
2022-03-22	ADME	ETF	40.96	40.96	40.775	40.89	33700.0
2022-03-22	ADRE	ETF	44.81	45.21	44.81	44.87	5595.0
2022-03-22	AEMB	ETF	42.43	42.43	42.43	42.43	100.0
2022-03-22	AESR	ETF	13.32	13.37	13.315	13.33	13700.0
2022-03-22	AFIF	ETF	9.21	9.22	9.2	9.215	21746.0
2022-03-22	AFK	ETF	21.44	21.44	21.21	21.37	11957.0
2022-03-22	AFLG	ETF	26.656	26.656	26.656	26.656	100.0
2022-03-22	AFMC	ETF	25.208	25.208	25.208	25.208	100.0
2022-03-22	AFSM	ETF	26.271	26.271	26.271	26.271	100.0
2022-03-22	AFTY	ETF	18.26	18.264	18.26	18.264	300.0
2022-03-22	AGG	ETF	106.74	106.88	106.61	106.75	16120500.0
2022-03-22	AGGY	ETF	47.77	47.85	47.73	47.79	1051400.0
2022-03-22	AGNG	ETF	28.02	28.07	28.019	28.041	3000.0
2022-03-22	AGOV	ETF	84.02	86.8	81.64	83.4901	7684.0
2022-03-22	AGOX	ETF	24.3	24.323	24.06	24.09	95100.0
2022-03-22	AGQ	ETF	38.73	38.77	37.78	38.47	902000.0
2022-03-22	AGZ	ETF	112.63	112.69	112.58	112.65	17556.0
2022-03-22	AGZD	ETF	23.19	23.235	23.135	23.2	381000.0
2022-03-22	AHHX	ETF	9.53	9.53	9.42	9.48	6902.0
2022-03-22	AHYB	ETF	47.18	47.407	47.18	47.407	800.0
2022-03-22	AIA	ETF	69.87	70.58	69.79	70.34	78204.0
2022-03-22	AIEQ	ETF	36.78	37.295	36.78	37.2	6700.0
2022-03-22	AIQ	ETF	26.67	27.28	26.67	27.2	15997.0
2022-03-22	AIRR	ETF	44.0	44.23	43.7	43.82	6400.0
2022-03-22	AIVI	ETF	40.66	40.72	40.58	40.71	7400.0
2022-03-22	AIVL	ETF	98.58	99.22	98.58	99.04	5200.0

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

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