PREVIEW / etf_daily / 2019-02-26

all etf daily files

  file:    by_date/etf_daily/2019/2019-02-26.parquet
  size:    68 KB
  rows:    1,746

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
2019-02-26	SPY	ETF	279.13	280.3	278.9	279.32	56844100.0
2019-02-26	QQQ	ETF	173.04	174.25	172.81	173.7	21939717.0
2019-02-26	IWM	ETF	158.01	158.19	156.89	157.1	21497300.0
2019-02-26	DIA	ETF	259.96	261.5	259.6	260.54	3080200.0
2019-02-26	GLD	ETF	125.33	125.62	125.05	125.58	5153200.0
2019-02-26	TLT	ETF	121.73	121.82	121.36	121.81	6028900.0
2019-02-26	AAAU	ETF	13.26	13.28	13.23	13.28	8000.0
2019-02-26	AADR	ETF	46.25	46.43	46.1	46.39	8100.0
2019-02-26	AAXJ	ETF	70.18	70.66	70.13	70.49	1560300.0
2019-02-26	ACES	ETF	27.039	27.104	27.039	27.104	3500.0
2019-02-26	ACSI	ETF	32.5745	32.5745	32.568	32.568	702.0
2019-02-26	ACTX	ETF	63.7206	68.4406	57.2305	59.0005	1346.0
2019-02-26	ACWF	ETF	29.4	29.46	29.35	29.38	5491.0
2019-02-26	ACWI	ETF	71.29	71.64	71.28	71.43	1988300.0
2019-02-26	ACWV	ETF	87.61	87.84	87.51	87.67	155200.0
2019-02-26	ACWX	ETF	46.15	46.39	46.111	46.28	614223.0
2019-02-26	ADRE	ETF	40.8432	41.0577	40.8432	41.0577	1800.0
2019-02-26	AFIF	ETF	9.998	10.03	9.97	9.98	18527.0
2019-02-26	AFK	ETF	22.42	22.47	22.22	22.28	3721.0
2019-02-26	AFTY	ETF	16.13	16.28	16.13	16.248	12000.0
2019-02-26	AGG	ETF	107.53	107.57	107.43	107.49	4759400.0
2019-02-26	AGGY	ETF	49.01	49.01	48.94	49.0	82400.0
2019-02-26	AGNG	ETF	21.424	21.549	21.424	21.53	2200.0
2019-02-26	AGQ	ETF	27.35	27.46	27.06	27.44	88900.0
2019-02-26	AGZ	ETF	112.35	112.4199	112.31	112.36	18910.0
2019-02-26	AGZD	ETF	23.8	23.85	23.8	23.815	30000.0
2019-02-26	AIA	ETF	61.51	61.8	61.48	61.7	35111.0
2019-02-26	AIEQ	ETF	25.72	25.822	25.71	25.71	27400.0
2019-02-26	AIQ	ETF	15.44	15.5	15.421	15.5	4617.0
2019-02-26	AIRR	ETF	25.63	25.735	25.44	25.44	26600.0
2019-02-26	AIVI	ETF	40.83	41.12	40.83	41.07	6800.0
2019-02-26	ALTY	ETF	14.949	14.969	14.861	14.9	12800.0
2019-02-26	AMJ	ETF	25.62	25.67	25.31	25.31	1266341.0
2019-02-26	AMLP	ETF	49.6	49.7	48.85	48.9	2604740.0
2019-02-26	AMUB	ETF	15.94	15.9498	15.94	15.9498	200.0
2019-02-26	AMZA	ETF	60.0	60.2	58.8	58.8	56900.0
2019-02-26	ANGL	ETF	28.59	28.64	28.55	28.61	340400.0
2019-02-26	AOA	ETF	53.0	53.17	52.96	53.03	90800.0
2019-02-26	AOK	ETF	34.03	34.1469	34.014	34.09	104107.0
2019-02-26	AOM	ETF	37.54	37.64	37.54	37.56	77789.0
2019-02-26	AOR	ETF	44.23	44.3263	44.2	44.24	101724.0
2019-02-26	ARGT	ETF	27.47	27.59	27.17	27.3	49400.0
2019-02-26	ARKF	ETF	21.16	21.16	20.97	21.091	31400.0
2019-02-26	ARKG	ETF	30.25	30.59	30.25	30.34	97200.0
2019-02-26	ARKK	ETF	46.28	46.385	45.97	46.04	185600.0
2019-02-26	ARKQ	ETF	35.5	35.5	35.1	35.2	15900.0
2019-02-26	ARKW	ETF	51.66	51.9	51.38	51.55	60500.0
2019-02-26	ASEA	ETF	16.25	16.37	16.19	16.37	3400.0
2019-02-26	ASET	ETF	28.47	28.5107	28.47	28.5107	2852.0
2019-02-26	ASHR	ETF	27.7	27.87	27.67	27.77	5813600.0

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

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