PREVIEW / etf_daily / 2023-04-27

all etf daily files

  file:    by_date/etf_daily/2023/2023-04-27.parquet
  size:    110 KB
  rows:    2,950

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-04-27	SPY	ETF	407.0	412.69	406.74	412.41	92968400.0
2023-04-27	QQQ	ETF	315.7	320.86	315.05	320.35	65430392.0
2023-04-27	IWM	ETF	172.03	173.86	170.94	173.68	33424100.0
2023-04-27	DIA	ETF	334.18	338.58	333.83	338.2	3066600.0
2023-04-27	GLD	ETF	183.9	184.99	183.38	184.75	9107400.0
2023-04-27	TLT	ETF	105.2	105.27	104.61	104.77	20247600.0
2023-04-27	AAA	ETF	24.6069	24.615	24.6069	24.615	105.0
2023-04-27	AAAU	ETF	19.63	19.75	19.57	19.72	1264300.0
2023-04-27	AADR	ETF	47.33	47.55	47.33	47.55	400.0
2023-04-27	AAPB	ETF	22.665	23.35	22.665	23.35	1496.0
2023-04-27	AAPD	ETF	23.67	23.67	23.19	23.21	200274.0
2023-04-27	AAPU	ETF	23.27	23.95	23.27	23.93	91352.0
2023-04-27	AAXJ	ETF	65.82	66.49	65.79	66.37	209600.0
2023-04-27	ABEQ	ETF	28.51	28.76	28.465	28.76	7100.0
2023-04-27	ACES	ETF	41.951	42.96	41.951	42.73	55800.0
2023-04-27	ACIO	ETF	29.974	30.2	29.92	30.17	19600.0
2023-04-27	ACSI	ETF	43.9899	44.217	43.9899	44.217	142.0
2023-04-27	ACT	ETF	23.66	24.055	23.66	23.9	114068.0
2023-04-27	ACTV	ETF	29.01	29.3	28.818	29.28	9888.0
2023-04-27	ACVF	ETF	31.01	31.596	31.01	31.352	12900.0
2023-04-27	ACWF	ETF	33.65	33.9367	33.6079	33.9367	1490.0
2023-04-27	ACWI	ETF	91.09	92.1	90.99	92.05	5115500.0
2023-04-27	ACWV	ETF	98.36	99.3	98.18	99.25	168800.0
2023-04-27	ACWX	ETF	49.24	49.64	49.19	49.61	812633.0
2023-04-27	ADFI	ETF	8.52	8.52	8.51	8.51	12300.0
2023-04-27	ADIV	ETF	13.57	13.57	13.57	13.57	100.0
2023-04-27	ADME	ETF	34.45	34.86	34.45	34.79	45200.0
2023-04-27	ADPV	ETF	22.37	22.5078	22.37	22.5078	320.0
2023-04-27	AEMB	ETF	37.83	37.83	37.7	37.7	900.0
2023-04-27	AESR	ETF	11.95	12.11	11.95	12.11	19000.0
2023-04-27	AFIF	ETF	8.8299	8.8299	8.78	8.795	7337.0
2023-04-27	AFK	ETF	15.7	15.7	15.62	15.65	12555.0
2023-04-27	AFLG	ETF	23.81	23.979	23.808	23.979	2000.0
2023-04-27	AFMC	ETF	22.65	22.817	22.65	22.817	400.0
2023-04-27	AFSM	ETF	22.66	22.66	22.659	22.659	100.0
2023-04-27	AFTY	ETF	16.047	16.047	16.047	16.047	100.0
2023-04-27	AGG	ETF	99.61	99.63	99.39	99.45	4018300.0
2023-04-27	AGGH	ETF	22.93	22.96	22.93	22.96	883.0
2023-04-27	AGGY	ETF	43.71	43.714	43.62	43.63	51900.0
2023-04-27	AGNG	ETF	27.84	28.07	27.829	27.98	3600.0
2023-04-27	AGOV	ETF	77.18	79.64	77.18	78.325	1841.0
2023-04-27	AGOX	ETF	21.383	21.63	21.383	21.609	6600.0
2023-04-27	AGQ	ETF	32.25	33.27	32.0	33.13	948400.0
2023-04-27	AGZ	ETF	108.4	108.4	108.24	108.27	26798.0
2023-04-27	AGZD	ETF	21.695	21.82	21.695	21.785	122400.0
2023-04-27	AHYB	ETF	44.0	44.07	43.941	44.02	2100.0
2023-04-27	AIA	ETF	58.0	58.64	57.86	58.54	27475.0
2023-04-27	AIEQ	ETF	26.9	27.18	26.79	27.15	48200.0
2023-04-27	AIQ	ETF	23.36	23.6898	23.1601	23.66	82503.0
2023-04-27	AIRR	ETF	44.56	45.57	44.56	45.48	40000.0

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

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