PREVIEW / etf_daily / 2019-03-06

all etf daily files

  file:    by_date/etf_daily/2019/2019-03-06.parquet
  size:    68 KB
  rows:    1,757

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-06	SPY	ETF	279.15	279.16	276.97	277.33	75039800.0
2019-03-06	QQQ	ETF	174.68	174.75	173.28	173.56	27194581.0
2019-03-06	IWM	ETF	156.02	156.08	152.88	153.02	29604600.0
2019-03-06	DIA	ETF	258.24	258.45	256.45	256.87	3222000.0
2019-03-06	GLD	ETF	121.43	121.64	121.26	121.61	4820400.0
2019-03-06	TLT	ETF	119.92	120.52	119.89	120.28	7766700.0
2019-03-06	AAAU	ETF	12.84	12.86	12.84	12.86	6200.0
2019-03-06	AADR	ETF	45.39	45.48	44.89	44.99	88400.0
2019-03-06	AAXJ	ETF	70.26	70.39	69.98	69.98	663100.0
2019-03-06	ACES	ETF	27.69	27.69	26.58	26.638	2700.0
2019-03-06	ACSI	ETF	32.4034	32.4034	32.1908	32.1908	468.0
2019-03-06	ACTX	ETF	53.1005	58.4105	51.3305	56.0505	1187.0
2019-03-06	ACWF	ETF	28.98	29.0599	28.83	28.83	20925.0
2019-03-06	ACWI	ETF	71.29	71.29	70.83	70.86	2935400.0
2019-03-06	ACWV	ETF	87.49	87.52	87.12	87.21	242900.0
2019-03-06	ACWX	ETF	46.16	46.184	45.93	45.96	1142552.0
2019-03-06	ADRE	ETF	40.7387	40.8	40.4301	40.4301	3518.0
2019-03-06	AFIF	ETF	10.0201	10.06	10.01	10.02	12636.0
2019-03-06	AFK	ETF	21.95	21.95	21.6934	21.745	11223.0
2019-03-06	AFTY	ETF	16.75	16.82	16.73	16.765	22100.0
2019-03-06	AGG	ETF	106.88	107.07	106.85	106.99	4834000.0
2019-03-06	AGGY	ETF	48.88	48.94	48.87	48.88	69500.0
2019-03-06	AGNG	ETF	21.62	21.62	21.25	21.25	3200.0
2019-03-06	AGQ	ETF	24.54	24.6	24.4	24.51	82000.0
2019-03-06	AGZ	ETF	111.9601	112.0499	111.9	111.99	996210.0
2019-03-06	AGZD	ETF	23.905	23.91	23.78	23.785	12400.0
2019-03-06	AIA	ETF	61.26	61.26	60.79	60.79	68528.0
2019-03-06	AIEQ	ETF	25.8	25.8	25.5	25.5	39200.0
2019-03-06	AIQ	ETF	15.3898	15.3898	15.27	15.27	16703.0
2019-03-06	AIRR	ETF	25.45	25.45	25.03	25.04	8600.0
2019-03-06	AIVI	ETF	40.82	40.83	40.74	40.78	7500.0
2019-03-06	ALTY	ETF	14.77	14.77	14.598	14.61	13700.0
2019-03-06	AMJ	ETF	24.76	24.76	24.51	24.56	1492445.0
2019-03-06	AMLP	ETF	48.7	48.7	48.2	48.25	2969220.0
2019-03-06	AMUB	ETF	15.4739	15.4739	15.4739	15.4739	0.0
2019-03-06	AMZA	ETF	58.5	58.7	57.93	58.1	49070.0
2019-03-06	ANGL	ETF	28.55	28.55	28.43	28.46	150700.0
2019-03-06	AOA	ETF	52.98	52.98	52.67	52.7	65000.0
2019-03-06	AOK	ETF	33.99	33.99	33.925	33.96	53558.0
2019-03-06	AOM	ETF	37.51	37.52	37.41	37.41	87373.0
2019-03-06	AOR	ETF	44.18	44.2	43.97	44.02	54577.0
2019-03-06	ARGT	ETF	27.7	27.7	27.04	27.18	45100.0
2019-03-06	ARKF	ETF	21.15	21.15	20.93	20.947	17600.0
2019-03-06	ARKG	ETF	31.71	31.745	30.4	30.45	138500.0
2019-03-06	ARKK	ETF	46.36	46.36	45.26	45.36	482800.0
2019-03-06	ARKQ	ETF	34.57	34.57	33.97	33.99	13300.0
2019-03-06	ARKW	ETF	51.33	51.33	50.42	50.46	81900.0
2019-03-06	ASEA	ETF	15.83	15.86	15.83	15.86	1300.0
2019-03-06	ASET	ETF	28.27	28.28	28.2054	28.2303	1495.0
2019-03-06	ASHR	ETF	28.73	28.82	28.67	28.75	11346200.0

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

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