PREVIEW / etf_daily / 2019-03-13

all etf daily files

  file:    by_date/etf_daily/2019/2019-03-13.parquet
  size:    67 KB
  rows:    1,749

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-13	SPY	ETF	280.48	282.38	280.3	281.34	80639200.0
2019-03-13	QQQ	ETF	176.6	177.93	176.35	177.01	42426135.0
2019-03-13	IWM	ETF	154.92	155.73	154.75	154.98	24109100.0
2019-03-13	DIA	ETF	256.84	258.07	256.01	257.35	5272800.0
2019-03-13	GLD	ETF	123.56	123.88	123.43	123.84	7377300.0
2019-03-13	TLT	ETF	121.66	121.96	121.62	121.83	4386300.0
2019-03-13	AAAU	ETF	13.07	13.1	13.06	13.09	35000.0
2019-03-13	AADR	ETF	45.31	45.52	45.09	45.45	11800.0
2019-03-13	AAXJ	ETF	69.79	69.87	69.62	69.7	1390700.0
2019-03-13	ACES	ETF	27.34	27.34	27.28	27.331	2200.0
2019-03-13	ACSI	ETF	32.4101	32.5266	32.4101	32.5266	1709.0
2019-03-13	ACTX	ETF	56.0505	56.0505	48.3804	51.3305	480.0
2019-03-13	ACWF	ETF	28.99	29.1238	28.99	29.04	4891.0
2019-03-13	ACWI	ETF	71.35	71.72	71.31	71.55	3341200.0
2019-03-13	ACWV	ETF	88.07	88.38	87.99	88.19	146000.0
2019-03-13	ACWX	ETF	45.9	46.09	45.8915	46.05	889665.0
2019-03-13	ADRE	ETF	40.81	41.17	40.81	41.048	4723.0
2019-03-13	AFIF	ETF	10.01	10.05	10.01	10.03	128833.0
2019-03-13	AFK	ETF	21.84	21.84	21.71	21.72	1898.0
2019-03-13	AFTY	ETF	16.22	16.22	16.14	16.145	1500.0
2019-03-13	AGG	ETF	107.56	107.61	107.51	107.59	2608800.0
2019-03-13	AGGY	ETF	49.2	49.23	49.168	49.21	65000.0
2019-03-13	AGNG	ETF	21.61	21.88	21.45	21.758	3600.0
2019-03-13	AGQ	ETF	25.82	25.89	25.67	25.76	72000.0
2019-03-13	AGZ	ETF	112.43	112.52	112.43	112.5163	18861.0
2019-03-13	AGZD	ETF	23.85	23.91	23.79	23.91	7800.0
2019-03-13	AIA	ETF	60.79	60.89	60.6906	60.76	36759.0
2019-03-13	AIEQ	ETF	25.78	25.98	25.76	25.91	51700.0
2019-03-13	AIQ	ETF	15.51	15.65	15.51	15.56	19047.0
2019-03-13	AIRR	ETF	25.09	25.136	25.05	25.053	9400.0
2019-03-13	AIVI	ETF	41.06	41.27	41.04	41.24	6000.0
2019-03-13	ALTY	ETF	14.73	14.74	14.7	14.72	5700.0
2019-03-13	AMJ	ETF	25.16	25.3	25.05	25.11	730595.0
2019-03-13	AMLP	ETF	49.65	49.85	49.35	49.45	2100360.0
2019-03-13	AMUB	ETF	15.8284	15.8284	15.8284	15.8284	0.0
2019-03-13	AMZA	ETF	59.5	59.85	59.3	59.5	49510.0
2019-03-13	ANGL	ETF	28.44	28.52	28.41	28.49	498100.0
2019-03-13	AOA	ETF	52.96	53.22	52.9	53.14	53400.0
2019-03-13	AOK	ETF	34.11	34.16	34.0909	34.12	57211.0
2019-03-13	AOM	ETF	37.62	37.73	37.6	37.66	117942.0
2019-03-13	AOR	ETF	44.24	44.3975	44.22	44.36	152590.0
2019-03-13	ARGT	ETF	28.01	28.71	28.01	28.5	71900.0
2019-03-13	ARKF	ETF	21.21	21.41	21.21	21.323	18900.0
2019-03-13	ARKG	ETF	32.23	32.619	31.929	32.49	193700.0
2019-03-13	ARKK	ETF	46.74	47.14	46.55	46.94	498200.0
2019-03-13	ARKQ	ETF	34.01	34.42	34.01	34.07	26000.0
2019-03-13	ARKW	ETF	51.79	52.2	51.54	51.9	91700.0
2019-03-13	ASEA	ETF	15.71	15.81	15.69	15.81	2300.0
2019-03-13	ASET	ETF	28.7	28.74	28.7	28.7399	1189.0
2019-03-13	ASHR	ETF	27.84	27.9	27.75	27.86	4279200.0

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

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