PREVIEW / etf_daily / 2021-06-16

all etf daily files

  file:    by_date/etf_daily/2021/2021-06-16.parquet
  size:    90 KB
  rows:    2,368

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-16	SPY	ETF	424.63	424.87	419.92	422.11	80386100.0
2021-06-16	QQQ	ETF	342.74	343.84	337.45	341.01	55399538.0
2021-06-16	IWM	ETF	229.7	230.68	227.64	229.87	24527000.0
2021-06-16	DIA	ETF	343.41	343.64	339.49	340.76	4032000.0
2021-06-16	GLD	ETF	173.91	174.47	171.03	171.11	16919700.0
2021-06-16	TLT	ETF	141.4	141.67	140.21	140.93	19676300.0
2021-06-16	AAA	ETF	25.02	25.02	25.015	25.015	139.0
2021-06-16	AAAU	ETF	18.49	18.54	18.18	18.19	514700.0
2021-06-16	AADR	ETF	66.86	66.86	66.0	66.41	1900.0
2021-06-16	AAXJ	ETF	93.87	93.99	92.54	92.75	565800.0
2021-06-16	ABEQ	ETF	28.102	28.147	27.88	27.935	11300.0
2021-06-16	ACES	ETF	70.92	72.43	70.77	71.83	72300.0
2021-06-16	ACIO	ETF	29.98	29.98	29.745	29.818	14400.0
2021-06-16	ACSI	ETF	49.1069	49.1069	49.1069	49.1069	229.0
2021-06-16	ACTV	ETF	39.05	39.32	39.05	39.2973	3981.0
2021-06-16	ACVF	ETF	31.64	31.64	31.35	31.449	2400.0
2021-06-16	ACWF	ETF	38.23	38.23	37.82	37.8905	15052.0
2021-06-16	ACWI	ETF	101.29	101.29	100.08	100.59	3501000.0
2021-06-16	ACWV	ETF	103.66	103.66	102.32	102.61	138300.0
2021-06-16	ACWX	ETF	58.64	58.7	57.93	58.13	1767465.0
2021-06-16	ADFI	ETF	9.77	9.77	9.696	9.696	2300.0
2021-06-16	ADIV	ETF	19.02	19.02	18.82	18.82	800.0
2021-06-16	ADME	ETF	39.146	39.146	38.982	38.982	9100.0
2021-06-16	ADRE	ETF	56.74	56.783	56.1072	56.3	11379.0
2021-06-16	AESR	ETF	13.39	13.4	13.3	13.349	7200.0
2021-06-16	AFIF	ETF	9.7198	9.7397	9.689	9.689	7660.0
2021-06-16	AFK	ETF	22.29	22.4816	22.25	22.25	49442.0
2021-06-16	AFLG	ETF	25.109	25.109	25.109	25.109	500.0
2021-06-16	AFMC	ETF	25.31	25.35	25.31	25.349	800.0
2021-06-16	AFTY	ETF	23.29	23.29	22.93	22.959	3400.0
2021-06-16	AGG	ETF	115.07	115.13	114.51	114.62	8654200.0
2021-06-16	AGGY	ETF	52.12	52.18	51.905	51.945	52500.0
2021-06-16	AGNG	ETF	30.595	30.61	30.309	30.395	7800.0
2021-06-16	AGOX	ETF	26.03	26.03	25.81	25.881	9600.0
2021-06-16	AGQ	ETF	52.62	52.91	50.5	50.55	1134900.0
2021-06-16	AGZ	ETF	118.38	118.4838	118.03	118.03	18275.0
2021-06-16	AGZD	ETF	23.53	23.53	23.48	23.495	47200.0
2021-06-16	AIA	ETF	90.66	90.98	89.43	89.8	143354.0
2021-06-16	AIEQ	ETF	39.86	39.93	39.34	39.755	37100.0
2021-06-16	AIQ	ETF	29.69	29.7493	29.19	29.44	20814.0
2021-06-16	AIRR	ETF	41.71	41.766	41.295	41.56	16400.0
2021-06-16	AIVI	ETF	45.14	45.15	44.75	44.77	2800.0
2021-06-16	ALTL	ETF	41.64	41.8299	41.11	41.1601	8120.0
2021-06-16	ALTY	ETF	13.82	13.9	13.82	13.84	16900.0
2021-06-16	AMJ	ETF	20.81	21.01	20.6419	20.85	317307.0
2021-06-16	AMLP	ETF	38.4	38.85	38.09	38.73	2161100.0
2021-06-16	AMNA	ETF	35.83	35.83	35.6481	35.6481	259.0
2021-06-16	AMND	ETF	37.7938	37.7938	37.7938	37.7938	75.0
2021-06-16	AMOM	ETF	35.68	35.68	35.16	35.347	9400.0
2021-06-16	AMTR	ETF	41.67	41.7358	41.67	41.7358	124.0

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

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