PREVIEW / etf_daily / 2021-10-01

all etf daily files

  file:    by_date/etf_daily/2021/2021-10-01.parquet
  size:    95 KB
  rows:    2,524

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-10-01	SPY	ETF	430.98	436.03	427.23	434.24	129240100.0
2021-10-01	QQQ	ETF	358.6	361.25	354.38	360.18	56375488.0
2021-10-01	IWM	ETF	219.95	223.5	217.74	222.28	32647000.0
2021-10-01	DIA	ETF	340.03	344.78	337.68	343.18	6219800.0
2021-10-01	GLD	ETF	164.27	164.96	163.89	164.59	6654700.0
2021-10-01	TLT	ETF	144.85	145.4	144.2	145.35	26151800.0
2021-10-01	AAA	ETF	25.0	25.0	25.0	25.0	1011.0
2021-10-01	AAAU	ETF	17.48	17.55	17.44	17.51	400800.0
2021-10-01	AADR	ETF	63.67	63.92	63.06	63.83	4000.0
2021-10-01	AAXJ	ETF	84.93	85.07	83.96	84.66	827800.0
2021-10-01	ABEQ	ETF	26.79	27.09	26.76	27.025	7700.0
2021-10-01	ACES	ETF	66.55	66.88	65.694	66.51	54800.0
2021-10-01	ACIO	ETF	30.06	30.251	30.06	30.1	62100.0
2021-10-01	ACSI	ETF	49.653	49.653	49.653	49.653	122.0
2021-10-01	ACT	ETF	22.05	22.21	21.655	21.77	92849.0
2021-10-01	ACTV	ETF	38.02	38.8	38.01	38.6689	6306.0
2021-10-01	ACTX	ETF	1.09	1.1	0.95	0.95	4336.0
2021-10-01	ACVF	ETF	32.22	32.46	31.91	32.34	6400.0
2021-10-01	ACWF	ETF	36.82	37.09	36.62	37.03	13854.0
2021-10-01	ACWI	ETF	100.39	101.07	99.45	100.76	3101500.0
2021-10-01	ACWV	ETF	102.88	103.34	102.19	102.85	67300.0
2021-10-01	ACWX	ETF	55.45	55.68	55.035	55.68	2180313.0
2021-10-01	ADFI	ETF	9.67	9.71	9.67	9.705	6300.0
2021-10-01	ADIV	ETF	16.942	16.942	16.942	16.942	100.0
2021-10-01	ADME	ETF	39.65	39.965	39.65	39.86	83600.0
2021-10-01	ADRE	ETF	48.19	48.19	47.62	48.04	25117.0
2021-10-01	AESR	ETF	13.7	13.84	13.62	13.74	41500.0
2021-10-01	AFIF	ETF	9.66	9.679	9.6501	9.67	19753.0
2021-10-01	AFK	ETF	20.77	20.78	20.64	20.78	6099.0
2021-10-01	AFLG	ETF	25.51	25.532	25.5	25.532	1300.0
2021-10-01	AFMC	ETF	25.27	25.27	25.222	25.222	1000.0
2021-10-01	AFSM	ETF	26.32	26.32	26.266	26.266	600.0
2021-10-01	AFTY	ETF	20.425	20.481	20.425	20.481	200.0
2021-10-01	AGG	ETF	114.82	115.06	114.79	115.0	7064500.0
2021-10-01	AGGY	ETF	51.96	52.13	51.95	52.13	130800.0
2021-10-01	AGNG	ETF	28.935	29.45	28.935	29.236	2700.0
2021-10-01	AGOV	ETF	99.41	99.425	99.41	99.425	224.0
2021-10-01	AGOX	ETF	25.628	26.03	25.59	25.93	217400.0
2021-10-01	AGQ	ETF	32.94	33.3	32.55	33.08	837300.0
2021-10-01	AGZ	ETF	118.39	118.59	118.39	118.58	17444.0
2021-10-01	AGZD	ETF	23.43	23.445	23.4	23.42	67200.0
2021-10-01	AIA	ETF	78.11	78.11	77.04	77.75	79903.0
2021-10-01	AIEQ	ETF	41.347	41.78	40.846	41.76	18500.0
2021-10-01	AIQ	ETF	30.27	30.38	29.9	30.25	39590.0
2021-10-01	AIRR	ETF	41.11	41.801	40.76	41.801	22700.0
2021-10-01	AIVI	ETF	40.78	40.97	40.59	40.92	2800.0
2021-10-01	ALTL	ETF	41.11	41.55	40.96	41.26	119963.0
2021-10-01	ALTY	ETF	13.3	13.37	13.231	13.34	21800.0
2021-10-01	AMJ	ETF	18.25	18.52	18.15	18.42	334424.0
2021-10-01	AMLP	ETF	33.58	34.02	33.32	33.79	1473300.0

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

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