PREVIEW / etf_daily / 2021-03-02

all etf daily files

  file:    by_date/etf_daily/2021/2021-03-02.parquet
  size:    87 KB
  rows:    2,279

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-03-02	SPY	ETF	389.82	390.07	386.0	386.54	79595300.0
2021-03-02	QQQ	ETF	324.25	324.33	318.14	318.4	48370034.0
2021-03-02	IWM	ETF	225.79	225.96	221.55	221.72	26895400.0
2021-03-02	DIA	ETF	315.72	316.43	314.01	314.19	4075700.0
2021-03-02	GLD	ETF	161.93	162.93	161.22	162.41	11424600.0
2021-03-02	TLT	ETF	140.4	141.13	140.29	141.07	12482200.0
2021-03-02	AAA	ETF	25.055	25.055	25.055	25.055	241.0
2021-03-02	AAAU	ETF	17.19	17.3	17.13	17.24	369500.0
2021-03-02	AADR	ETF	64.01	64.49	64.01	64.18	7000.0
2021-03-02	AAXJ	ETF	96.59	96.59	95.82	95.93	1029200.0
2021-03-02	ABEQ	ETF	25.685	25.8	25.685	25.689	3900.0
2021-03-02	ACES	ETF	85.14	85.14	82.06	82.18	455600.0
2021-03-02	ACIO	ETF	27.79	27.79	27.63	27.63	39200.0
2021-03-02	ACSI	ETF	45.82	45.82	45.4322	45.4322	1277.0
2021-03-02	ACTV	ETF	35.51	35.51	35.115	35.1205	2837.0
2021-03-02	ACTX	ETF	5.44	5.44	5.44	5.44	268.0
2021-03-02	ACVF	ETF	28.96	28.96	28.893	28.893	200.0
2021-03-02	ACWF	ETF	35.71	35.72	35.5	35.51	11011.0
2021-03-02	ACWI	ETF	94.69	94.71	94.02	94.03	2412900.0
2021-03-02	ACWV	ETF	95.47	95.74	94.99	95.27	256400.0
2021-03-02	ACWX	ETF	55.34	55.52	55.14	55.31	392788.0
2021-03-02	ADFI	ETF	9.75	9.76	9.735	9.735	2000.0
2021-03-02	ADME	ETF	36.254	36.254	36.03	36.03	19600.0
2021-03-02	ADRE	ETF	61.06	61.2	60.28	60.29	53226.0
2021-03-02	AESR	ETF	12.34	12.38	12.28	12.28	11400.0
2021-03-02	AFIF	ETF	9.72	9.74	9.69	9.7201	219933.0
2021-03-02	AFK	ETF	21.5	21.6	21.45	21.54	4877.0
2021-03-02	AFLG	ETF	23.47	23.47	23.223	23.223	1200.0
2021-03-02	AFMC	ETF	23.582	23.582	23.582	23.582	900.0
2021-03-02	AFSM	ETF	24.961	24.961	24.961	24.961	100.0
2021-03-02	AFTY	ETF	24.03	24.03	23.89	23.904	6800.0
2021-03-02	AGG	ETF	115.04	115.12	114.95	115.11	10111300.0
2021-03-02	AGGY	ETF	51.98	52.12	51.97	52.12	210400.0
2021-03-02	AGNG	ETF	28.0	28.01	27.84	27.94	7100.0
2021-03-02	AGQ	ETF	48.4	50.36	48.13	49.67	1053500.0
2021-03-02	AGZ	ETF	118.38	118.49	118.3135	118.49	23706.0
2021-03-02	AGZD	ETF	23.625	23.675	23.605	23.65	65800.0
2021-03-02	AIA	ETF	96.46	96.46	95.7256	95.98	443522.0
2021-03-02	AIEQ	ETF	40.25	40.25	39.18	39.25	44400.0
2021-03-02	AIQ	ETF	29.45	29.5	29.07	29.07	29547.0
2021-03-02	AIRR	ETF	39.85	39.972	39.08	39.08	14100.0
2021-03-02	AIVI	ETF	42.01	42.15	41.92	42.02	6200.0
2021-03-02	ALTL	ETF	38.68	38.68	38.3297	38.3297	6890.0
2021-03-02	ALTY	ETF	12.46	12.48	12.4	12.47	10500.0
2021-03-02	AMJ	ETF	16.3	16.57	16.15	16.57	552773.0
2021-03-02	AMLP	ETF	30.0	30.51	29.76	30.41	5283900.0
2021-03-02	AMNA	ETF	28.8711	28.8711	28.8711	28.8711	0.0
2021-03-02	AMND	ETF	30.7767	30.7767	30.7767	30.7767	3.0
2021-03-02	AMOM	ETF	33.1	33.19	32.578	32.578	6500.0
2021-03-02	AMPS	ETF	10.1	10.2	9.74	9.995	52254.0

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

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