PREVIEW / etf_daily / 2021-09-24

all etf daily files

  file:    by_date/etf_daily/2021/2021-09-24.parquet
  size:    93 KB
  rows:    2,483

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-24	SPY	ETF	441.44	444.67	441.21	443.91	62094800.0
2021-09-24	QQQ	ETF	370.65	373.76	370.27	373.33	36056800.0
2021-09-24	IWM	ETF	223.02	224.36	221.84	223.05	28866000.0
2021-09-24	DIA	ETF	346.5	348.43	346.31	347.87	3121600.0
2021-09-24	GLD	ETF	163.0	164.0	162.74	163.3	6937500.0
2021-09-24	TLT	ETF	147.84	147.85	146.74	146.91	20203900.0
2021-09-24	AAA	ETF	25.015	25.015	25.015	25.015	18.0
2021-09-24	AAAU	ETF	17.34	17.44	17.31	17.38	211200.0
2021-09-24	AADR	ETF	65.63	65.72	65.5	65.6	1700.0
2021-09-24	AAXJ	ETF	85.87	85.93	85.46	85.52	1287900.0
2021-09-24	ABEQ	ETF	27.149	27.149	27.088	27.088	300.0
2021-09-24	ACES	ETF	67.94	68.13	67.13	67.16	58600.0
2021-09-24	ACIO	ETF	30.62	30.745	30.62	30.72	59200.0
2021-09-24	ACSI	ETF	50.66	50.6779	50.66	50.6779	106.0
2021-09-24	ACT	ETF	21.67	22.055	20.796	21.85	159571.0
2021-09-24	ACTV	ETF	37.97	38.07	37.92	38.0584	6827.0
2021-09-24	ACTX	ETF	0.9	0.9049	0.9	0.9049	515.0
2021-09-24	ACVF	ETF	32.96	33.055	32.921	33.044	3100.0
2021-09-24	ACWF	ETF	38.06	38.16	38.06	38.1407	12008.0
2021-09-24	ACWI	ETF	102.56	103.06	102.56	102.95	1413700.0
2021-09-24	ACWV	ETF	104.94	105.49	104.94	105.21	80200.0
2021-09-24	ACWX	ETF	56.62	56.75	56.58	56.64	503402.0
2021-09-24	ADFI	ETF	9.72	9.725	9.72	9.725	1000.0
2021-09-24	ADIV	ETF	17.1	17.1	17.05	17.05	700.0
2021-09-24	ADME	ETF	40.73	40.82	40.63	40.78	21900.0
2021-09-24	ADRE	ETF	49.24	49.245	48.92	48.975	7987.0
2021-09-24	AESR	ETF	13.98	14.12	13.98	14.08	25500.0
2021-09-24	AFIF	ETF	9.64	9.65	9.64	9.645	33342.0
2021-09-24	AFK	ETF	20.74	20.89	20.6468	20.86	9859.0
2021-09-24	AFLG	ETF	26.218	26.218	26.218	26.218	2300.0
2021-09-24	AFMC	ETF	25.603	25.603	25.603	25.603	1400.0
2021-09-24	AFSM	ETF	26.393	26.393	26.393	26.393	1200.0
2021-09-24	AFTY	ETF	20.07	20.083	20.055	20.083	3400.0
2021-09-24	AGG	ETF	115.5	115.51	115.32	115.41	4461900.0
2021-09-24	AGGY	ETF	52.27	52.29	52.24	52.25	52600.0
2021-09-24	AGNG	ETF	30.21	30.21	30.097	30.097	1800.0
2021-09-24	AGOV	ETF	99.99	100.0199	99.82	99.895	13984.0
2021-09-24	AGOX	ETF	26.377	26.5	26.35	26.444	21800.0
2021-09-24	AGQ	ETF	32.04	33.07	31.97	32.75	860500.0
2021-09-24	AGZ	ETF	118.55	118.6044	118.5	118.5	28613.0
2021-09-24	AGZD	ETF	23.45	23.45	23.4	23.45	21000.0
2021-09-24	AIA	ETF	78.63	78.91	78.41	78.45	123856.0
2021-09-24	AIEQ	ETF	42.98	43.044	42.673	43.02	10000.0
2021-09-24	AIQ	ETF	31.31	31.47	31.24	31.435	12655.0
2021-09-24	AIRR	ETF	41.08	41.5	41.06	41.31	15800.0
2021-09-24	AIVI	ETF	41.34	41.36	41.33	41.35	2300.0
2021-09-24	ALTL	ETF	42.22	42.42	42.14	42.24	316499.0
2021-09-24	ALTY	ETF	13.55	13.55	13.525	13.535	5800.0
2021-09-24	AMJ	ETF	17.93	18.1	17.89	17.93	905281.0
2021-09-24	AMLP	ETF	32.96	33.23	32.8	32.85	1264900.0

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

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