PREVIEW / etf_daily / 2019-05-08

all etf daily files

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

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-08	SPY	ETF	287.53	289.43	286.87	287.53	91568300.0
2019-05-08	QQQ	ETF	185.68	187.17	184.96	185.77	37165319.0
2019-05-08	IWM	ETF	157.26	158.09	156.65	156.76	16113700.0
2019-05-08	DIA	ETF	259.41	261.11	258.81	259.66	4115200.0
2019-05-08	GLD	ETF	121.54	121.54	120.77	120.91	4178800.0
2019-05-08	TLT	ETF	125.15	125.3	124.3	124.41	6907600.0
2019-05-08	AAAU	ETF	12.87	12.87	12.78	12.8	11900.0
2019-05-08	AADR	ETF	45.66	45.69	45.47	45.47	8900.0
2019-05-08	AAXJ	ETF	69.87	70.15	69.57	69.58	4128600.0
2019-05-08	ACES	ETF	28.8	28.809	28.525	28.525	11500.0
2019-05-08	ACSI	ETF	33.48	33.48	33.1831	33.3327	1742.0
2019-05-08	ACTX	ETF	37.1703	41.3004	37.1703	40.1204	275.0
2019-05-08	ACWF	ETF	28.75	28.9599	28.75	28.8122	6182.0
2019-05-08	ACWI	ETF	72.79	73.23	72.68	72.8	3831500.0
2019-05-08	ACWV	ETF	89.12	89.36	88.88	89.11	748000.0
2019-05-08	ACWX	ETF	46.31	46.53	46.24	46.33	704339.0
2019-05-08	ADRE	ETF	40.61	40.7399	40.4992	40.7399	4495.0
2019-05-08	AFIF	ETF	10.02	10.03	10.0	10.0141	4109.0
2019-05-08	AFK	ETF	21.43	21.65	21.4	21.47	3191.0
2019-05-08	AFTY	ETF	16.39	16.44	16.23	16.28	13300.0
2019-05-08	AGG	ETF	108.74	108.81	108.55	108.59	5946400.0
2019-05-08	AGGY	ETF	49.97	49.98	49.82	49.845	46400.0
2019-05-08	AGNG	ETF	20.824	20.824	20.676	20.676	1400.0
2019-05-08	AGQ	ETF	23.6	23.6	23.31	23.34	83300.0
2019-05-08	AGZ	ETF	113.34	113.406	113.2687	113.3	22824.0
2019-05-08	AGZD	ETF	23.985	23.985	23.885	23.925	135800.0
2019-05-08	AIA	ETF	61.48	61.6899	61.41	61.46	15202.0
2019-05-08	AIEQ	ETF	26.37	26.6	26.37	26.44	64100.0
2019-05-08	AIQ	ETF	16.5	16.5146	16.38	16.49	13104.0
2019-05-08	AIRR	ETF	25.41	25.46	25.27	25.27	3400.0
2019-05-08	AIVI	ETF	40.45	40.55	40.45	40.47	4500.0
2019-05-08	ALTY	ETF	14.8	14.95	14.8	14.846	12400.0
2019-05-08	AMJ	ETF	24.9	25.17	24.89	24.94	1452265.0
2019-05-08	AMLP	ETF	49.4	49.75	49.1	49.4	1990540.0
2019-05-08	AMUB	ETF	15.7431	15.7431	15.7431	15.7431	0.0
2019-05-08	AMZA	ETF	56.7	57.0	56.1	56.2	79010.0
2019-05-08	ANGL	ETF	28.91	29.0	28.86	28.96	244300.0
2019-05-08	AOA	ETF	53.85	54.02	53.75	53.86	68900.0
2019-05-08	AOK	ETF	34.57	34.62	34.54	34.54	46731.0
2019-05-08	AOM	ETF	38.08	38.15	38.0524	38.1	66342.0
2019-05-08	AOR	ETF	44.89	44.988	44.82	44.84	60967.0
2019-05-08	ARGT	ETF	27.39	27.85	27.34	27.59	59800.0
2019-05-08	ARKF	ETF	22.31	22.49	22.265	22.369	32300.0
2019-05-08	ARKG	ETF	32.16	32.472	31.56	32.07	156500.0
2019-05-08	ARKK	ETF	46.57	46.935	46.06	46.43	330400.0
2019-05-08	ARKQ	ETF	34.11	34.19	33.86	33.86	16300.0
2019-05-08	ARKW	ETF	52.43	53.25	52.43	52.78	160000.0
2019-05-08	ASEA	ETF	16.14	16.24	16.14	16.14	1100.0
2019-05-08	ASET	ETF	28.71	28.71	28.61	28.61	1694.0
2019-05-08	ASHR	ETF	26.71	27.09	26.63	26.69	11035500.0

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

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