PREVIEW / etf_daily / 2020-02-25

all etf daily files

  file:    by_date/etf_daily/2020/2020-02-25.parquet
  size:    75 KB
  rows:    1,957

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
2020-02-25	SPY	ETF	323.94	324.61	311.69	312.65	218913200.0
2020-02-25	QQQ	ETF	223.19	223.9879	214.74	215.37	97742982.0
2020-02-25	IWM	ETF	162.52	162.76	155.96	156.31	45047000.0
2020-02-25	DIA	ETF	280.8	281.36	269.88	270.7	9903700.0
2020-02-25	GLD	ETF	155.12	156.08	152.91	153.3	28091500.0
2020-02-25	TLT	ETF	150.21	151.76	150.14	151.05	20802900.0
2020-02-25	AAAU	ETF	16.45	16.53	16.23	16.25	123000.0
2020-02-25	AADR	ETF	54.43	54.55	52.92	52.92	18800.0
2020-02-25	AAXJ	ETF	70.11	70.25	68.78	68.78	1235600.0
2020-02-25	ABEQ	ETF	24.59	24.59	24.081	24.081	3700.0
2020-02-25	ACES	ETF	42.47	42.47	39.84	39.92	99900.0
2020-02-25	ACIO	ETF	24.51	24.533	24.4	24.465	26500.0
2020-02-25	ACSI	ETF	36.68	36.68	35.1647	35.27	3774.0
2020-02-25	ACTX	ETF	7.0801	7.5249	6.8264	7.5226	184.0
2020-02-25	ACWF	ETF	30.47	30.47	29.64	29.6738	15793.0
2020-02-25	ACWI	ETF	77.96	78.14	75.61	75.61	7897800.0
2020-02-25	ACWV	ETF	97.21	97.21	95.02	95.1	424100.0
2020-02-25	ACWX	ETF	46.72	46.773	45.71	45.73	3966140.0
2020-02-25	ADME	ETF	30.987	31.023	30.65	30.66	24400.0
2020-02-25	ADRE	ETF	41.52	41.71	40.57	40.64	6961.0
2020-02-25	AESR	ETF	10.02	10.048	9.75	9.792	67100.0
2020-02-25	AFIF	ETF	9.83	9.83	9.79	9.8024	33053.0
2020-02-25	AFK	ETF	18.77	18.7915	18.5	18.51	18359.0
2020-02-25	AFMC	ETF	19.386	19.386	19.386	19.386	100.0
2020-02-25	AFSM	ETF	19.079	19.079	19.079	19.079	100.0
2020-02-25	AFTY	ETF	16.26	16.26	16.052	16.074	4600.0
2020-02-25	AGG	ETF	115.28	115.58	115.27	115.47	7474600.0
2020-02-25	AGGY	ETF	53.56	53.66	53.555	53.6	685000.0
2020-02-25	AGNG	ETF	24.22	24.22	23.5	23.665	14000.0
2020-02-25	AGQ	ETF	32.83	33.15	31.12	31.23	547400.0
2020-02-25	AGZ	ETF	117.9	118.222	117.9	118.13	16037.0
2020-02-25	AGZD	ETF	23.975	23.975	23.92	23.92	6000.0
2020-02-25	AIA	ETF	63.47	63.52	62.26	62.26	43817.0
2020-02-25	AIEQ	ETF	29.03	29.03	27.84	27.9	91500.0
2020-02-25	AIQ	ETF	18.71	18.8342	18.0	18.075	55526.0
2020-02-25	AIRR	ETF	28.18	28.271	27.37	27.445	8400.0
2020-02-25	AIVI	ETF	40.03	40.03	39.11	39.11	12800.0
2020-02-25	ALTY	ETF	14.8	14.8	14.2	14.26	34700.0
2020-02-25	AMJ	ETF	19.74	19.74	18.64	18.75	4048747.0
2020-02-25	AMLP	ETF	37.35	37.45	35.45	35.45	9833460.0
2020-02-25	AMOM	ETF	25.911	25.911	25.911	25.911	100.0
2020-02-25	AMUB	ETF	12.1344	12.1344	11.8402	11.8402	967.0
2020-02-25	AMZA	ETF	36.7	36.88	34.1	34.3	180030.0
2020-02-25	ANGL	ETF	30.15	30.21	29.66	29.73	3137000.0
2020-02-25	AOA	ETF	57.19	57.2	55.82	55.93	116400.0
2020-02-25	AOK	ETF	36.56	36.599	36.1928	36.27	158795.0
2020-02-25	AOM	ETF	40.26	40.37	39.85	39.85	265141.0
2020-02-25	AOR	ETF	47.62	47.64	46.7292	46.81	173689.0
2020-02-25	ARGT	ETF	25.29	25.45	24.01	24.03	44800.0
2020-02-25	ARKF	ETF	26.02	26.064	24.962	25.02	94400.0

> showing 50 of 1,957 rows — these rows as CSV

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