PREVIEW / etf_daily / 2021-06-09

all etf daily files

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

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-09	SPY	ETF	423.18	423.26	421.41	421.65	48436300.0
2021-06-09	QQQ	ETF	338.17	338.97	336.651	336.84	21485319.0
2021-06-09	IWM	ETF	233.54	233.64	230.98	231.34	18700600.0
2021-06-09	DIA	ETF	346.54	346.88	344.69	344.79	2591200.0
2021-06-09	GLD	ETF	177.38	177.8	176.78	176.98	6346100.0
2021-06-09	TLT	ETF	141.76	142.15	141.25	141.69	12768300.0
2021-06-09	AAA	ETF	25.01	25.01	25.01	25.01	20.0
2021-06-09	AAAU	ETF	18.86	18.89	18.79	18.81	343500.0
2021-06-09	AAXJ	ETF	94.34	94.65	94.1	94.14	709200.0
2021-06-09	ABEQ	ETF	28.245	28.27	28.212	28.219	800.0
2021-06-09	ACES	ETF	71.71	72.28	71.197	71.24	35800.0
2021-06-09	ACIO	ETF	29.855	29.87	29.783	29.783	7600.0
2021-06-09	ACSI	ETF	49.0999	49.1	48.927	48.927	4631.0
2021-06-09	ACTV	ETF	39.6875	39.71	39.4449	39.4449	3175.0
2021-06-09	ACTX	ETF	3.4	3.4	3.35	3.35	648.0
2021-06-09	ACVF	ETF	31.5	31.54	31.5	31.509	1800.0
2021-06-09	ACWF	ETF	38.72	38.72	38.51	38.51	4185.0
2021-06-09	ACWI	ETF	101.52	101.61	101.18	101.21	1382300.0
2021-06-09	ACWV	ETF	103.88	104.32	103.88	104.02	64700.0
2021-06-09	ACWX	ETF	59.0	59.05	58.83	58.85	1021454.0
2021-06-09	ADFI	ETF	9.71	9.725	9.71	9.725	200.0
2021-06-09	ADIV	ETF	19.03	19.03	18.98	18.98	400.0
2021-06-09	ADME	ETF	38.95	38.98	38.83	38.854	8000.0
2021-06-09	ADRE	ETF	56.81	57.1554	56.745	56.8282	69817.0
2021-06-09	AESR	ETF	13.348	13.36	13.285	13.33	4600.0
2021-06-09	AFIF	ETF	9.745	9.77	9.731	9.75	536658.0
2021-06-09	AFK	ETF	22.7	22.99	22.5	22.55	12742.0
2021-06-09	AFLG	ETF	25.22	25.22	25.22	25.22	100.0
2021-06-09	AFMC	ETF	25.713	25.713	25.713	25.713	100.0
2021-06-09	AFSM	ETF	26.63	26.63	26.505	26.505	400.0
2021-06-09	AFTY	ETF	23.92	24.01	23.9	23.96	12500.0
2021-06-09	AGG	ETF	115.43	115.43	114.97	115.04	3643100.0
2021-06-09	AGGY	ETF	52.02	52.118	52.02	52.11	55300.0
2021-06-09	AGNG	ETF	29.95	30.2	29.95	30.11	2500.0
2021-06-09	AGOX	ETF	26.25	26.25	25.92	25.966	91000.0
2021-06-09	AGQ	ETF	52.96	53.57	52.47	52.75	1604300.0
2021-06-09	AGZ	ETF	118.66	118.66	118.5	118.5289	46501.0
2021-06-09	AGZD	ETF	23.465	23.53	23.46	23.49	89600.0
2021-06-09	AIA	ETF	91.12	91.37	90.88	90.92	50650.0
2021-06-09	AIEQ	ETF	39.59	39.79	39.41	39.41	12900.0
2021-06-09	AIQ	ETF	29.22	29.365	29.21	29.29	8043.0
2021-06-09	AIRR	ETF	42.65	42.71	42.375	42.46	23800.0
2021-06-09	AIVI	ETF	45.04	45.09	44.93	44.93	2800.0
2021-06-09	ALTL	ETF	41.37	41.3893	41.19	41.3	42582.0
2021-06-09	ALTY	ETF	13.64	13.8	13.64	13.76	24500.0
2021-06-09	AMJ	ETF	20.06	20.34	19.96	20.1	287513.0
2021-06-09	AMLP	ETF	37.08	37.6	36.86	37.26	3227700.0
2021-06-09	AMNA	ETF	34.9897	34.9897	34.9897	34.9897	0.0
2021-06-09	AMND	ETF	36.9194	36.9194	36.9194	36.9194	1.0
2021-06-09	AMOM	ETF	35.68	35.68	35.37	35.41	62000.0

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

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