PREVIEW / etf_daily / 2020-02-07

all etf daily files

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

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-07	SPY	ETF	332.82	333.99	331.6	332.2	64139400.0
2020-02-07	QQQ	ETF	229.16	230.44	228.54	229.2	25884933.0
2020-02-07	IWM	ETF	166.29	166.36	164.4	164.88	18029600.0
2020-02-07	DIA	ETF	292.76	292.81	290.66	291.19	3839300.0
2020-02-07	GLD	ETF	147.83	148.18	147.34	147.79	6379300.0
2020-02-07	TLT	ETF	144.22	144.74	143.87	144.43	11374800.0
2020-02-07	AAAU	ETF	15.67	15.69	15.61	15.67	151700.0
2020-02-07	AADR	ETF	55.4	55.46	55.12	55.12	3600.0
2020-02-07	AAXJ	ETF	71.7	71.79	71.28	71.4	508500.0
2020-02-07	ABEQ	ETF	25.003	25.033	24.92	24.967	176100.0
2020-02-07	ACES	ETF	38.85	38.936	38.536	38.71	27600.0
2020-02-07	ACIO	ETF	25.335	25.335	25.27	25.297	31700.0
2020-02-07	ACSI	ETF	36.7	36.78	36.695	36.7211	10486.0
2020-02-07	ACTX	ETF	7.0801	8.8501	7.0801	7.9651	134.0
2020-02-07	ACWF	ETF	31.32	31.35	31.22	31.2631	7654.0
2020-02-07	ACWI	ETF	80.56	80.65	80.22	80.38	2062200.0
2020-02-07	ACWV	ETF	98.63	98.68	98.37	98.41	196300.0
2020-02-07	ACWX	ETF	48.68	48.69	48.47	48.52	1220610.0
2020-02-07	ADME	ETF	31.35	31.35	31.26	31.29	174700.0
2020-02-07	ADRE	ETF	43.45	43.45	43.075	43.075	3277.0
2020-02-07	AESR	ETF	10.419	10.419	10.419	10.419	100.0
2020-02-07	AFIF	ETF	9.77	9.78	9.76	9.765	15946.0
2020-02-07	AFK	ETF	19.53	19.6	19.4	19.41	5954.0
2020-02-07	AFTY	ETF	16.03	16.1	15.9	15.975	16300.0
2020-02-07	AGG	ETF	114.2	114.28	114.1	114.22	5224200.0
2020-02-07	AGGY	ETF	53.21	53.24	53.174	53.23	112100.0
2020-02-07	AGNG	ETF	24.29	24.599	24.23	24.299	4200.0
2020-02-07	AGQ	ETF	31.12	31.16	30.55	30.77	190300.0
2020-02-07	AGZ	ETF	116.94	116.9895	116.88	116.9514	19021.0
2020-02-07	AGZD	ETF	24.045	24.08	24.005	24.05	12200.0
2020-02-07	AIA	ETF	64.94	65.07	64.6801	64.76	38392.0
2020-02-07	AIEQ	ETF	29.54	29.568	29.43	29.46	21900.0
2020-02-07	AIQ	ETF	19.32	19.32	19.19	19.2	33417.0
2020-02-07	AIRR	ETF	28.67	28.689	28.49	28.535	12800.0
2020-02-07	AIVI	ETF	41.85	41.85	41.64	41.64	2400.0
2020-02-07	ALTY	ETF	14.875	14.91	14.864	14.875	9800.0
2020-02-07	AMJ	ETF	20.65	20.655	20.45	20.49	1635697.0
2020-02-07	AMLP	ETF	40.15	40.35	39.85	40.05	3682400.0
2020-02-07	AMOM	ETF	27.23	27.23	27.135	27.135	400.0
2020-02-07	AMUB	ETF	12.92	12.98	12.9	12.905	1360.0
2020-02-07	AMZA	ETF	40.7	40.7	40.1	40.2	88730.0
2020-02-07	ANGL	ETF	30.15	30.17	30.11	30.12	1099700.0
2020-02-07	AOA	ETF	58.81	58.81	58.57	58.64	62900.0
2020-02-07	AOK	ETF	36.74	36.77	36.7	36.735	64376.0
2020-02-07	AOM	ETF	40.75	40.75	40.65	40.72	80583.0
2020-02-07	AOR	ETF	48.5	48.51	48.38	48.43	89558.0
2020-02-07	ARGT	ETF	25.77	26.12	25.68	25.68	25200.0
2020-02-07	ARKF	ETF	26.22	26.29	26.06	26.105	40400.0
2020-02-07	ARKG	ETF	35.4	35.44	34.72	34.72	268000.0
2020-02-07	ARKK	ETF	56.14	56.45	55.76	55.84	308900.0

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

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