PREVIEW / etf_daily / 2019-03-14

all etf daily files

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

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-14	SPY	ETF	281.37	281.84	280.67	281.16	67518400.0
2019-03-14	QQQ	ETF	177.115	177.34	176.66	176.71	23751477.0
2019-03-14	IWM	ETF	154.9	155.02	154.2	154.35	14217500.0
2019-03-14	DIA	ETF	257.33	257.94	256.62	257.54	3409600.0
2019-03-14	GLD	ETF	122.33	122.55	122.12	122.41	6778200.0
2019-03-14	TLT	ETF	121.69	121.76	120.92	120.95	8188400.0
2019-03-14	AAAU	ETF	12.93	12.96	12.92	12.95	21300.0
2019-03-14	AADR	ETF	45.41	45.5	45.3	45.35	8000.0
2019-03-14	AAXJ	ETF	69.46	69.48	69.16	69.36	698100.0
2019-03-14	ACES	ETF	27.47	27.47	27.275	27.275	5200.0
2019-03-14	ACSI	ETF	32.4	32.559	32.4	32.4902	2486.0
2019-03-14	ACTX	ETF	51.3305	52.5105	50.1505	51.9205	418.0
2019-03-14	ACWF	ETF	29.03	29.03	28.92	28.97	16908.0
2019-03-14	ACWI	ETF	71.52	71.61	71.37	71.48	1564200.0
2019-03-14	ACWV	ETF	88.22	88.24	87.92	88.07	107200.0
2019-03-14	ACWX	ETF	45.96	46.0251	45.9	45.96	982659.0
2019-03-14	ADRE	ETF	40.83	40.83	40.6894	40.7493	949.0
2019-03-14	AFIF	ETF	10.01	10.06	10.01	10.04	8607.0
2019-03-14	AFK	ETF	21.7	21.97	21.54	21.54	6783.0
2019-03-14	AFTY	ETF	16.09	16.133	16.09	16.133	1300.0
2019-03-14	AGG	ETF	107.57	107.58	107.39	107.43	2955400.0
2019-03-14	AGGY	ETF	49.2	49.2	49.1	49.125	199200.0
2019-03-14	AGNG	ETF	21.723	21.723	21.552	21.56	2600.0
2019-03-14	AGQ	ETF	24.81	24.85	24.62	24.8	273500.0
2019-03-14	AGZ	ETF	112.4801	112.5155	112.41	112.44	10244.0
2019-03-14	AGZD	ETF	23.85	23.91	23.83	23.83	3200.0
2019-03-14	AIA	ETF	60.47	60.475	60.31	60.46	36909.0
2019-03-14	AIEQ	ETF	25.91	25.92	25.82	25.83	14600.0
2019-03-14	AIQ	ETF	15.56	15.569	15.5	15.505	7056.0
2019-03-14	AIRR	ETF	24.95	24.95	24.77	24.8	14900.0
2019-03-14	AIVI	ETF	41.22	41.31	41.22	41.27	2900.0
2019-03-14	ALTY	ETF	14.722	14.73	14.712	14.72	2900.0
2019-03-14	AMJ	ETF	25.09	25.19	25.03	25.1	1035554.0
2019-03-14	AMLP	ETF	49.45	49.65	49.3	49.45	1465340.0
2019-03-14	AMUB	ETF	15.7864	15.7864	15.7864	15.7864	0.0
2019-03-14	AMZA	ETF	59.6	59.79	59.3	59.5	38870.0
2019-03-14	ANGL	ETF	28.47	28.5	28.36	28.46	433100.0
2019-03-14	AOA	ETF	53.14	53.15	53.0	53.1	78500.0
2019-03-14	AOK	ETF	34.13	34.147	34.09	34.12	20067.0
2019-03-14	AOM	ETF	37.71	37.71	37.62	37.66	48631.0
2019-03-14	AOR	ETF	44.35	44.35	44.27	44.33	84922.0
2019-03-14	ARGT	ETF	28.48	28.5	28.09	28.17	137500.0
2019-03-14	ARKF	ETF	21.22	21.3	21.22	21.242	30500.0
2019-03-14	ARKG	ETF	32.5	32.58	31.972	32.17	123700.0
2019-03-14	ARKK	ETF	46.96	47.07	46.53	46.64	227600.0
2019-03-14	ARKQ	ETF	33.95	34.241	33.95	34.0	14300.0
2019-03-14	ARKW	ETF	51.77	51.85	51.37	51.39	42900.0
2019-03-14	ASEA	ETF	15.74	15.79	15.68	15.79	900.0
2019-03-14	ASET	ETF	28.701	28.701	28.701	28.701	176.0
2019-03-14	ASHR	ETF	27.54	27.58	27.44	27.52	3087200.0

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

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