PREVIEW / etf_daily / 2020-02-06

all etf daily files

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

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-06	SPY	ETF	333.91	334.19	332.8	333.98	50359700.0
2020-02-06	QQQ	ETF	228.77	230.25	227.98	230.19	22467077.0
2020-02-06	IWM	ETF	167.89	168.15	166.76	166.93	14768900.0
2020-02-06	DIA	ETF	294.02	294.14	292.45	293.74	2857200.0
2020-02-06	GLD	ETF	147.28	147.63	147.0	147.4	4819800.0
2020-02-06	TLT	ETF	142.18	142.88	142.0	142.65	6683100.0
2020-02-06	AAAU	ETF	15.61	15.63	15.58	15.63	172700.0
2020-02-06	AADR	ETF	55.78	55.96	55.67	55.71	9800.0
2020-02-06	AAXJ	ETF	72.79	72.95	72.36	72.45	805100.0
2020-02-06	ABEQ	ETF	25.12	25.138	25.07	25.07	5400.0
2020-02-06	ACES	ETF	38.5	39.39	38.5	39.05	50600.0
2020-02-06	ACIO	ETF	25.35	25.402	25.33	25.387	79500.0
2020-02-06	ACSI	ETF	36.8275	36.8387	36.8	36.8387	795.0
2020-02-06	ACTX	ETF	7.3751	7.6701	7.0801	7.6701	811.0
2020-02-06	ACWF	ETF	31.72	31.72	31.531	31.5313	10511.0
2020-02-06	ACWI	ETF	81.0	81.04	80.76	80.91	3090100.0
2020-02-06	ACWV	ETF	99.05	99.05	98.7	98.8	555600.0
2020-02-06	ACWX	ETF	49.12	49.14	48.98	49.02	4088115.0
2020-02-06	ADME	ETF	31.31	31.45	31.28	31.38	63900.0
2020-02-06	ADRE	ETF	44.09	44.09	43.73	43.73	3786.0
2020-02-06	AESR	ETF	10.36	10.434	10.36	10.434	800.0
2020-02-06	AFIF	ETF	9.73	9.748	9.73	9.748	1063.0
2020-02-06	AFK	ETF	19.86	19.86	19.7351	19.7351	4812.0
2020-02-06	AFLG	ETF	21.1	21.1	21.086	21.086	100.0
2020-02-06	AFMC	ETF	20.591	20.591	20.591	20.591	100.0
2020-02-06	AFSM	ETF	20.367	20.367	20.367	20.367	100.0
2020-02-06	AFTY	ETF	16.39	16.39	16.04	16.04	3800.0
2020-02-06	AGG	ETF	113.82	113.93	113.77	113.89	6838700.0
2020-02-06	AGGY	ETF	52.99	53.07	52.99	53.07	162700.0
2020-02-06	AGNG	ETF	24.6	24.68	24.36	24.36	12000.0
2020-02-06	AGQ	ETF	31.22	31.26	30.83	31.14	286500.0
2020-02-06	AGZ	ETF	116.73	116.7794	116.68	116.75	26623.0
2020-02-06	AGZD	ETF	24.02	24.065	24.005	24.065	10200.0
2020-02-06	AIA	ETF	65.99	65.99	65.67	65.75	31024.0
2020-02-06	AIEQ	ETF	29.66	29.709	29.583	29.67	37600.0
2020-02-06	AIQ	ETF	19.28	19.42	19.23	19.36	23921.0
2020-02-06	AIRR	ETF	29.245	29.245	28.969	28.98	14200.0
2020-02-06	AIVI	ETF	42.17	42.22	42.15	42.15	3500.0
2020-02-06	ALTY	ETF	14.94	14.95	14.9	14.906	10400.0
2020-02-06	AMJ	ETF	20.94	21.05	20.655	20.74	1692418.0
2020-02-06	AMLP	ETF	41.1	41.1	40.3	40.35	3581380.0
2020-02-06	AMOM	ETF	27.299	27.299	27.299	27.299	100.0
2020-02-06	AMUB	ETF	13.14	13.16	13.035	13.035	4401.0
2020-02-06	AMZA	ETF	41.3	41.7	40.8	40.8	72530.0
2020-02-06	ANGL	ETF	30.13	30.18	30.1	30.16	574800.0
2020-02-06	AOA	ETF	58.92	58.98	58.83	58.97	44400.0
2020-02-06	AOK	ETF	36.77	36.7765	36.7	36.71	48447.0
2020-02-06	AOM	ETF	40.78	40.79	40.6826	40.76	126753.0
2020-02-06	AOR	ETF	48.65	48.65	48.52	48.6	94549.0
2020-02-06	ARCM	ETF	100.09	100.09	100.09	100.09	100.0

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

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