PREVIEW / etf_daily / 2019-03-21

all etf daily files

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

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-21	SPY	ETF	280.64	285.18	280.59	284.73	79550400.0
2019-03-21	QQQ	ETF	179.24	182.83	179.2	182.57	42428481.0
2019-03-21	IWM	ETF	152.73	156.06	152.73	155.27	31845000.0
2019-03-21	DIA	ETF	256.38	259.97	256.35	259.58	3800000.0
2019-03-21	GLD	ETF	124.36	124.37	123.11	123.68	7739800.0
2019-03-21	TLT	ETF	122.96	123.09	122.74	122.95	7182600.0
2019-03-21	AAAU	ETF	13.16	13.16	13.08	13.08	32200.0
2019-03-21	AADR	ETF	46.08	46.4	45.9	46.15	8600.0
2019-03-21	AAXJ	ETF	70.59	71.31	70.54	71.31	1537400.0
2019-03-21	ACES	ETF	27.42	27.46	27.42	27.435	6200.0
2019-03-21	ACSI	ETF	32.4699	32.7392	32.4699	32.7392	651.0
2019-03-21	ACTX	ETF	53.1005	53.1005	50.7405	52.5105	635.0
2019-03-21	ACWF	ETF	29.0	29.31	29.0	29.3	19571.0
2019-03-21	ACWI	ETF	72.08	72.89	72.04	72.85	2173200.0
2019-03-21	ACWV	ETF	88.16	89.13	88.16	89.03	179500.0
2019-03-21	ACWX	ETF	46.56	46.87	46.56	46.87	1328974.0
2019-03-21	ADRE	ETF	41.4987	41.56	41.24	41.53	5278.0
2019-03-21	AFIF	ETF	10.0029	10.03	9.99	10.0	26816.0
2019-03-21	AFK	ETF	21.85	21.8632	21.8058	21.825	3258.0
2019-03-21	AFTY	ETF	16.65	16.67	16.595	16.67	6900.0
2019-03-21	AGG	ETF	108.13	108.18	108.05	108.08	4192700.0
2019-03-21	AGGY	ETF	49.5	49.53	49.46	49.51	92500.0
2019-03-21	AGNG	ETF	21.51	21.784	21.51	21.7	1600.0
2019-03-21	AGQ	ETF	25.91	25.91	25.45	25.74	109700.0
2019-03-21	AGZ	ETF	112.94	112.98	112.81	112.8841	97994.0
2019-03-21	AGZD	ETF	23.855	23.93	23.83	23.89	23000.0
2019-03-21	AIA	ETF	61.26	61.98	61.21	61.98	72901.0
2019-03-21	AIEQ	ETF	25.87	26.27	25.87	26.27	33700.0
2019-03-21	AIQ	ETF	15.76	16.03	15.76	16.03	18123.0
2019-03-21	AIRR	ETF	24.51	25.024	24.51	24.781	7000.0
2019-03-21	AIVI	ETF	41.84	42.06	41.84	42.06	6700.0
2019-03-21	ALTY	ETF	14.65	14.87	14.65	14.854	11300.0
2019-03-21	AMJ	ETF	25.62	26.0	25.62	25.9	1450954.0
2019-03-21	AMLP	ETF	50.5	51.25	50.5	51.0	3047420.0
2019-03-21	AMUB	ETF	16.3174	16.3174	16.3174	16.3174	6.0
2019-03-21	AMZA	ETF	60.2	61.0	59.9	60.9	67950.0
2019-03-21	ANGL	ETF	28.62	28.77	28.62	28.74	235900.0
2019-03-21	AOA	ETF	53.44	53.9	53.44	53.89	55500.0
2019-03-21	AOK	ETF	34.39	34.47	34.3195	34.47	54246.0
2019-03-21	AOM	ETF	37.92	38.08	37.86	38.02	129260.0
2019-03-21	AOR	ETF	44.61	44.9	44.6054	44.9	84032.0
2019-03-21	ARGT	ETF	28.73	28.96	28.66	28.81	20400.0
2019-03-21	ARKF	ETF	21.29	21.76	21.258	21.739	24300.0
2019-03-21	ARKG	ETF	33.01	33.71	32.74	33.69	126100.0
2019-03-21	ARKK	ETF	46.81	48.15	46.76	48.07	354000.0
2019-03-21	ARKQ	ETF	34.32	34.95	34.32	34.83	12300.0
2019-03-21	ARKW	ETF	51.76	53.177	51.73	53.12	118600.0
2019-03-21	ASEA	ETF	15.91	16.07	15.91	16.07	2700.0
2019-03-21	ASET	ETF	28.8768	28.9898	28.8768	28.9451	1863.0
2019-03-21	ASHR	ETF	28.6	28.78	28.53	28.78	2930700.0

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

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