PREVIEW / etf_daily / 2021-10-12

all etf daily files

  file:    by_date/etf_daily/2021/2021-10-12.parquet
  size:    95 KB
  rows:    2,514

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-10-12	SPY	ETF	435.67	436.1	432.78	433.62	71181200.0
2021-10-12	QQQ	ETF	359.88	360.33	356.48	357.14	43905101.0
2021-10-12	IWM	ETF	220.85	222.47	220.36	221.52	18800600.0
2021-10-12	DIA	ETF	345.49	346.1	343.19	343.78	5100300.0
2021-10-12	GLD	ETF	164.57	165.44	164.31	164.66	5453000.0
2021-10-12	TLT	ETF	142.63	144.01	142.48	143.94	17968700.0
2021-10-12	AAA	ETF	25.0033	25.0033	25.0	25.0	4806.0
2021-10-12	AAAU	ETF	17.51	17.58	17.48	17.52	159200.0
2021-10-12	AADR	ETF	63.29	63.89	63.29	63.86	800.0
2021-10-12	AAXJ	ETF	85.21	85.5	84.76	84.77	1343700.0
2021-10-12	ABEQ	ETF	27.297	27.297	27.25	27.25	300.0
2021-10-12	ACES	ETF	67.26	69.51	67.215	69.4	787400.0
2021-10-12	ACIO	ETF	30.32	30.32	30.168	30.168	12100.0
2021-10-12	ACSI	ETF	49.8452	49.8452	49.8452	49.8452	134.0
2021-10-12	ACT	ETF	20.77	20.93	20.44	20.5	398558.0
2021-10-12	ACTV	ETF	38.72	38.8186	38.57	38.6375	8264.0
2021-10-12	ACTX	ETF	1.09	1.09	0.995	1.0	1698.0
2021-10-12	ACVF	ETF	32.55	32.63	32.37	32.63	8300.0
2021-10-12	ACWF	ETF	36.958	36.958	36.7758	36.7758	3394.0
2021-10-12	ACWI	ETF	101.06	101.22	100.59	100.72	2454200.0
2021-10-12	ACWV	ETF	102.83	103.13	102.54	102.76	69700.0
2021-10-12	ACWX	ETF	55.65	55.73	55.48	55.54	972811.0
2021-10-12	ADFI	ETF	9.62	9.625	9.62	9.625	2700.0
2021-10-12	ADME	ETF	39.8	39.862	39.71	39.84	12000.0
2021-10-12	ADRE	ETF	49.57	49.57	49.12	49.12	7164.0
2021-10-12	AESR	ETF	13.77	13.83	13.7	13.73	17800.0
2021-10-12	AFIF	ETF	9.62	9.6452	9.62	9.6452	16015.0
2021-10-12	AFK	ETF	21.33	21.42	21.28	21.36	5003.0
2021-10-12	AFLG	ETF	25.513	25.513	25.513	25.513	100.0
2021-10-12	AFMC	ETF	25.21	25.23	25.182	25.182	1200.0
2021-10-12	AFSM	ETF	26.421	26.421	26.327	26.327	4900.0
2021-10-12	AFTY	ETF	21.25	21.27	21.19	21.2	4700.0
2021-10-12	AGG	ETF	114.17	114.38	114.11	114.37	3688400.0
2021-10-12	AGGY	ETF	51.7	51.75	51.63	51.75	107600.0
2021-10-12	AGNG	ETF	28.69	28.71	28.66	28.685	3500.0
2021-10-12	AGOV	ETF	98.77	98.77	98.705	98.72	3513.0
2021-10-12	AGOX	ETF	26.0	26.08	25.93	25.98	34800.0
2021-10-12	AGQ	ETF	33.09	33.83	32.89	33.31	727300.0
2021-10-12	AGZ	ETF	117.86	118.15	117.86	118.15	19927.0
2021-10-12	AGZD	ETF	23.6	23.6	23.425	23.43	20200.0
2021-10-12	AIA	ETF	78.929	78.929	78.05	78.05	93455.0
2021-10-12	AIEQ	ETF	42.0	42.0	41.78	41.82	11800.0
2021-10-12	AIQ	ETF	30.48	30.51	30.3	30.51	26958.0
2021-10-12	AIRR	ETF	41.58	41.68	41.44	41.46	10800.0
2021-10-12	AIVI	ETF	41.0	41.1	40.98	40.99	7200.0
2021-10-12	ALTL	ETF	41.33	41.63	41.32	41.33	45863.0
2021-10-12	ALTY	ETF	13.35	13.375	13.33	13.354	3800.0
2021-10-12	AMJ	ETF	19.1	19.355	19.08	19.3	316213.0
2021-10-12	AMLP	ETF	35.25	35.64	35.08	35.6	1729600.0
2021-10-12	AMNA	ETF	34.75	34.7769	34.48	34.7769	10003.0

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

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