PREVIEW / etf_daily / 2021-06-14

all etf daily files

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

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-14	SPY	ETF	424.43	425.37	423.1	425.26	42358500.0
2021-06-14	QQQ	ETF	341.68	344.52	340.46	344.51	27827716.0
2021-06-14	IWM	ETF	232.31	233.35	230.14	231.02	19182800.0
2021-06-14	DIA	ETF	344.83	344.87	342.47	344.3	2527000.0
2021-06-14	GLD	ETF	173.16	175.06	172.95	174.71	7733600.0
2021-06-14	TLT	ETF	142.1	142.1	141.01	141.22	9401300.0
2021-06-14	AAA	ETF	25.006	25.01	25.006	25.01	173.0
2021-06-14	AAAU	ETF	18.41	18.6	18.39	18.57	348800.0
2021-06-14	AADR	ETF	68.16	68.29	67.94	68.04	1200.0
2021-06-14	AAXJ	ETF	94.62	94.94	94.5	94.9	405600.0
2021-06-14	ABEQ	ETF	28.04	28.15	28.04	28.15	7000.0
2021-06-14	ACES	ETF	72.83	73.38	72.21	72.43	75300.0
2021-06-14	ACIO	ETF	29.899	30.04	29.862	30.04	52200.0
2021-06-14	ACSI	ETF	49.1007	49.1007	49.1007	49.1007	225.0
2021-06-14	ACTV	ETF	39.56	39.56	39.11	39.13	9734.0
2021-06-14	ACTX	ETF	3.4	3.4	3.4	3.4	396.0
2021-06-14	ACVF	ETF	31.66	31.67	31.61	31.67	1700.0
2021-06-14	ACWF	ETF	38.29	38.32	38.175	38.245	19508.0
2021-06-14	ACWI	ETF	101.19	101.44	101.03	101.44	1013900.0
2021-06-14	ACWV	ETF	103.7	103.7	103.28	103.59	346200.0
2021-06-14	ACWX	ETF	58.57	58.69	58.51	58.68	918744.0
2021-06-14	ADFI	ETF	9.71	9.73	9.645	9.71	7700.0
2021-06-14	ADIV	ETF	19.0	19.1	19.0	19.09	900.0
2021-06-14	ADME	ETF	39.048	39.178	38.99	39.178	56200.0
2021-06-14	ADRE	ETF	57.28	57.6785	57.27	57.31	6976.0
2021-06-14	AESR	ETF	13.38	13.411	13.35	13.411	7400.0
2021-06-14	AFIF	ETF	9.74	9.74	9.69	9.71	31836.0
2021-06-14	AFK	ETF	22.69	22.74	22.66	22.72	41304.0
2021-06-14	AFLG	ETF	25.23	25.288	25.23	25.288	300.0
2021-06-14	AFMC	ETF	25.483	25.483	25.483	25.483	100.0
2021-06-14	AFSM	ETF	26.26	26.325	26.26	26.325	1200.0
2021-06-14	AFTY	ETF	23.691	23.691	23.64	23.678	1600.0
2021-06-14	AGG	ETF	115.18	115.18	114.94	114.94	3270800.0
2021-06-14	AGGY	ETF	52.15	52.175	52.08	52.09	54300.0
2021-06-14	AGNG	ETF	30.579	30.62	30.579	30.62	700.0
2021-06-14	AGOX	ETF	26.35	26.35	25.98	26.073	15500.0
2021-06-14	AGQ	ETF	51.84	53.63	51.72	53.06	665600.0
2021-06-14	AGZ	ETF	118.62	118.62	118.42	118.44	48436.0
2021-06-14	AGZD	ETF	23.475	23.48	23.46	23.46	93400.0
2021-06-14	AIA	ETF	91.04	91.4182	91.01	91.32	53754.0
2021-06-14	AIEQ	ETF	40.25	40.48	40.2	40.301	21600.0
2021-06-14	AIQ	ETF	29.7	29.95	29.65	29.95	17661.0
2021-06-14	AIRR	ETF	42.04	42.04	41.39	41.55	29100.0
2021-06-14	AIVI	ETF	45.09	45.15	45.05	45.15	14300.0
2021-06-14	ALTL	ETF	41.78	42.0	41.371	41.5972	61900.0
2021-06-14	ALTY	ETF	13.85	13.92	13.85	13.875	30800.0
2021-06-14	AMJ	ETF	20.82	21.05	20.625	20.79	591686.0
2021-06-14	AMLP	ETF	38.53	38.92	38.08	38.46	3193300.0
2021-06-14	AMNA	ETF	35.4245	35.4245	35.4245	35.4245	0.0
2021-06-14	AMND	ETF	37.5778	37.5778	37.5778	37.5778	1.0

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

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