PREVIEW / etf_daily / 2019-05-16

all etf daily files

  file:    by_date/etf_daily/2019/2019-05-16.parquet
  size:    69 KB
  rows:    1,808

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-05-16	SPY	ETF	285.84	289.21	285.76	287.7	76749600.0
2019-05-16	QQQ	ETF	183.11	186.07	182.95	184.93	39281157.0
2019-05-16	IWM	ETF	154.51	156.18	154.44	155.0	13772100.0
2019-05-16	DIA	ETF	258.0	260.08	257.85	259.16	3889400.0
2019-05-16	GLD	ETF	122.03	122.07	121.19	121.51	6349400.0
2019-05-16	TLT	ETF	125.81	125.83	125.53	125.71	7666400.0
2019-05-16	AAAU	ETF	12.92	12.92	12.84	12.86	13900.0
2019-05-16	AADR	ETF	45.57	45.85	45.57	45.72	5300.0
2019-05-16	AAXJ	ETF	67.75	68.09	67.56	67.57	784600.0
2019-05-16	ACES	ETF	28.279	28.425	28.279	28.309	4300.0
2019-05-16	ACSI	ETF	33.04	33.114	33.04	33.114	920.0
2019-05-16	ACTX	ETF	41.3004	41.3004	38.3503	40.7045	245.0
2019-05-16	ACWF	ETF	28.6599	28.672	28.5278	28.5278	3613.0
2019-05-16	ACWI	ETF	72.19	72.93	72.19	72.54	1074000.0
2019-05-16	ACWV	ETF	89.32	90.11	89.32	89.79	136800.0
2019-05-16	ACWX	ETF	45.82	46.1434	45.82	45.92	324703.0
2019-05-16	ADRE	ETF	39.6	39.76	39.46	39.54	7501.0
2019-05-16	AFIF	ETF	9.9403	9.96	9.93	9.945	179271.0
2019-05-16	AFK	ETF	21.37	21.43	21.13	21.2208	8637.0
2019-05-16	AFTY	ETF	16.48	16.6	16.448	16.448	4000.0
2019-05-16	AGG	ETF	109.04	109.04	108.95	109.0	2757000.0
2019-05-16	AGGY	ETF	50.07	50.08	50.0	50.06	182300.0
2019-05-16	AGNG	ETF	20.6	20.78	20.503	20.532	3000.0
2019-05-16	AGQ	ETF	23.02	23.06	22.33	22.44	490200.0
2019-05-16	AGZ	ETF	113.73	113.73	113.51	113.59	928267.0
2019-05-16	AGZD	ETF	23.84	23.915	23.815	23.815	41200.0
2019-05-16	AIA	ETF	59.3	59.6375	59.219	59.32	42255.0
2019-05-16	AIEQ	ETF	26.23	26.42	26.173	26.25	25600.0
2019-05-16	AIQ	ETF	16.18	16.4654	16.18	16.37	7897.0
2019-05-16	AIRR	ETF	25.025	25.18	25.02	25.02	9500.0
2019-05-16	AIVI	ETF	40.38	40.61	40.38	40.47	7600.0
2019-05-16	ALTY	ETF	14.94	14.94	14.84	14.883	3500.0
2019-05-16	AMJ	ETF	25.85	25.96	25.7972	25.86	424742.0
2019-05-16	AMLP	ETF	50.0	50.3	49.85	50.0	2473460.0
2019-05-16	AMUB	ETF	16.3082	16.3082	16.3082	16.3082	0.0
2019-05-16	AMZA	ETF	57.3	58.0	57.3	57.9	53580.0
2019-05-16	ANGL	ETF	28.71	28.85	28.7	28.8	293200.0
2019-05-16	AOA	ETF	53.51	53.88	53.46	53.68	43600.0
2019-05-16	AOK	ETF	34.46	34.615	34.46	34.55	31977.0
2019-05-16	AOM	ETF	37.99	38.1496	37.99	38.06	71475.0
2019-05-16	AOR	ETF	44.66	44.93	44.66	44.72	79762.0
2019-05-16	ARCM	ETF	99.95	99.98	99.95	99.98	1000.0
2019-05-16	ARGT	ETF	28.2	28.76	28.2	28.6	92300.0
2019-05-16	ARKF	ETF	22.11	22.48	22.11	22.316	46200.0
2019-05-16	ARKG	ETF	31.56	31.9	31.396	31.6	121200.0
2019-05-16	ARKK	ETF	45.15	45.509	45.1	45.28	432400.0
2019-05-16	ARKQ	ETF	32.88	33.23	32.775	33.02	23600.0
2019-05-16	ARKW	ETF	52.05	52.89	51.94	52.41	67500.0
2019-05-16	ASEA	ETF	15.71	15.84	15.57	15.64	2300.0
2019-05-16	ASET	ETF	29.0515	29.0515	29.0515	29.0515	174.0

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

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