PREVIEW / etf_daily / 2022-12-16

all etf daily files

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

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-16	SPY	ETF	385.18	386.58	381.04	383.27	119858000.0
2022-12-16	QQQ	ETF	276.2	277.77	272.61	274.25	68300351.0
2022-12-16	IWM	ETF	173.8	175.11	172.67	174.37	38502400.0
2022-12-16	DIA	ETF	329.29	330.5	326.45	328.97	6672200.0
2022-12-16	GLD	ETF	166.02	166.98	165.84	166.79	5372000.0
2022-12-16	TLT	ETF	106.6	107.83	106.31	107.11	20838300.0
2022-12-16	AAA	ETF	24.41	24.41	24.41	24.41	6.0
2022-12-16	AAAU	ETF	17.7	17.81	17.69	17.79	742200.0
2022-12-16	AADR	ETF	47.32	47.58	47.28	47.58	1000.0
2022-12-16	AAPB	ETF	16.96	16.96	16.5	16.5097	2868.0
2022-12-16	AAPD	ETF	28.89	29.525	28.75	29.3261	285367.0
2022-12-16	AAPU	ETF	18.15	18.339	17.6199	17.78	99475.0
2022-12-16	AAXJ	ETF	65.17	65.44	64.92	64.94	971400.0
2022-12-16	ABEQ	ETF	27.57	27.76	27.48	27.682	62400.0
2022-12-16	ACES	ETF	50.69	51.06	49.33	49.88	282600.0
2022-12-16	ACIO	ETF	29.12	29.15	28.97	29.08	39900.0
2022-12-16	ACSI	ETF	42.425	42.425	42.425	42.425	0.0
2022-12-16	ACT	ETF	23.48	23.79	23.31	23.75	227157.0
2022-12-16	ACTV	ETF	29.1801	29.1801	28.96	29.1	28351.0
2022-12-16	ACTX	ETF	0.3899	0.4	0.3799	0.4	23438.0
2022-12-16	ACVF	ETF	30.0	30.0	29.68	29.898	4200.0
2022-12-16	ACWF	ETF	31.69	31.8145	31.6316	31.8145	8001.0
2022-12-16	ACWI	ETF	85.15	85.52	84.54	84.92	4681100.0
2022-12-16	ACWV	ETF	94.89	95.03	94.43	94.69	140900.0
2022-12-16	ACWX	ETF	45.41	45.58	45.19	45.35	1869999.0
2022-12-16	ADFI	ETF	8.475	8.49	8.475	8.485	6700.0
2022-12-16	ADIV	ETF	13.09	13.09	13.09	13.09	100.0
2022-12-16	ADME	ETF	34.088	34.145	34.02	34.08	36900.0
2022-12-16	ADPV	ETF	25.15	25.15	25.12	25.12	22255.0
2022-12-16	ADRE	ETF	37.93	37.93	37.56	37.56	3250.0
2022-12-16	AESR	ETF	11.43	11.49	11.386	11.48	8900.0
2022-12-16	AFIF	ETF	8.795	8.82	8.78	8.8	22311.0
2022-12-16	AFK	ETF	16.7	16.7	16.59	16.61	4820.0
2022-12-16	AFLG	ETF	23.41	23.41	23.383	23.383	100.0
2022-12-16	AFMC	ETF	22.25	22.271	22.25	22.271	100.0
2022-12-16	AFSM	ETF	22.67	22.688	22.67	22.688	200.0
2022-12-16	AFTY	ETF	16.223	16.223	16.223	16.223	100.0
2022-12-16	AGG	ETF	98.96	99.52	98.94	99.35	7546100.0
2022-12-16	AGGH	ETF	22.9	22.9	22.8844	22.8844	386.0
2022-12-16	AGGY	ETF	43.72	43.91	43.59	43.81	1467900.0
2022-12-16	AGNG	ETF	26.033	26.18	26.0	26.18	800.0
2022-12-16	AGOV	ETF	81.96	81.96	81.01	81.7236	405.0
2022-12-16	AGOX	ETF	20.45	20.68	20.45	20.61	30400.0
2022-12-16	AGQ	ETF	29.63	30.28	29.55	30.14	1156900.0
2022-12-16	AGZ	ETF	107.08	107.43	107.0699	107.335	20390.0
2022-12-16	AGZD	ETF	21.875	21.95	21.755	21.87	124800.0
2022-12-16	AHHX	ETF	8.44	8.52	8.44	8.4908	3021.0
2022-12-16	AHYB	ETF	43.47	43.47	43.369	43.41	1400.0
2022-12-16	AIA	ETF	56.78	57.07	56.5407	56.59	43366.0
2022-12-16	AIEQ	ETF	29.1	29.3	28.85	29.03	12400.0

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

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