PREVIEW / etf_daily / 2021-06-24

all etf daily files

  file:    by_date/etf_daily/2021/2021-06-24.parquet
  size:    90 KB
  rows:    2,382

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-06-24	SPY	ETF	424.89	425.55	424.62	425.1	45110300.0
2021-06-24	QQQ	ETF	349.73	351.46	349.17	349.89	32581605.0
2021-06-24	IWM	ETF	230.12	231.91	228.72	231.89	21732500.0
2021-06-24	DIA	ETF	340.67	342.32	340.37	341.98	3704700.0
2021-06-24	GLD	ETF	167.0	167.23	166.01	166.04	6903400.0
2021-06-24	TLT	ETF	143.42	143.9	143.33	143.5	8788400.0
2021-06-24	AAA	ETF	25.02	25.02	25.02	25.02	73.0
2021-06-24	AAAU	ETF	17.75	17.76	17.65	17.66	352000.0
2021-06-24	AADR	ETF	66.58	66.98	66.58	66.95	1400.0
2021-06-24	AAXJ	ETF	93.79	94.12	93.74	94.06	1304400.0
2021-06-24	ABEQ	ETF	27.291	27.383	27.291	27.383	1800.0
2021-06-24	ACES	ETF	74.76	74.81	73.48	73.77	75100.0
2021-06-24	ACIO	ETF	30.23	30.23	29.96	29.97	84100.0
2021-06-24	ACSI	ETF	49.485	49.5614	49.485	49.5614	377.0
2021-06-24	ACTV	ETF	38.98	39.28	38.98	39.2607	4073.0
2021-06-24	ACTX	ETF	3.2	3.2	3.2	3.2	500.0
2021-06-24	ACVF	ETF	31.63	31.705	31.63	31.705	2200.0
2021-06-24	ACWF	ETF	37.87	37.96	37.83	37.9235	17035.0
2021-06-24	ACWI	ETF	101.1	101.24	101.03	101.17	2866200.0
2021-06-24	ACWV	ETF	102.35	102.67	102.35	102.5	99400.0
2021-06-24	ACWX	ETF	57.8	57.935	57.78	57.91	442610.0
2021-06-24	ADFI	ETF	9.75	9.75	9.74	9.74	5900.0
2021-06-24	ADIV	ETF	18.84	18.84	18.84	18.84	700.0
2021-06-24	ADME	ETF	39.54	39.55	39.46	39.488	60800.0
2021-06-24	ADRE	ETF	56.76	57.2867	56.76	57.174	16049.0
2021-06-24	AESR	ETF	13.46	13.52	13.46	13.499	11700.0
2021-06-24	AFIF	ETF	9.71	9.72	9.71	9.72	8900.0
2021-06-24	AFK	ETF	21.99	22.0	21.86	21.99	17512.0
2021-06-24	AFLG	ETF	25.174	25.174	25.174	25.174	100.0
2021-06-24	AFMC	ETF	25.163	25.288	25.163	25.288	500.0
2021-06-24	AFSM	ETF	26.64	26.64	26.64	26.64	100.0
2021-06-24	AFTY	ETF	23.07	23.099	22.98	23.045	7400.0
2021-06-24	AGG	ETF	115.1	115.17	115.05	115.09	8357900.0
2021-06-24	AGGY	ETF	52.15	52.15	52.08	52.1	41900.0
2021-06-24	AGNG	ETF	30.84	31.19	30.45	30.745	674600.0
2021-06-24	AGOX	ETF	25.97	26.12	25.97	26.068	17300.0
2021-06-24	AGQ	ETF	46.05	46.31	45.23	45.48	452000.0
2021-06-24	AGZ	ETF	118.18	118.2312	118.1601	118.1933	11709.0
2021-06-24	AGZD	ETF	23.525	23.525	23.475	23.485	43000.0
2021-06-24	AIA	ETF	90.72	91.19	90.64	91.14	66442.0
2021-06-24	AIEQ	ETF	41.55	41.79	41.33	41.6	20900.0
2021-06-24	AIQ	ETF	30.23	30.46	30.23	30.32	283927.0
2021-06-24	AIRR	ETF	40.34	41.2	40.34	41.2	20600.0
2021-06-24	AIVI	ETF	43.59	43.74	43.55	43.66	7900.0
2021-06-24	ALTL	ETF	41.1	41.445	40.85	40.94	12552.0
2021-06-24	ALTY	ETF	13.67	13.68	13.64	13.67	29000.0
2021-06-24	AMJ	ETF	19.86	19.86	19.65	19.77	1187950.0
2021-06-24	AMLP	ETF	36.75	36.8	36.29	36.8	2187000.0
2021-06-24	AMNA	ETF	34.4087	34.4087	34.4087	34.4087	0.0
2021-06-24	AMND	ETF	36.4092	36.4092	36.4092	36.4092	6.0

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

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