PREVIEW / etf_daily / 2019-02-05

all etf daily files

  file:    by_date/etf_daily/2019/2019-02-05.parquet
  size:    67 KB
  rows:    1,742

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-05	SPY	ETF	272.44	273.44	271.88	273.1	79552800.0
2019-02-05	QQQ	ETF	169.75	171.23	169.69	171.03	28156368.0
2019-02-05	IWM	ETF	151.01	151.6	150.24	151.12	18295900.0
2019-02-05	DIA	ETF	253.36	254.2	252.81	253.96	3090500.0
2019-02-05	GLD	ETF	124.29	124.42	124.05	124.28	6291100.0
2019-02-05	TLT	ETF	120.73	121.23	120.66	120.97	6983300.0
2019-02-05	AAAU	ETF	13.14	13.15	13.13	13.14	11200.0
2019-02-05	AADR	ETF	44.52	44.78	44.52	44.64	5700.0
2019-02-05	AAXJ	ETF	69.1	69.83	69.06	69.76	585400.0
2019-02-05	ACES	ETF	26.42	26.42	25.72	25.82	7400.0
2019-02-05	ACSI	ETF	31.37	31.6573	31.37	31.651	2002.0
2019-02-05	ACTX	ETF	47.7904	49.2654	47.2004	48.6754	565.0
2019-02-05	ACWF	ETF	28.66	28.78	28.66	28.75	40466.0
2019-02-05	ACWI	ETF	69.86	70.11	69.81	70.05	4445100.0
2019-02-05	ACWV	ETF	85.96	86.09	85.8	86.0	208400.0
2019-02-05	ACWX	ETF	45.44	45.64	45.42	45.6	2541993.0
2019-02-05	ADRE	ETF	40.08	40.47	40.08	40.47	14514.0
2019-02-05	AFIF	ETF	10.0023	10.02	9.98	9.982	18644.0
2019-02-05	AFK	ETF	21.89	22.09	21.89	22.0599	5674.0
2019-02-05	AFTY	ETF	14.89	14.975	14.89	14.975	200.0
2019-02-05	AGG	ETF	106.95	107.14	106.95	107.11	8913500.0
2019-02-05	AGGY	ETF	48.88	48.94	48.85	48.886	46700.0
2019-02-05	AGNG	ETF	21.067	21.219	20.981	20.981	2700.0
2019-02-05	AGQ	ETF	27.57	27.6	27.3	27.45	63000.0
2019-02-05	AGZ	ETF	111.88	111.96	111.82	111.9	187292.0
2019-02-05	AGZD	ETF	23.83	23.83	23.725	23.815	13200.0
2019-02-05	AIA	ETF	60.57	61.4047	60.57	61.31	65570.0
2019-02-05	AIEQ	ETF	25.0	25.169	24.99	25.12	75900.0
2019-02-05	AIQ	ETF	14.89	14.99	14.8801	14.9886	4641.0
2019-02-05	AIRR	ETF	24.34	24.452	24.27	24.42	22300.0
2019-02-05	AIVI	ETF	40.52	40.71	40.52	40.66	6200.0
2019-02-05	ALTY	ETF	14.6	14.71	14.6	14.67	6800.0
2019-02-05	AMJ	ETF	25.43	25.55	25.3	25.41	2413616.0
2019-02-05	AMLP	ETF	49.95	50.35	49.8	50.15	3238520.0
2019-02-05	AMUB	ETF	16.0028	16.0028	16.0028	16.0028	0.0
2019-02-05	AMZA	ETF	60.0	60.4	59.7	59.7	48440.0
2019-02-05	ANGL	ETF	28.15	28.35	28.13	28.26	253500.0
2019-02-05	AOA	ETF	52.04	52.18	52.02	52.15	60400.0
2019-02-05	AOK	ETF	33.75	33.79	33.7201	33.76	131335.0
2019-02-05	AOM	ETF	37.08	37.19	37.08	37.15	96311.0
2019-02-05	AOR	ETF	43.57	43.64	43.52	43.6	282238.0
2019-02-05	ARGT	ETF	28.49	28.5	28.19	28.33	88600.0
2019-02-05	ARKF	ETF	20.48	20.61	20.43	20.533	110700.0
2019-02-05	ARKG	ETF	28.7	29.0	28.21	28.31	69900.0
2019-02-05	ARKK	ETF	43.92	44.35	43.65	43.92	292600.0
2019-02-05	ARKQ	ETF	33.74	34.13	33.68	34.1	34500.0
2019-02-05	ARKW	ETF	50.45	50.86	50.415	50.68	144700.0
2019-02-05	ASEA	ETF	16.18	16.31	16.17	16.31	5600.0
2019-02-05	ASET	ETF	27.89	27.89	27.89	27.89	785.0
2019-02-05	ASHR	ETF	24.29	24.44	24.22	24.41	1211400.0

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

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