PREVIEW / etf_daily / 2019-02-01

all etf daily files

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

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-01	SPY	ETF	270.15	271.2	269.18	270.06	85782500.0
2019-02-01	QQQ	ETF	167.37	168.6	166.99	167.45	32143672.0
2019-02-01	IWM	ETF	149.35	149.68	148.58	149.18	17057900.0
2019-02-01	DIA	ETF	250.67	251.85	249.75	250.48	3971400.0
2019-02-01	GLD	ETF	124.89	125.05	124.37	124.5	12485500.0
2019-02-01	TLT	ETF	121.48	121.57	120.84	120.96	12024600.0
2019-02-01	AAAU	ETF	13.21	13.21	13.16	13.17	18600.0
2019-02-01	AADR	ETF	44.34	44.53	44.34	44.52	13200.0
2019-02-01	AAXJ	ETF	68.51	68.63	68.32	68.5	707300.0
2019-02-01	ACES	ETF	25.58	25.58	25.5	25.5	15800.0
2019-02-01	ACSI	ETF	31.39	31.39	31.19	31.2617	1342.0
2019-02-01	ACTX	ETF	47.7904	49.5604	47.2004	47.9084	253.0
2019-02-01	ACWF	ETF	28.47	28.5399	28.39	28.4772	40296.0
2019-02-01	ACWI	ETF	69.31	69.46	69.08	69.24	4794400.0
2019-02-01	ACWV	ETF	85.47	85.54	85.16	85.44	243200.0
2019-02-01	ACWX	ETF	45.07	45.17	44.95	45.03	3679603.0
2019-02-01	ADRE	ETF	40.01	40.16	39.99	40.0367	5367.0
2019-02-01	AFIF	ETF	9.96	10.0099	9.94	9.985	13379.0
2019-02-01	AFK	ETF	21.74	21.8923	21.69	21.8273	5592.0
2019-02-01	AFTY	ETF	14.82	14.829	14.82	14.829	2400.0
2019-02-01	AGG	ETF	107.09	107.15	106.88	106.97	7227900.0
2019-02-01	AGGY	ETF	48.94	48.94	48.77	48.845	69200.0
2019-02-01	AGNG	ETF	20.954	20.954	20.84	20.84	400.0
2019-02-01	AGQ	ETF	28.1	28.18	27.58	27.67	164100.0
2019-02-01	AGZ	ETF	112.21	112.21	111.98	111.99	136804.0
2019-02-01	AGZD	ETF	23.78	23.83	23.68	23.695	190600.0
2019-02-01	AIA	ETF	60.13	60.25	59.96	60.14	56006.0
2019-02-01	AIEQ	ETF	24.65	24.89	24.65	24.82	27900.0
2019-02-01	AIQ	ETF	14.68	14.69	14.6467	14.6467	8664.0
2019-02-01	AIRR	ETF	24.049	24.049	23.68	23.82	43900.0
2019-02-01	AIVI	ETF	40.31	40.38	40.22	40.29	45600.0
2019-02-01	ALTY	ETF	14.72	14.72	14.677	14.694	4800.0
2019-02-01	AMJ	ETF	25.08	25.29	24.87	25.28	4731607.0
2019-02-01	AMLP	ETF	49.25	49.85	49.0	49.7	4067300.0
2019-02-01	AMUB	ETF	15.9226	15.9226	15.9226	15.9226	0.0
2019-02-01	AMZA	ETF	58.6	59.5	58.4	59.5	81500.0
2019-02-01	ANGL	ETF	28.12	28.19	28.06	28.11	305500.0
2019-02-01	AOA	ETF	51.71	51.78	51.55	51.63	111100.0
2019-02-01	AOK	ETF	33.77	33.7825	33.65	33.67	110174.0
2019-02-01	AOM	ETF	37.01	37.0326	36.93	36.98	166285.0
2019-02-01	AOR	ETF	43.34	43.3799	43.23	43.29	552274.0
2019-02-01	ARCM	ETF	99.93	99.93	99.93	99.93	100.0
2019-02-01	ARGT	ETF	27.95	27.99	27.69	27.98	34700.0
2019-02-01	ARKG	ETF	28.22	28.62	28.05	28.257	54500.0
2019-02-01	ARKK	ETF	43.01	43.51	42.73	43.11	247800.0
2019-02-01	ARKQ	ETF	33.3	33.4	33.05	33.33	67300.0
2019-02-01	ARKW	ETF	49.3	49.784	49.11	49.56	83400.0
2019-02-01	ASEA	ETF	16.12	16.18	16.05	16.18	18200.0
2019-02-01	ASET	ETF	27.78	27.8	27.7239	27.7239	1331.0
2019-02-01	ASHR	ETF	24.24	24.26	24.17	24.19	1684700.0

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

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