PREVIEW / etf_daily / 2021-09-23

all etf daily files

  file:    by_date/etf_daily/2021/2021-09-23.parquet
  size:    94 KB
  rows:    2,500

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
2021-09-23	SPY	ETF	439.85	444.89	439.6	443.18	76396000.0
2021-09-23	QQQ	ETF	370.76	374.04	370.099	372.98	44652002.0
2021-09-23	IWM	ETF	222.18	225.65	221.56	224.81	31057800.0
2021-09-23	DIA	ETF	344.81	348.67	344.53	347.56	5592200.0
2021-09-23	GLD	ETF	164.1	164.2	163.27	163.51	8451900.0
2021-09-23	TLT	ETF	150.42	150.45	148.34	148.36	23853300.0
2021-09-23	AAA	ETF	25.015	25.015	25.015	25.015	429.0
2021-09-23	AAAU	ETF	17.46	17.46	17.37	17.39	252200.0
2021-09-23	AADR	ETF	65.66	66.62	65.66	66.62	3000.0
2021-09-23	AAXJ	ETF	86.58	86.79	86.28	86.7	1169200.0
2021-09-23	ABEQ	ETF	27.23	27.24	27.125	27.125	4000.0
2021-09-23	ACES	ETF	68.7	68.91	67.95	68.56	46700.0
2021-09-23	ACIO	ETF	30.5	30.74	30.5	30.67	82800.0
2021-09-23	ACSI	ETF	50.72	50.72	50.6085	50.6085	218.0
2021-09-23	ACT	ETF	21.35	22.12	21.35	21.78	370751.0
2021-09-23	ACTV	ETF	37.89	38.15	37.89	37.9871	2929.0
2021-09-23	ACTX	ETF	0.88	0.9	0.87	0.9	1537.0
2021-09-23	ACVF	ETF	32.67	33.125	32.67	33.08	11800.0
2021-09-23	ACWF	ETF	38.15	38.465	38.15	38.27	23787.0
2021-09-23	ACWI	ETF	102.65	103.57	102.65	103.24	1882600.0
2021-09-23	ACWV	ETF	105.09	105.81	105.09	105.44	124900.0
2021-09-23	ACWX	ETF	56.99	57.28	56.9732	57.2	668844.0
2021-09-23	ADFI	ETF	9.78	9.78	9.745	9.745	3600.0
2021-09-23	ADIV	ETF	17.59	17.615	17.59	17.615	300.0
2021-09-23	ADME	ETF	40.52	40.841	40.52	40.72	27200.0
2021-09-23	ADRE	ETF	49.6	49.7479	49.315	49.64	10005.0
2021-09-23	AEMB	ETF	49.87	49.87	49.61	49.61	12000.0
2021-09-23	AESR	ETF	13.93	14.12	13.93	14.08	14100.0
2021-09-23	AFIF	ETF	9.65	9.65	9.6208	9.635	15875.0
2021-09-23	AFK	ETF	20.79	20.9993	20.5	20.77	4796.0
2021-09-23	AFLG	ETF	26.26	26.29	26.203	26.203	2900.0
2021-09-23	AFMC	ETF	25.71	25.71	25.639	25.639	1800.0
2021-09-23	AFSM	ETF	26.52	26.52	26.444	26.444	600.0
2021-09-23	AFTY	ETF	19.89	19.938	19.83	19.938	3000.0
2021-09-23	AGG	ETF	115.93	115.94	115.57	115.61	8265000.0
2021-09-23	AGGY	ETF	52.61	52.65	52.45	52.48	65800.0
2021-09-23	AGNG	ETF	30.426	30.49	30.361	30.42	2400.0
2021-09-23	AGOV	ETF	100.23	100.23	100.23	100.23	10.0
2021-09-23	AGOX	ETF	26.5	26.61	26.3	26.57	75200.0
2021-09-23	AGQ	ETF	33.46	33.83	33.25	33.34	879700.0
2021-09-23	AGZ	ETF	118.91	118.91	118.7	118.74	15405.0
2021-09-23	AGZD	ETF	23.445	23.47	23.415	23.445	48800.0
2021-09-23	AIA	ETF	79.39	79.79	79.37	79.64	415885.0
2021-09-23	AIEQ	ETF	42.94	43.14	42.75	43.13	40400.0
2021-09-23	AIQ	ETF	31.33	31.62	31.3	31.62	17545.0
2021-09-23	AIRR	ETF	40.68	41.575	40.68	41.33	25500.0
2021-09-23	AIVI	ETF	42.84	42.85	42.78	42.79	2500.0
2021-09-23	ALTL	ETF	42.26	42.4831	42.17	42.25	83791.0
2021-09-23	ALTY	ETF	13.59	13.59	13.52	13.52	7000.0
2021-09-23	AMJ	ETF	17.64	18.095	17.6171	18.07	450406.0

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

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