PREVIEW / etf_daily / 2020-02-24

all etf daily files

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

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-24	SPY	ETF	323.14	333.56	321.24	322.42	161088400.0
2020-02-24	QQQ	ETF	221.84	224.25	220.26	221.39	84522551.0
2020-02-24	IWM	ETF	161.86	167.06	161.1	162.07	28239500.0
2020-02-24	DIA	ETF	280.33	282.78	278.97	279.56	6595200.0
2020-02-24	GLD	ETF	158.5	158.53	155.36	156.09	27171000.0
2020-02-24	TLT	ETF	150.83	150.96	150.0	150.25	15929300.0
2020-02-24	AAAU	ETF	16.8	16.8	16.47	16.56	306600.0
2020-02-24	AADR	ETF	54.59	54.98	54.4	54.53	8100.0
2020-02-24	AAXJ	ETF	68.67	69.44	68.67	68.98	1900600.0
2020-02-24	ABEQ	ETF	24.695	24.715	24.629	24.633	4400.0
2020-02-24	ACES	ETF	40.56	41.783	40.51	41.49	107400.0
2020-02-24	ACIO	ETF	24.77	24.82	24.48	24.745	110300.0
2020-02-24	ACSI	ETF	36.14	36.515	36.14	36.2771	2653.0
2020-02-24	ACTX	ETF	7.2146	7.2146	6.8264	6.8264	172.0
2020-02-24	ACWF	ETF	30.37	30.63	30.37	30.43	8744.0
2020-02-24	ACWI	ETF	77.47	78.22	77.43	77.6	8362400.0
2020-02-24	ACWV	ETF	96.52	97.35	96.47	96.65	355800.0
2020-02-24	ACWX	ETF	46.29	46.69	46.24	46.4	4278026.0
2020-02-24	ADME	ETF	30.79	31.18	30.79	31.03	22600.0
2020-02-24	ADRE	ETF	41.03	41.26	40.78	41.0601	43987.0
2020-02-24	AESR	ETF	10.24	10.24	10.11	10.11	11500.0
2020-02-24	AFIF	ETF	9.8	9.8	9.79	9.79	986.0
2020-02-24	AFK	ETF	19.06	19.07	18.9	18.9	12073.0
2020-02-24	AFLG	ETF	20.46	20.46	20.378	20.378	100.0
2020-02-24	AFMC	ETF	20.101	20.101	20.101	20.101	100.0
2020-02-24	AFSM	ETF	19.818	19.818	19.818	19.818	100.0
2020-02-24	AFTY	ETF	16.1	16.15	15.94	16.075	50800.0
2020-02-24	AGG	ETF	115.43	115.43	115.23	115.27	7490100.0
2020-02-24	AGGY	ETF	53.71	53.73	53.66	53.68	131000.0
2020-02-24	AGNG	ETF	23.94	24.225	23.93	24.149	2700.0
2020-02-24	AGQ	ETF	34.62	35.13	33.64	34.01	957400.0
2020-02-24	AGZ	ETF	117.96	118.005	117.8501	117.99	27248.0
2020-02-24	AGZD	ETF	23.965	24.075	23.965	24.035	12000.0
2020-02-24	AIA	ETF	61.85	62.51	61.85	62.34	37143.0
2020-02-24	AIEQ	ETF	28.89	29.062	28.68	28.83	79000.0
2020-02-24	AIQ	ETF	18.58	18.72	18.34	18.62	30119.0
2020-02-24	AIRR	ETF	28.24	28.36	28.114	28.36	3300.0
2020-02-24	AIVI	ETF	39.72	40.1	39.72	39.84	165200.0
2020-02-24	ALTY	ETF	14.84	14.84	14.685	14.73	53000.0
2020-02-24	AMJ	ETF	19.7	19.74	19.39	19.59	2074294.0
2020-02-24	AMLP	ETF	37.25	37.5	36.8	37.3	5038180.0
2020-02-24	AMOM	ETF	26.66	26.66	26.631	26.631	300.0
2020-02-24	AMUB	ETF	12.41	12.41	12.3531	12.3531	1929.0
2020-02-24	AMZA	ETF	37.1	37.3	36.1	36.4	142690.0
2020-02-24	ANGL	ETF	30.16	30.16	30.04	30.05	1063000.0
2020-02-24	AOA	ETF	57.16	57.35	56.95	57.06	105300.0
2020-02-24	AOK	ETF	36.65	36.65	36.5	36.52	113206.0
2020-02-24	AOM	ETF	40.41	40.4366	40.25	40.26	250923.0
2020-02-24	AOR	ETF	47.48	47.731	47.36	47.55	180430.0
2020-02-24	ARCM	ETF	100.11	100.11	100.11	100.11	200.0

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

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