PREVIEW / etf_daily / 2023-11-20

all etf daily files

  file:    by_date/etf_daily/2023/2023-11-20.parquet
  size:    112 KB
  rows:    3,140

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-11-20	SPY	ETF	450.53	455.13	450.52	454.26	69936200.0
2023-11-20	QQQ	ETF	386.05	391.41	386.05	390.74	44536669.0
2023-11-20	IWM	ETF	178.52	179.65	177.74	179.33	26665100.0
2023-11-20	DIA	ETF	349.1	352.24	349.07	351.52	2904300.0
2023-11-20	GLD	ETF	182.32	183.48	182.23	183.37	5389300.0
2023-11-20	TLT	ETF	89.62	90.66	89.61	90.59	40477800.0
2023-11-20	AAA	ETF	24.955	24.955	24.85	24.915	1600.0
2023-11-20	AAAU	ETF	19.48	19.6	19.47	19.59	1340000.0
2023-11-20	AADR	ETF	51.81	53.01	51.81	53.01	4500.0
2023-11-20	AAPB	ETF	26.99	27.45	26.99	27.38	11183.0
2023-11-20	AAPD	ETF	20.57	20.57	20.3401	20.38	203801.0
2023-11-20	AAPU	ETF	27.29	27.71	27.29	27.65	95917.0
2023-11-20	AAXJ	ETF	65.74	66.39	65.74	66.3	780400.0
2023-11-20	ABEQ	ETF	27.45	27.6	27.43	27.581	5300.0
2023-11-20	ACES	ETF	30.84	31.59	30.56	31.285	59000.0
2023-11-20	ACIO	ETF	32.054	32.27	32.04	32.23	67800.0
2023-11-20	ACSI	ETF	47.621	47.621	47.621	47.621	100.0
2023-11-20	ACT	ETF	27.53	27.78	27.45	27.78	259649.0
2023-11-20	ACTV	ETF	29.635	29.76	29.58	29.75	8300.0
2023-11-20	ACVF	ETF	34.555	34.74	34.555	34.702	1300.0
2023-11-20	ACWF	ETF	36.275	36.42	36.275	36.3801	3918.0
2023-11-20	ACWI	ETF	96.89	97.82	96.89	97.63	3102200.0
2023-11-20	ACWV	ETF	97.29	97.92	97.29	97.84	173600.0
2023-11-20	ACWX	ETF	48.96	49.33	48.96	49.27	1619800.0
2023-11-20	ADFI	ETF	8.315	8.32	8.3	8.315	2900.0
2023-11-20	ADIV	ETF	13.98	13.98	13.98	13.98	100.0
2023-11-20	ADME	ETF	36.67	37.14	36.67	37.09	6700.0
2023-11-20	ADPV	ETF	23.6	23.73	23.6	23.6431	5539.0
2023-11-20	AEMB	ETF	36.442	36.595	36.442	36.595	400.0
2023-11-20	AESR	ETF	13.01	13.1	12.99	13.06	307200.0
2023-11-20	AETH	ETF	30.5	30.89	30.47	30.6475	1914.0
2023-11-20	AFIF	ETF	8.9	8.94	8.9	8.93	127300.0
2023-11-20	AFK	ETF	13.66	14.04	13.66	13.88	8700.0
2023-11-20	AFLG	ETF	26.22	26.27	26.203	26.203	1800.0
2023-11-20	AFMC	ETF	24.55	24.55	24.475	24.541	900.0
2023-11-20	AFSM	ETF	24.48	24.636	24.48	24.636	900.0
2023-11-20	AFTY	ETF	14.423	14.423	14.423	14.423	200.0
2023-11-20	AGG	ETF	95.07	95.42	95.07	95.4	10051600.0
2023-11-20	AGGH	ETF	21.4287	21.49	21.39	21.43	9706.0
2023-11-20	AGGY	ETF	42.24	42.34	42.18	42.33	128000.0
2023-11-20	AGNG	ETF	26.25	26.5	26.14	26.46	12400.0
2023-11-20	AGOX	ETF	23.64	23.64	23.55	23.57	32200.0
2023-11-20	AGQ	ETF	26.76	27.21	26.66	26.89	738700.0
2023-11-20	AGZ	ETF	106.41	106.49	106.3	106.44	23800.0
2023-11-20	AGZD	ETF	22.3	22.37	22.3	22.34	26900.0
2023-11-20	AHLT	ETF	24.65	24.65	24.09	24.4591	11094.0
2023-11-20	AHOY	ETF	20.56	20.65	20.56	20.6468	284.0
2023-11-20	AHYB	ETF	44.008	44.1	44.008	44.094	9500.0
2023-11-20	AIA	ETF	58.67	59.3	58.67	59.22	14700.0
2023-11-20	AIEQ	ETF	30.82	30.986	30.71	30.93	6300.0

> showing 50 of 3,140 rows — these rows as CSV

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