PREVIEW / etf_daily / 2020-02-10

all etf daily files

  file:    by_date/etf_daily/2020/2020-02-10.parquet
  size:    74 KB
  rows:    1,939

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-10	SPY	ETF	331.23	334.75	331.19	334.68	42070000.0
2020-02-10	QQQ	ETF	228.43	231.98	228.38	231.97	21478925.0
2020-02-10	IWM	ETF	164.56	165.89	164.46	165.81	11428800.0
2020-02-10	DIA	ETF	290.2	292.96	290.16	292.95	2877700.0
2020-02-10	GLD	ETF	148.21	148.45	147.91	148.17	5793600.0
2020-02-10	TLT	ETF	145.1	145.25	144.68	144.83	6699300.0
2020-02-10	AAAU	ETF	15.71	15.73	15.68	15.69	63600.0
2020-02-10	AADR	ETF	55.11	55.69	54.94	55.6	10600.0
2020-02-10	AAXJ	ETF	71.62	72.17	71.62	72.17	2484100.0
2020-02-10	ABEQ	ETF	25.21	25.21	25.064	25.064	2500.0
2020-02-10	ACES	ETF	38.92	39.42	38.92	39.39	43000.0
2020-02-10	ACIO	ETF	25.27	25.36	25.27	25.347	13600.0
2020-02-10	ACSI	ETF	36.81	36.8943	36.8092	36.8943	1431.0
2020-02-10	ACTX	ETF	7.6701	8.2011	7.6701	7.6701	38.0
2020-02-10	ACWF	ETF	31.3254	31.3992	31.284	31.3992	6313.0
2020-02-10	ACWI	ETF	80.15	80.8	80.15	80.78	1832600.0
2020-02-10	ACWV	ETF	98.37	98.85	98.37	98.85	189600.0
2020-02-10	ACWX	ETF	48.44	48.66	48.44	48.66	622052.0
2020-02-10	ADME	ETF	31.34	31.44	31.34	31.43	32700.0
2020-02-10	ADRE	ETF	42.9683	43.1498	42.9296	43.1104	6060.0
2020-02-10	AESR	ETF	10.42	10.456	10.42	10.456	400.0
2020-02-10	AFIF	ETF	9.73	9.77	9.73	9.765	8258.0
2020-02-10	AFK	ETF	19.41	19.45	19.4	19.43	12555.0
2020-02-10	AFTY	ETF	15.96	16.13	15.96	16.13	1600.0
2020-02-10	AGG	ETF	114.44	114.44	114.29	114.35	8187800.0
2020-02-10	AGGY	ETF	53.29	53.3	53.228	53.27	173900.0
2020-02-10	AGNG	ETF	24.3	24.3	24.26	24.3	2900.0
2020-02-10	AGQ	ETF	30.99	31.24	30.81	31.03	262100.0
2020-02-10	AGZ	ETF	117.13	117.16	117.0268	117.11	35573.0
2020-02-10	AGZD	ETF	24.025	24.07	23.965	24.02	5600.0
2020-02-10	AIA	ETF	64.83	65.33	64.83	65.25	42123.0
2020-02-10	AIEQ	ETF	29.4	29.68	29.29	29.68	30600.0
2020-02-10	AIQ	ETF	19.05	19.38	19.05	19.38	24267.0
2020-02-10	AIRR	ETF	28.44	28.72	28.44	28.72	7100.0
2020-02-10	AIVI	ETF	41.54	41.7	41.54	41.7	7200.0
2020-02-10	ALTY	ETF	14.86	14.893	14.85	14.885	4900.0
2020-02-10	AMJ	ETF	20.45	20.4906	20.11	20.17	2239375.0
2020-02-10	AMLP	ETF	39.9	40.0	39.25	39.3	5036520.0
2020-02-10	AMOM	ETF	27.336	27.336	27.336	27.336	100.0
2020-02-10	AMUB	ETF	12.675	12.675	12.675	12.675	3.0
2020-02-10	AMZA	ETF	40.3	40.3	39.1	39.2	125840.0
2020-02-10	ANGL	ETF	30.14	30.16	30.01	30.1	694100.0
2020-02-10	AOA	ETF	58.55	58.88	58.53	58.88	41500.0
2020-02-10	AOK	ETF	36.8	36.83	36.75	36.83	103535.0
2020-02-10	AOM	ETF	40.68	40.81	40.66	40.81	166447.0
2020-02-10	AOR	ETF	48.3	48.55	48.3	48.51	110426.0
2020-02-10	ARGT	ETF	25.66	25.87	25.62	25.77	15800.0
2020-02-10	ARKF	ETF	26.03	26.39	26.03	26.37	57300.0
2020-02-10	ARKG	ETF	34.93	35.73	34.82	35.73	263200.0
2020-02-10	ARKK	ETF	56.29	57.02	56.22	56.89	531600.0

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

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