PREVIEW / etf_daily / 2022-12-02

all etf daily files

  file:    by_date/etf_daily/2022/2022-12-02.parquet
  size:    107 KB
  rows:    2,881

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
2022-12-02	SPY	ETF	402.25	407.86	402.14	406.91	85342700.0
2022-12-02	QQQ	ETF	288.54	293.45	288.36	292.55	53583172.0
2022-12-02	IWM	ETF	184.37	188.86	184.33	188.05	22574800.0
2022-12-02	DIA	ETF	340.86	345.41	340.86	344.74	3736500.0
2022-12-02	GLD	ETF	166.18	167.47	165.76	167.26	5185900.0
2022-12-02	TLT	ETF	105.3	107.1	104.61	107.09	24479500.0
2022-12-02	AAA	ETF	24.3199	24.3199	24.29	24.29	386.0
2022-12-02	AAAU	ETF	17.72	17.86	17.67	17.84	990300.0
2022-12-02	AADR	ETF	49.75	49.8	49.57	49.76	3400.0
2022-12-02	AAPB	ETF	19.6	19.6	19.6	19.6	126.0
2022-12-02	AAPD	ETF	27.13	27.1699	26.7501	26.77	133021.0
2022-12-02	AAPU	ETF	20.12	20.53	20.09	20.52	34703.0
2022-12-02	AAXJ	ETF	65.74	67.08	65.74	66.88	629100.0
2022-12-02	ABEQ	ETF	28.42	28.575	28.42	28.575	25100.0
2022-12-02	ACES	ETF	54.15	55.91	54.15	55.75	41000.0
2022-12-02	ACIO	ETF	30.08	30.31	30.035	30.25	50400.0
2022-12-02	ACSI	ETF	45.3693	45.3693	45.3693	45.3693	3.0
2022-12-02	ACT	ETF	24.55	24.86	24.4301	24.75	89270.0
2022-12-02	ACTV	ETF	30.6	31.32	30.6	31.29	4685.0
2022-12-02	ACTX	ETF	0.4499	0.4499	0.4499	0.4499	808.0
2022-12-02	ACVF	ETF	31.18	31.55	31.18	31.452	6200.0
2022-12-02	ACWF	ETF	33.53	33.87	33.53	33.81	5132.0
2022-12-02	ACWI	ETF	88.79	89.95	88.76	89.72	4086400.0
2022-12-02	ACWV	ETF	98.09	99.02	97.9	98.82	178600.0
2022-12-02	ACWX	ETF	46.81	47.365	46.8	47.22	2660435.0
2022-12-02	ADFI	ETF	8.4	8.534	8.4	8.534	13200.0
2022-12-02	ADIV	ETF	13.068	13.14	13.068	13.14	2100.0
2022-12-02	ADME	ETF	35.17	35.44	35.17	35.35	207500.0
2022-12-02	ADPV	ETF	25.08	25.08	25.075	25.075	20303.0
2022-12-02	ADRE	ETF	39.03	39.7135	39.03	39.6	3696.0
2022-12-02	AESR	ETF	11.97	12.1	11.96	12.08	32100.0
2022-12-02	AFIF	ETF	8.785	8.819	8.77	8.81	14493.0
2022-12-02	AFK	ETF	17.09	17.43	17.01	17.36	9225.0
2022-12-02	AFLG	ETF	24.61	24.643	24.61	24.643	100.0
2022-12-02	AFMC	ETF	23.58	23.68	23.58	23.582	300.0
2022-12-02	AFSM	ETF	24.2	24.239	24.176	24.239	500.0
2022-12-02	AFTY	ETF	15.48	15.79	15.47	15.75	3100.0
2022-12-02	AGG	ETF	98.49	99.3	98.3	99.29	6368000.0
2022-12-02	AGGH	ETF	22.775	22.82	22.74	22.74	1671.0
2022-12-02	AGGY	ETF	43.36	43.71	43.28	43.69	453300.0
2022-12-02	AGNG	ETF	26.41	26.89	26.41	26.89	800.0
2022-12-02	AGOV	ETF	81.61	81.61	81.61	81.61	81.0
2022-12-02	AGOX	ETF	21.494	21.728	21.494	21.709	23200.0
2022-12-02	AGQ	ETF	28.5	30.45	28.39	30.19	1070000.0
2022-12-02	AGRH	ETF	25.34	25.41	25.27	25.325	1365.0
2022-12-02	AGZ	ETF	107.07	107.44	106.92	107.44	25762.0
2022-12-02	AGZD	ETF	22.935	23.095	22.935	23.025	385200.0
2022-12-02	AHHX	ETF	8.58	8.62	8.571	8.6108	4666.0
2022-12-02	AHYB	ETF	43.937	43.937	43.937	43.937	300.0
2022-12-02	AIA	ETF	57.3	58.7128	57.29	58.5391	24307.0

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

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