PREVIEW / etf_daily / 2021-04-30

all etf daily files

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

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-30	SPY	ETF	417.63	418.54	416.34	417.3	85527000.0
2021-04-30	QQQ	ETF	337.7	340.26	337.05	337.99	38263421.0
2021-04-30	IWM	ETF	225.72	227.8	224.14	224.89	27006000.0
2021-04-30	DIA	ETF	338.92	339.65	337.85	338.94	2909600.0
2021-04-30	GLD	ETF	165.86	166.0	165.24	165.66	6248700.0
2021-04-30	TLT	ETF	138.51	138.73	137.98	138.64	15692000.0
2021-04-30	AAA	ETF	25.04	25.04	25.04	25.04	63.0
2021-04-30	AAAU	ETF	17.63	17.64	17.56	17.6	431200.0
2021-04-30	AADR	ETF	65.85	65.85	65.12	65.16	3000.0
2021-04-30	AAXJ	ETF	93.92	94.19	93.43	93.68	426700.0
2021-04-30	ABEQ	ETF	27.43	27.444	27.36	27.38	4900.0
2021-04-30	ACES	ETF	73.64	74.145	72.63	72.81	81900.0
2021-04-30	ACIO	ETF	29.69	29.729	29.675	29.7	9000.0
2021-04-30	ACSI	ETF	48.92	48.92	48.72	48.7298	2826.0
2021-04-30	ACTV	ETF	37.63	37.63	37.04	37.2257	27896.0
2021-04-30	ACVF	ETF	30.88	31.18	30.88	30.932	13200.0
2021-04-30	ACWF	ETF	37.86	37.87	37.49	37.58	13357.0
2021-04-30	ACWI	ETF	99.39	99.65	98.93	99.19	2139000.0
2021-04-30	ACWV	ETF	101.2	101.46	101.08	101.34	160400.0
2021-04-30	ACWX	ETF	56.94	56.9999	56.405	56.59	924151.0
2021-04-30	ADFI	ETF	9.685	9.685	9.685	9.685	300.0
2021-04-30	ADIV	ETF	18.98	18.98	18.845	18.845	900.0
2021-04-30	ADME	ETF	38.82	38.82	38.724	38.724	6700.0
2021-04-30	ADRE	ETF	57.08	57.332	56.7732	56.7732	14925.0
2021-04-30	AESR	ETF	13.28	13.28	13.23	13.23	1600.0
2021-04-30	AFIF	ETF	9.68	9.73	9.68	9.7051	5438.0
2021-04-30	AFK	ETF	21.9	21.92	21.62	21.64	8025.0
2021-04-30	AFLG	ETF	24.89	24.89	24.856	24.856	1000.0
2021-04-30	AFMC	ETF	25.32	25.38	25.24	25.24	1000.0
2021-04-30	AFSM	ETF	25.779	25.779	25.779	25.779	1600.0
2021-04-30	AFTY	ETF	22.776	22.776	22.776	22.776	100.0
2021-04-30	AGG	ETF	114.41	114.52	114.33	114.49	6469500.0
2021-04-30	AGGY	ETF	51.64	51.68	51.59	51.68	72000.0
2021-04-30	AGNG	ETF	29.041	29.041	28.975	28.975	3100.0
2021-04-30	AGQ	ETF	46.72	46.89	45.64	45.79	505800.0
2021-04-30	AGZ	ETF	118.0	118.15	117.951	118.08	141164.0
2021-04-30	AGZD	ETF	23.53	23.56	23.52	23.54	74400.0
2021-04-30	AIA	ETF	92.83	92.87	92.09	92.21	233614.0
2021-04-30	AIEQ	ETF	39.24	39.385	38.91	38.91	9400.0
2021-04-30	AIQ	ETF	29.5	29.61	29.2969	29.32	27017.0
2021-04-30	AIRR	ETF	41.9	41.925	41.4	41.53	52600.0
2021-04-30	AIVI	ETF	43.42	43.42	43.07	43.07	2900.0
2021-04-30	ALTL	ETF	40.95	41.2331	40.72	40.76	5081.0
2021-04-30	ALTY	ETF	13.44	13.44	13.36	13.405	29800.0
2021-04-30	AMJ	ETF	18.15	18.2	17.65	17.65	443988.0
2021-04-30	AMLP	ETF	33.3	33.72	32.64	32.74	3366300.0
2021-04-30	AMNA	ETF	31.1689	31.1689	31.1689	31.1689	0.0
2021-04-30	AMND	ETF	33.0946	33.0946	33.0946	33.0946	0.0
2021-04-30	AMOM	ETF	35.36	35.42	35.15	35.15	7500.0
2021-04-30	AMPS	ETF	9.94	9.95	9.93	9.95	21944.0

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

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