PREVIEW / etf_daily / 2021-02-16

all etf daily files

  file:    by_date/etf_daily/2021/2021-02-16.parquet
  size:    86 KB
  rows:    2,269

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-02-16	SPY	ETF	393.96	394.17	391.53	392.3	50972400.0
2021-02-16	QQQ	ETF	337.27	338.19	334.34	335.54	27080777.0
2021-02-16	IWM	ETF	229.47	229.63	224.79	225.83	22999500.0
2021-02-16	DIA	ETF	316.33	316.54	314.87	315.58	1836300.0
2021-02-16	GLD	ETF	168.14	170.07	167.73	168.24	14761100.0
2021-02-16	TLT	ETF	145.22	145.66	144.66	144.87	17789100.0
2021-02-16	AAA	ETF	25.13	25.13	25.12	25.12	442.0
2021-02-16	AAAU	ETF	17.85	18.06	17.82	17.86	575600.0
2021-02-16	AADR	ETF	66.78	67.24	66.78	67.24	3100.0
2021-02-16	AAXJ	ETF	102.29	102.44	101.62	101.83	901700.0
2021-02-16	ABEQ	ETF	25.84	25.91	25.815	25.815	1300.0
2021-02-16	ACES	ETF	99.43	99.43	94.74	95.055	131000.0
2021-02-16	ACIO	ETF	28.21	28.21	28.017	28.03	61200.0
2021-02-16	ACSI	ETF	45.5	45.5152	45.5	45.5152	576.0
2021-02-16	ACTV	ETF	35.78	35.81	35.47	35.47	4359.0
2021-02-16	ACTX	ETF	5.5	6.0	5.25	6.0	1007.0
2021-02-16	ACVF	ETF	29.78	29.78	29.161	29.173	5800.0
2021-02-16	ACWF	ETF	36.46	36.46	36.1843	36.26	44672.0
2021-02-16	ACWI	ETF	96.87	96.94	96.26	96.52	2324400.0
2021-02-16	ACWV	ETF	97.89	97.99	97.34	97.38	444400.0
2021-02-16	ACWX	ETF	57.16	57.265	56.905	57.0	1235186.0
2021-02-16	ADFI	ETF	9.81	9.81	9.81	9.81	600.0
2021-02-16	ADME	ETF	37.166	37.166	36.91	36.96	34400.0
2021-02-16	ADRE	ETF	66.84	67.056	66.295	66.49	13537.0
2021-02-16	AESR	ETF	12.67	12.67	12.45	12.47	40500.0
2021-02-16	AFIF	ETF	9.7248	9.74	9.7	9.72	38426.0
2021-02-16	AFK	ETF	21.84	22.218	21.79	21.88	35278.0
2021-02-16	AFLG	ETF	23.83	23.83	23.619	23.619	1700.0
2021-02-16	AFMC	ETF	23.673	23.673	23.673	23.673	100.0
2021-02-16	AFSM	ETF	25.89	25.89	25.775	25.808	3300.0
2021-02-16	AFTY	ETF	27.23	27.309	27.075	27.19	10200.0
2021-02-16	AGG	ETF	116.22	116.23	116.02	116.03	5682700.0
2021-02-16	AGGY	ETF	52.73	52.74	52.55	52.56	263000.0
2021-02-16	AGNG	ETF	29.516	29.516	29.22	29.25	8800.0
2021-02-16	AGQ	ETF	51.25	53.58	50.8	51.92	1407200.0
2021-02-16	AGZ	ETF	119.02	119.02	118.875	118.92	66537.0
2021-02-16	AGZD	ETF	23.685	23.69	23.625	23.69	12200.0
2021-02-16	AIA	ETF	102.34	102.5	101.8	101.92	190055.0
2021-02-16	AIEQ	ETF	42.57	42.64	41.55	41.88	93900.0
2021-02-16	AIQ	ETF	30.635	30.76	30.401	30.62	112858.0
2021-02-16	AIRR	ETF	38.23	38.356	38.05	38.13	21500.0
2021-02-16	AIVI	ETF	42.52	42.62	42.46	42.52	14300.0
2021-02-16	ALTL	ETF	36.06	36.41	36.06	36.41	5882.0
2021-02-16	ALTY	ETF	12.5	12.5	12.398	12.4	29300.0
2021-02-16	AMJ	ETF	15.89	15.98	15.8111	15.84	664666.0
2021-02-16	AMLP	ETF	28.63	28.83	28.5	28.58	2632900.0
2021-02-16	AMNA	ETF	28.3233	28.3233	28.3233	28.3233	0.0
2021-02-16	AMND	ETF	30.0963	30.0963	30.0963	30.0963	2.0
2021-02-16	AMOM	ETF	35.0	35.0	34.5	34.515	3500.0
2021-02-16	AMPS	ETF	10.6	10.65	10.51	10.6	18463.0

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

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