PREVIEW / etf_daily / 2023-05-19

all etf daily files

  file:    by_date/etf_daily/2023/2023-05-19.parquet
  size:    109 KB
  rows:    2,932

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
2023-05-19	SPY	ETF	420.17	420.72	417.35	418.62	103679700.0
2023-05-19	QQQ	ETF	337.49	338.205	335.43	336.51	61554926.0
2023-05-19	IWM	ETF	178.51	178.89	175.25	176.11	34298000.0
2023-05-19	DIA	ETF	335.96	336.45	333.22	334.19	3705100.0
2023-05-19	GLD	ETF	182.25	184.34	181.81	183.64	8432300.0
2023-05-19	TLT	ETF	101.26	101.86	100.93	101.1	29032300.0
2023-05-19	AAA	ETF	24.565	24.565	24.565	24.565	62.0
2023-05-19	AAAU	ETF	19.45	19.67	19.41	19.6	1516500.0
2023-05-19	AADR	ETF	47.71	47.84	47.62	47.69	2300.0
2023-05-19	AAPB	ETF	24.9302	25.0	24.85	24.88	8899.0
2023-05-19	AAPD	ETF	22.2	22.33	22.18	22.3105	103230.0
2023-05-19	AAPU	ETF	25.55	25.55	25.3	25.34	69977.0
2023-05-19	AAXJ	ETF	65.97	66.34	65.92	66.11	633100.0
2023-05-19	ABEQ	ETF	28.52	28.592	28.51	28.568	5000.0
2023-05-19	ACES	ETF	42.88	43.36	42.15	42.32	26000.0
2023-05-19	ACIO	ETF	30.38	30.38	30.22	30.29	32100.0
2023-05-19	ACSI	ETF	44.1689	44.1689	44.1689	44.1689	60.0
2023-05-19	ACT	ETF	24.76	24.76	23.8	24.18	278985.0
2023-05-19	ACTV	ETF	30.04	30.04	29.57	29.6582	7185.0
2023-05-19	ACTX	ETF	0.3	0.3	0.032	0.032	1125.0
2023-05-19	ACVF	ETF	31.94	31.94	31.715	31.735	2700.0
2023-05-19	ACWF	ETF	34.36	34.4	34.2441	34.3282	25318.0
2023-05-19	ACWI	ETF	93.14	93.29	92.74	92.97	1884100.0
2023-05-19	ACWV	ETF	99.03	99.46	99.03	99.2	662600.0
2023-05-19	ACWX	ETF	49.62	49.7	49.49	49.59	1268320.0
2023-05-19	ADFI	ETF	8.42	8.42	8.4	8.401	12200.0
2023-05-19	ADME	ETF	35.06	35.17	34.98	35.04	31900.0
2023-05-19	ADPV	ETF	23.26	23.2601	23.19	23.1914	3889.0
2023-05-19	AESR	ETF	12.165	12.165	12.11	12.14	16000.0
2023-05-19	AFIF	ETF	8.8	8.81	8.75	8.75	10537.0
2023-05-19	AFK	ETF	14.75	14.99	14.75	14.9096	3607.0
2023-05-19	AFLG	ETF	24.084	24.084	24.05	24.081	800.0
2023-05-19	AFMC	ETF	22.91	22.96	22.91	22.938	600.0
2023-05-19	AFTY	ETF	15.62	15.62	15.6	15.618	2000.0
2023-05-19	AGG	ETF	98.13	98.44	98.0	98.08	10285900.0
2023-05-19	AGGY	ETF	43.18	43.28	43.12	43.135	78800.0
2023-05-19	AGNG	ETF	28.255	28.255	28.149	28.19	700.0
2023-05-19	AGOV	ETF	76.455	76.455	76.455	76.455	3.0
2023-05-19	AGOX	ETF	22.22	22.23	22.03	22.07	16900.0
2023-05-19	AGQ	ETF	29.52	30.48	29.19	29.99	1245600.0
2023-05-19	AGZ	ETF	107.77	108.01	107.6795	107.795	110736.0
2023-05-19	AGZD	ETF	21.71	21.81	21.7	21.81	388000.0
2023-05-19	AHOY	ETF	19.4707	19.4707	19.4517	19.4517	151.0
2023-05-19	AHYB	ETF	43.578	43.59	43.515	43.515	500.0
2023-05-19	AIA	ETF	58.98	59.12	58.8965	59.08	20399.0
2023-05-19	AIEQ	ETF	29.17	29.21	28.6	28.67	8800.0
2023-05-19	AIQ	ETF	25.09	25.2	25.0	25.12	227233.0
2023-05-19	AIRR	ETF	49.12	49.19	47.98	48.35	121600.0
2023-05-19	AIVI	ETF	39.94	40.02	39.82	39.97	5800.0
2023-05-19	AIVL	ETF	91.02	91.13	90.47	90.58	2200.0

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

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