PREVIEW / etf_daily / 2021-12-17

all etf daily files

  file:    by_date/etf_daily/2021/2021-12-17.parquet
  size:    98 KB
  rows:    2,604

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-12-17	SPY	ETF	461.55	464.74	458.06	459.87	135511600.0
2021-12-17	QQQ	ETF	383.33	389.19	381.77	384.91	81642848.0
2021-12-17	IWM	ETF	212.2	217.35	210.3	215.14	62620900.0
2021-12-17	DIA	ETF	356.3	356.93	352.71	353.63	10638300.0
2021-12-17	GLD	ETF	168.73	169.13	167.78	167.8	9856900.0
2021-12-17	TLT	ETF	150.34	150.98	150.16	150.83	18093500.0
2021-12-17	AAA	ETF	25.035	25.035	25.035	25.035	62.0
2021-12-17	AAAU	ETF	17.96	17.99	17.86	17.86	111000.0
2021-12-17	AADR	ETF	62.23	62.23	61.97	61.97	2800.0
2021-12-17	AAXJ	ETF	81.22	81.72	80.96	81.35	1268800.0
2021-12-17	ABEQ	ETF	28.08	28.13	27.925	27.925	3200.0
2021-12-17	ACES	ETF	63.06	65.09	62.16	64.44	290300.0
2021-12-17	ACIO	ETF	32.03	32.03	31.761	31.82	23200.0
2021-12-17	ACSI	ETF	51.4	51.62	51.4	51.4152	357.0
2021-12-17	ACT	ETF	20.46	21.15	18.76	19.3	2419995.0
2021-12-17	ACTV	ETF	37.61	38.15	37.46	37.8154	2744.0
2021-12-17	ACTX	ETF	1.12	1.12	1.12	1.12	6128.0
2021-12-17	ACVF	ETF	34.43	34.66	34.221	34.492	14400.0
2021-12-17	ACWF	ETF	37.84	38.05	37.74	37.82	31690.0
2021-12-17	ACWI	ETF	103.01	103.62	102.41	102.77	4335900.0
2021-12-17	ACWV	ETF	106.93	106.93	105.93	106.05	242900.0
2021-12-17	ACWX	ETF	54.49	54.66	54.27	54.31	2047046.0
2021-12-17	ADFI	ETF	9.7	9.7	9.58	9.595	4900.0
2021-12-17	ADIV	ETF	15.933	15.933	15.933	15.933	100.0
2021-12-17	ADME	ETF	42.28	42.295	41.996	42.02	44600.0
2021-12-17	ADRE	ETF	45.17	45.8737	45.17	45.5991	3064.0
2021-12-17	AEMB	ETF	48.255	48.255	48.255	48.255	100.0
2021-12-17	AESR	ETF	13.65	13.73	13.588	13.588	32900.0
2021-12-17	AFIF	ETF	9.59	9.59	9.57	9.58	18756.0
2021-12-17	AFK	ETF	20.46	20.51	20.01	20.19	31942.0
2021-12-17	AFLG	ETF	27.56	27.56	27.399	27.399	1100.0
2021-12-17	AFMC	ETF	25.743	25.743	25.743	25.743	100.0
2021-12-17	AFSM	ETF	26.5	26.577	26.5	26.577	100.0
2021-12-17	AFTY	ETF	21.24	21.43	21.24	21.38	7400.0
2021-12-17	AGG	ETF	114.55	114.68	114.47	114.5	7428000.0
2021-12-17	AGGY	ETF	51.89	51.99	51.89	51.94	160600.0
2021-12-17	AGNG	ETF	28.15	28.317	28.03	28.16	4200.0
2021-12-17	AGOV	ETF	98.315	98.315	98.315	98.315	60.0
2021-12-17	AGOX	ETF	24.6	24.91	24.6	24.84	31300.0
2021-12-17	AGQ	ETF	32.52	32.7	31.96	32.0	1047200.0
2021-12-17	AGZ	ETF	117.59	117.7099	117.49	117.5	159662.0
2021-12-17	AGZD	ETF	23.35	23.385	23.32	23.325	12000.0
2021-12-17	AHHX	ETF	10.2792	10.445	10.2792	10.32	324.0
2021-12-17	AHYB	ETF	49.675	49.675	49.675	49.675	100.0
2021-12-17	AIA	ETF	75.4	75.96	75.16	75.68	56363.0
2021-12-17	AIEQ	ETF	40.58	41.29	40.535	40.875	14400.0
2021-12-17	AIQ	ETF	30.7	31.14	30.66	30.91	20284.0
2021-12-17	AIRR	ETF	43.68	44.111	43.073	43.32	29000.0
2021-12-17	AIVI	ETF	41.52	41.53	41.26	41.27	7400.0
2021-12-17	ALTL	ETF	43.53	44.28	43.11	43.86	38303.0

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

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