PREVIEW / etf_daily / 2020-02-19

all etf daily files

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

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-19	SPY	ETF	337.79	339.08	337.48	338.34	48814700.0
2020-02-19	QQQ	ETF	236.07	237.47	235.85	236.98	22230464.0
2020-02-19	IWM	ETF	168.17	169.14	167.53	168.4	11084600.0
2020-02-19	DIA	ETF	293.77	294.72	293.39	294.1	1474400.0
2020-02-19	GLD	ETF	151.0	151.82	150.82	151.79	9269800.0
2020-02-19	TLT	ETF	145.12	145.62	144.98	145.53	5707700.0
2020-02-19	AAAU	ETF	16.01	16.09	15.98	16.09	80100.0
2020-02-19	AADR	ETF	57.0	57.51	56.64	57.5	14400.0
2020-02-19	AAXJ	ETF	73.12	73.27	73.04	73.08	492000.0
2020-02-19	ABEQ	ETF	25.2	25.2	25.094	25.094	2600.0
2020-02-19	ACES	ETF	42.56	43.529	42.52	43.52	196000.0
2020-02-19	ACIO	ETF	25.284	25.296	25.25	25.25	2800.0
2020-02-19	ACSI	ETF	37.66	37.66	37.6352	37.6352	918.0
2020-02-19	ACTX	ETF	7.4341	7.6701	6.8264	7.0376	422.0
2020-02-19	ACWF	ETF	31.8	31.891	31.8	31.812	6380.0
2020-02-19	ACWI	ETF	81.4	81.61	81.36	81.46	2220900.0
2020-02-19	ACWV	ETF	99.7	99.7	99.34	99.35	204100.0
2020-02-19	ACWX	ETF	48.8	48.897	48.78	48.83	633418.0
2020-02-19	ADME	ETF	31.91	31.916	31.857	31.857	1800.0
2020-02-19	ADRE	ETF	43.67	43.9248	43.67	43.875	7853.0
2020-02-19	AFIF	ETF	9.57	9.75	9.57	9.735	28355.0
2020-02-19	AFK	ETF	19.78	19.78	19.665	19.665	11454.0
2020-02-19	AFSM	ETF	20.641	20.641	20.641	20.641	100.0
2020-02-19	AFTY	ETF	16.45	16.53	16.45	16.49	2300.0
2020-02-19	AGG	ETF	114.4	114.47	114.33	114.41	3692200.0
2020-02-19	AGGY	ETF	53.33	53.37	53.3	53.36	190500.0
2020-02-19	AGNG	ETF	24.81	25.065	24.72	24.741	10300.0
2020-02-19	AGQ	ETF	32.61	33.44	32.48	33.44	402400.0
2020-02-19	AGZ	ETF	117.0	117.11	117.0	117.09	17985.0
2020-02-19	AGZD	ETF	24.075	24.11	24.025	24.07	35200.0
2020-02-19	AIA	ETF	66.1	66.26	66.1	66.1731	14566.0
2020-02-19	AIEQ	ETF	30.2	30.334	30.2	30.24	23600.0
2020-02-19	AIQ	ETF	19.95	19.97	19.89	19.9209	11021.0
2020-02-19	AIRR	ETF	29.169	29.19	29.09	29.09	21100.0
2020-02-19	AIVI	ETF	41.65	41.68	41.62	41.64	6900.0
2020-02-19	ALTY	ETF	15.1	15.1	14.985	14.985	6100.0
2020-02-19	AMJ	ETF	20.64	20.71	20.39	20.42	1855753.0
2020-02-19	AMLP	ETF	39.25	39.35	38.75	38.85	3991220.0
2020-02-19	AMOM	ETF	28.07	28.07	28.07	28.07	100.0
2020-02-19	AMUB	ETF	12.86	12.8814	12.85	12.8814	8050.0
2020-02-19	AMZA	ETF	40.5	40.5	39.73	39.9	80000.0
2020-02-19	ANGL	ETF	30.43	30.43	30.38	30.39	424300.0
2020-02-19	AOA	ETF	59.15	59.32	59.15	59.26	58900.0
2020-02-19	AOK	ETF	36.86	36.96	36.86	36.94	51487.0
2020-02-19	AOM	ETF	40.95	40.998	40.92	40.92	79293.0
2020-02-19	AOR	ETF	48.73	48.862	48.72	48.76	101915.0
2020-02-19	ARGT	ETF	26.19	26.47	26.09	26.35	40200.0
2020-02-19	ARKF	ETF	27.21	27.5	27.157	27.38	102200.0
2020-02-19	ARKG	ETF	37.22	37.92	36.83	37.63	325600.0
2020-02-19	ARKK	ETF	60.0	60.73	59.68	60.37	650500.0

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

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