PREVIEW / etf_daily / 2021-04-21

all etf daily files

  file:    by_date/etf_daily/2021/2021-04-21.parquet
  size:    88 KB
  rows:    2,319

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-04-21	SPY	ETF	411.51	416.29	411.36	416.07	66793000.0
2021-04-21	QQQ	ETF	335.09	339.48	333.97	339.29	36598082.0
2021-04-21	IWM	ETF	217.02	222.62	215.5	222.5	31147800.0
2021-04-21	DIA	ETF	337.63	341.54	337.56	341.3	4191200.0
2021-04-21	GLD	ETF	167.18	168.39	167.15	168.13	8380200.0
2021-04-21	TLT	ETF	139.54	139.91	139.07	139.78	11902200.0
2021-04-21	AAA	ETF	25.0419	25.0419	25.04	25.04	123.0
2021-04-21	AAAU	ETF	17.75	17.89	17.75	17.87	786900.0
2021-04-21	AADR	ETF	64.02	64.53	64.0	64.53	2400.0
2021-04-21	AAXJ	ETF	92.7	93.68	92.47	93.6	405600.0
2021-04-21	ABEQ	ETF	27.378	27.495	27.378	27.495	1400.0
2021-04-21	ACES	ETF	70.75	73.57	70.75	73.56	55100.0
2021-04-21	ACIO	ETF	29.51	29.67	29.51	29.67	9900.0
2021-04-21	ACSI	ETF	48.2411	48.2411	48.2411	48.2411	363.0
2021-04-21	ACTV	ETF	35.96	37.05	35.96	36.6809	15879.0
2021-04-21	ACVF	ETF	30.74	30.987	30.7	30.987	5400.0
2021-04-21	ACWF	ETF	37.42	37.92	37.33	37.88	11315.0
2021-04-21	ACWI	ETF	97.95	99.16	97.9	99.08	6945000.0
2021-04-21	ACWV	ETF	101.47	102.12	101.47	102.05	137100.0
2021-04-21	ACWX	ETF	56.06	56.75	55.99	56.74	2437284.0
2021-04-21	ADFI	ETF	9.68	9.685	9.67	9.685	5700.0
2021-04-21	ADIV	ETF	18.91	19.03	18.91	19.03	600.0
2021-04-21	ADME	ETF	38.4	38.59	38.4	38.59	11900.0
2021-04-21	ADRE	ETF	55.25	56.06	55.09	56.06	9915.0
2021-04-21	AESR	ETF	13.02	13.191	12.99	13.191	14300.0
2021-04-21	AFIF	ETF	9.72	9.72	9.7	9.72	17394.0
2021-04-21	AFK	ETF	21.42	21.73	21.42	21.72	6625.0
2021-04-21	AFLG	ETF	24.86	24.909	24.859	24.909	700.0
2021-04-21	AFMC	ETF	24.94	25.041	24.94	25.041	2300.0
2021-04-21	AFSM	ETF	25.67	25.67	25.67	25.67	100.0
2021-04-21	AFTY	ETF	22.685	22.691	22.685	22.691	800.0
2021-04-21	AGG	ETF	114.6	114.74	114.53	114.74	5511300.0
2021-04-21	AGGY	ETF	51.8	51.88	51.76	51.85	162700.0
2021-04-21	AGNG	ETF	29.09	29.26	29.09	29.26	2700.0
2021-04-21	AGQ	ETF	46.58	48.91	46.51	48.77	1202400.0
2021-04-21	AGZ	ETF	118.24	118.28	118.2	118.25	30481.0
2021-04-21	AGZD	ETF	23.57	23.59	23.515	23.555	37800.0
2021-04-21	AIA	ETF	92.03	92.96	91.68	92.95	127935.0
2021-04-21	AIEQ	ETF	38.14	39.15	38.14	39.148	20800.0
2021-04-21	AIQ	ETF	29.24	29.58	29.13	29.51	219580.0
2021-04-21	AIRR	ETF	40.4	41.13	40.264	41.13	33700.0
2021-04-21	AIVI	ETF	43.43	43.55	43.43	43.55	2800.0
2021-04-21	ALTL	ETF	38.91	39.45	38.91	39.4465	5255.0
2021-04-21	ALTY	ETF	13.1	13.166	13.055	13.11	8700.0
2021-04-21	AMJ	ETF	16.86	17.25	16.82	17.25	396286.0
2021-04-21	AMLP	ETF	31.11	31.87	30.94	31.83	2104900.0
2021-04-21	AMNA	ETF	30.1205	30.1205	30.1205	30.1205	0.0
2021-04-21	AMND	ETF	32.0956	32.0956	32.0956	32.0956	1.0
2021-04-21	AMOM	ETF	34.62	35.27	34.62	35.23	27400.0
2021-04-21	AMPS	ETF	10.0	10.0	9.92	9.95	10161.0

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

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