PREVIEW / etf_daily / 2019-03-01

all etf daily files

  file:    by_date/etf_daily/2019/2019-03-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-03-01	SPY	ETF	280.44	280.88	278.82	280.42	78880500.0
2019-03-01	QQQ	ETF	174.41	174.65	173.18	174.39	31431156.0
2019-03-01	IWM	ETF	157.95	158.34	156.75	158.24	19247100.0
2019-03-01	DIA	ETF	261.15	261.54	259.23	260.42	3676900.0
2019-03-01	GLD	ETF	123.48	123.96	121.87	121.88	16411700.0
2019-03-01	TLT	ETF	119.33	119.53	118.64	118.66	13541100.0
2019-03-01	AAAU	ETF	13.05	13.09	12.89	12.89	19400.0
2019-03-01	AADR	ETF	46.29	46.29	45.93	45.93	5200.0
2019-03-01	AAXJ	ETF	69.9	69.9	69.31	69.48	502500.0
2019-03-01	ACES	ETF	27.03	27.03	26.87	26.998	9300.0
2019-03-01	ACSI	ETF	32.555	32.6589	32.555	32.6589	966.0
2019-03-01	ACTX	ETF	60.1805	73.7507	58.4105	67.8506	1468.0
2019-03-01	ACWF	ETF	29.419	29.419	29.1899	29.29	21382.0
2019-03-01	ACWI	ETF	71.49	71.58	71.12	71.41	4186600.0
2019-03-01	ACWV	ETF	87.97	88.0	87.45	87.72	159500.0
2019-03-01	ACWX	ETF	46.12	46.19	45.94	46.07	5198644.0
2019-03-01	ADRE	ETF	40.73	40.93	40.65	40.65	4803.0
2019-03-01	AFIF	ETF	9.92	10.03	9.92	10.025	7917.0
2019-03-01	AFK	ETF	21.93	21.93	21.62	21.69	8651.0
2019-03-01	AFTY	ETF	16.57	16.74	16.57	16.729	15900.0
2019-03-01	AGG	ETF	106.77	106.84	106.61	106.63	5527000.0
2019-03-01	AGGY	ETF	48.77	48.82	48.73	48.75	86900.0
2019-03-01	AGNG	ETF	21.695	21.78	21.695	21.75	12700.0
2019-03-01	AGQ	ETF	25.73	25.95	24.73	24.73	331400.0
2019-03-01	AGZ	ETF	111.76	111.8299	111.6705	111.74	24822.0
2019-03-01	AGZD	ETF	23.8	23.93	23.765	23.93	19800.0
2019-03-01	AIA	ETF	60.99	60.99	60.57	60.79	46584.0
2019-03-01	AIEQ	ETF	25.8	25.98	25.74	25.9	66200.0
2019-03-01	AIQ	ETF	15.48	15.55	15.4503	15.46	7654.0
2019-03-01	AIRR	ETF	25.6	25.79	25.451	25.68	16600.0
2019-03-01	AIVI	ETF	40.94	40.99	40.76	40.81	129900.0
2019-03-01	ALTY	ETF	14.83	14.83	14.785	14.8	14300.0
2019-03-01	AMJ	ETF	24.64	24.94	24.52	24.81	2211787.0
2019-03-01	AMLP	ETF	48.6	49.05	48.2	48.75	4176840.0
2019-03-01	AMUB	ETF	15.6095	15.6095	15.6095	15.6095	2.0
2019-03-01	AMZA	ETF	58.3	59.0	58.0	58.5	82150.0
2019-03-01	ANGL	ETF	28.55	28.57	28.48	28.57	188300.0
2019-03-01	AOA	ETF	53.0	53.15	52.88	53.02	169500.0
2019-03-01	AOK	ETF	34.01	34.0699	33.98	33.99	74462.0
2019-03-01	AOM	ETF	37.5	37.57	37.47	37.53	121223.0
2019-03-01	AOR	ETF	44.18	44.27	44.06	44.15	121256.0
2019-03-01	ARGT	ETF	28.45	28.57	27.57	27.68	146400.0
2019-03-01	ARKF	ETF	21.39	21.39	21.113	21.209	29500.0
2019-03-01	ARKG	ETF	31.0	32.13	30.942	32.08	143800.0
2019-03-01	ARKK	ETF	46.85	46.89	46.39	46.8	283600.0
2019-03-01	ARKQ	ETF	35.72	35.72	34.86	34.866	13000.0
2019-03-01	ARKW	ETF	52.29	52.29	51.335	51.66	130700.0
2019-03-01	ASEA	ETF	15.82	15.92	15.82	15.92	1100.0
2019-03-01	ASET	ETF	28.31	28.3199	28.2844	28.3199	1059.0
2019-03-01	ASHR	ETF	28.12	28.25	28.09	28.19	12469900.0

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

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