PREVIEW / etf_daily / 2019-12-16

all etf daily files

  file:    by_date/etf_daily/2019/2019-12-16.parquet
  size:    73 KB
  rows:    1,915

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-12-16	SPY	ETF	319.22	320.15	317.25	319.5	82749700.0
2019-12-16	QQQ	ETF	208.5	209.53	208.48	209.27	21366177.0
2019-12-16	IWM	ETF	164.06	164.85	163.74	163.88	20115300.0
2019-12-16	DIA	ETF	282.93	284.11	282.93	283.07	2117200.0
2019-12-16	GLD	ETF	139.2	139.39	138.8	139.04	4646100.0
2019-12-16	TLT	ETF	138.4	138.46	137.43	137.79	9156600.0
2019-12-16	AAAU	ETF	14.74	14.77	14.7	14.72	29000.0
2019-12-16	AADR	ETF	52.9	53.16	52.82	53.13	4800.0
2019-12-16	AAXJ	ETF	72.01	72.18	71.9	72.02	1848500.0
2019-12-16	ACES	ETF	32.85	33.307	32.85	33.158	11000.0
2019-12-16	ACIO	ETF	25.637	25.67	25.6	25.631	19000.0
2019-12-16	ACSI	ETF	35.562	35.72	35.561	35.6452	1733.0
2019-12-16	ACTX	ETF	6.5196	9.1982	5.9591	7.0801	568.0
2019-12-16	ACWF	ETF	30.87	31.01	30.86	30.8891	17627.0
2019-12-16	ACWI	ETF	78.52	78.68	78.47	78.51	1588000.0
2019-12-16	ACWV	ETF	95.0	95.01	94.73	94.94	199400.0
2019-12-16	ACWX	ETF	48.89	48.9583	48.82	48.82	1423381.0
2019-12-16	ADME	ETF	30.67	30.67	30.649	30.649	10700.0
2019-12-16	ADRE	ETF	43.94	44.08	43.878	43.9032	8768.0
2019-12-16	AFIF	ETF	9.74	9.74	9.7103	9.7198	1532.0
2019-12-16	AFK	ETF	20.67	20.75	20.67	20.75	5979.0
2019-12-16	AFLG	ETF	20.37	20.37	20.315	20.315	100.0
2019-12-16	AFSM	ETF	20.55	20.55	20.452	20.452	200.0
2019-12-16	AFTY	ETF	17.12	17.12	16.997	17.021	6300.0
2019-12-16	AGG	ETF	112.68	112.69	112.5	112.58	5012100.0
2019-12-16	AGGY	ETF	52.35	52.35	52.28	52.32	118100.0
2019-12-16	AGNG	ETF	23.77	23.862	23.65	23.65	5800.0
2019-12-16	AGQ	ETF	28.74	28.97	28.63	28.89	235700.0
2019-12-16	AGZ	ETF	115.95	115.95	115.7921	115.8281	27717.0
2019-12-16	AGZD	ETF	24.05	24.095	24.05	24.07	25000.0
2019-12-16	AIA	ETF	64.62	64.7493	64.47	64.63	46841.0
2019-12-16	AIEQ	ETF	28.01	28.2	28.0	28.11	38800.0
2019-12-16	AIQ	ETF	17.66	17.6799	17.57	17.585	13403.0
2019-12-16	AIRR	ETF	28.99	29.11	28.9	28.9	3000.0
2019-12-16	AIVI	ETF	43.22	43.32	43.22	43.26	4900.0
2019-12-16	ALTY	ETF	14.74	14.876	14.74	14.875	19100.0
2019-12-16	AMJ	ETF	20.97	21.28	20.97	21.27	3704215.0
2019-12-16	AMLP	ETF	40.85	41.5	40.8	41.5	7851060.0
2019-12-16	AMOM	ETF	27.251	27.251	27.251	27.251	100.0
2019-12-16	AMUB	ETF	13.3742	13.3742	13.3742	13.3742	0.0
2019-12-16	AMZA	ETF	43.1	43.9	43.1	43.9	67280.0
2019-12-16	ANGL	ETF	29.7	29.76	29.68	29.76	281900.0
2019-12-16	AOA	ETF	58.01	58.24	58.0	58.14	42300.0
2019-12-16	AOK	ETF	36.32	36.3543	36.28	36.32	120771.0
2019-12-16	AOM	ETF	40.27	40.36	40.22	40.22	294296.0
2019-12-16	AOR	ETF	47.95	48.0	47.92	47.98	77392.0
2019-12-16	ARCM	ETF	100.285	100.285	100.19	100.265	1200.0
2019-12-16	ARGT	ETF	25.11	25.19	25.01	25.12	51000.0
2019-12-16	ARKF	ETF	23.91	24.12	23.91	24.08	9100.0
2019-12-16	ARKG	ETF	34.84	35.24	34.556	35.15	158200.0

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

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