PREVIEW / etf_daily / 2021-06-11

all etf daily files

  file:    by_date/etf_daily/2021/2021-06-11.parquet
  size:    89 KB
  rows:    2,355

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-11	SPY	ETF	424.2	424.43	422.82	424.31	45570800.0
2021-06-11	QQQ	ETF	340.36	341.25	339.69	341.24	21222830.0
2021-06-11	IWM	ETF	230.3	231.8	230.07	231.7	16707200.0
2021-06-11	DIA	ETF	346.03	346.55	343.57	345.12	3003000.0
2021-06-11	GLD	ETF	176.33	176.57	175.48	175.74	7836900.0
2021-06-11	TLT	ETF	142.31	142.4	141.84	142.31	8646700.0
2021-06-11	AAA	ETF	25.01	25.01	25.01	25.01	28.0
2021-06-11	AAAU	ETF	18.75	18.76	18.66	18.68	381100.0
2021-06-11	AADR	ETF	67.98	68.21	67.96	68.21	1300.0
2021-06-11	AAXJ	ETF	94.51	94.62	94.13	94.62	4302200.0
2021-06-11	ABEQ	ETF	28.264	28.28	28.185	28.213	1700.0
2021-06-11	ACES	ETF	72.16	72.38	71.8	72.34	75300.0
2021-06-11	ACIO	ETF	29.97	29.97	29.85	29.91	13200.0
2021-06-11	ACSI	ETF	49.2414	49.2414	49.2414	49.2414	204.0
2021-06-11	ACTV	ETF	39.57	39.63	39.51	39.5978	5749.0
2021-06-11	ACVF	ETF	31.66	31.664	31.605	31.664	1300.0
2021-06-11	ACWF	ETF	38.26	38.3031	38.2	38.3031	5917.0
2021-06-11	ACWI	ETF	101.14	101.18	100.82	101.18	3325000.0
2021-06-11	ACWV	ETF	103.58	103.72	103.36	103.59	117000.0
2021-06-11	ACWX	ETF	58.54	58.58	58.355	58.58	1314566.0
2021-06-11	ADFI	ETF	9.74	9.74	9.74	9.74	2800.0
2021-06-11	ADIV	ETF	19.08	19.08	19.06	19.06	1100.0
2021-06-11	ADME	ETF	39.045	39.06	38.921	39.06	6600.0
2021-06-11	ADRE	ETF	56.95	57.0972	56.8	56.9945	5036.0
2021-06-11	AESR	ETF	13.345	13.38	13.33	13.38	7500.0
2021-06-11	AFIF	ETF	9.7499	9.7499	9.71	9.73	10054.0
2021-06-11	AFK	ETF	22.78	22.78	22.5632	22.66	24287.0
2021-06-11	AFLG	ETF	25.339	25.339	25.339	25.339	100.0
2021-06-11	AFMC	ETF	25.71	25.744	25.68	25.744	2000.0
2021-06-11	AFSM	ETF	26.42	26.514	26.42	26.514	1000.0
2021-06-11	AFTY	ETF	23.85	23.85	23.7	23.744	6600.0
2021-06-11	AGG	ETF	115.31	115.32	115.16	115.23	3781900.0
2021-06-11	AGGY	ETF	52.24	52.37	52.18	52.26	238300.0
2021-06-11	AGNG	ETF	30.66	30.66	30.358	30.515	23200.0
2021-06-11	AGOX	ETF	26.3	26.3	26.0	26.11	12600.0
2021-06-11	AGQ	ETF	54.24	54.68	53.1	53.18	1604900.0
2021-06-11	AGZ	ETF	118.71	118.71	118.55	118.6	37366.0
2021-06-11	AGZD	ETF	23.45	23.47	23.45	23.46	34600.0
2021-06-11	AIA	ETF	91.29	91.29	90.78	91.16	145094.0
2021-06-11	AIEQ	ETF	39.82	40.14	39.66	40.14	17900.0
2021-06-11	AIQ	ETF	29.43	29.6	29.43	29.6	20719.0
2021-06-11	AIRR	ETF	42.02	42.2	41.722	42.02	19600.0
2021-06-11	AIVI	ETF	45.13	45.13	44.99	45.11	2500.0
2021-06-11	ALTL	ETF	41.69	41.69	41.44	41.58	13670.0
2021-06-11	ALTY	ETF	13.79	13.86	13.77	13.856	10000.0
2021-06-11	AMJ	ETF	20.6	20.905	20.6	20.72	426806.0
2021-06-11	AMLP	ETF	38.3	38.69	38.11	38.28	3694900.0
2021-06-11	AMNA	ETF	35.4458	35.4458	35.4458	35.4458	0.0
2021-06-11	AMND	ETF	37.5311	37.5311	37.5311	37.5311	14.0
2021-06-11	AMOM	ETF	35.56	35.75	35.5	35.75	25200.0

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

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