PREVIEW / etf_daily / 2020-02-13

all etf daily files

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

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-13	SPY	ETF	335.86	338.12	335.56	337.06	54501900.0
2020-02-13	QQQ	ETF	232.62	234.93	232.36	233.97	22773159.0
2020-02-13	IWM	ETF	167.22	168.95	167.11	168.55	12649300.0
2020-02-13	DIA	ETF	294.39	295.84	293.92	294.82	2638000.0
2020-02-13	GLD	ETF	148.24	148.58	147.95	148.38	7082100.0
2020-02-13	TLT	ETF	143.44	144.2	143.27	143.92	7883400.0
2020-02-13	AAAU	ETF	15.7	15.74	15.68	15.72	45300.0
2020-02-13	AADR	ETF	56.56	56.56	56.16	56.41	3800.0
2020-02-13	AAXJ	ETF	73.18	73.46	72.97	73.08	1576100.0
2020-02-13	ABEQ	ETF	25.1	25.13	25.09	25.09	5300.0
2020-02-13	ACES	ETF	40.02	40.59	39.464	40.43	66400.0
2020-02-13	ACIO	ETF	25.418	25.45	25.39	25.412	28500.0
2020-02-13	ACSI	ETF	37.3025	37.494	37.3	37.4421	1508.0
2020-02-13	ACTX	ETF	6.8441	7.5344	6.7851	6.7851	159.0
2020-02-13	ACWF	ETF	31.66	31.87	31.66	31.7571	24266.0
2020-02-13	ACWI	ETF	81.17	81.6	81.09	81.36	3010300.0
2020-02-13	ACWV	ETF	98.58	99.33	98.58	99.2	151600.0
2020-02-13	ACWX	ETF	48.9	49.09	48.8273	48.93	891330.0
2020-02-13	ADME	ETF	31.581	31.793	31.58	31.69	39600.0
2020-02-13	ADRE	ETF	44.04	44.24	43.9929	44.0101	3410.0
2020-02-13	AESR	ETF	10.522	10.522	10.522	10.522	100.0
2020-02-13	AFIF	ETF	9.75	9.76	9.73	9.745	60293.0
2020-02-13	AFK	ETF	19.78	19.78	19.64	19.6419	7822.0
2020-02-13	AFTY	ETF	16.28	16.29	16.227	16.237	2900.0
2020-02-13	AGG	ETF	114.11	114.24	114.1	114.17	5214400.0
2020-02-13	AGGY	ETF	53.17	53.23	53.16	53.2	159000.0
2020-02-13	AGNG	ETF	24.53	24.673	24.5	24.673	2500.0
2020-02-13	AGQ	ETF	30.73	30.81	30.47	30.53	344700.0
2020-02-13	AGZ	ETF	116.91	116.9599	116.88	116.93	33951.0
2020-02-13	AGZD	ETF	24.065	24.08	24.015	24.035	6000.0
2020-02-13	AIA	ETF	66.56	66.806	66.44	66.64	19554.0
2020-02-13	AIEQ	ETF	29.91	30.11	29.91	30.054	18000.0
2020-02-13	AIQ	ETF	19.74	19.84	19.6	19.77	86334.0
2020-02-13	AIRR	ETF	29.18	29.54	29.18	29.54	13100.0
2020-02-13	AIVI	ETF	41.75	41.87	41.67	41.77	3800.0
2020-02-13	ALTY	ETF	14.995	15.01	14.974	14.99	16400.0
2020-02-13	AMJ	ETF	20.58	20.845	20.54	20.54	1783949.0
2020-02-13	AMLP	ETF	39.5	39.75	39.1	39.2	3561240.0
2020-02-13	AMOM	ETF	27.749	27.749	27.749	27.749	100.0
2020-02-13	AMUB	ETF	12.9999	12.9999	12.9333	12.935	482.0
2020-02-13	AMZA	ETF	40.8	41.2	40.13	40.3	95300.0
2020-02-13	ANGL	ETF	30.45	30.5	30.35	30.47	527900.0
2020-02-13	AOA	ETF	59.12	59.31	59.01	59.2	41400.0
2020-02-13	AOK	ETF	36.88	36.92	36.818	36.88	39645.0
2020-02-13	AOM	ETF	40.91	40.95	40.84	40.86	182702.0
2020-02-13	AOR	ETF	48.72	48.85	48.69	48.77	108159.0
2020-02-13	ARGT	ETF	25.92	25.92	25.55	25.8	11900.0
2020-02-13	ARKF	ETF	26.75	27.09	26.75	26.93	87300.0
2020-02-13	ARKG	ETF	36.4	36.94	36.1	36.54	156600.0
2020-02-13	ARKK	ETF	58.06	59.24	57.803	58.76	485400.0

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

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