PREVIEW / etf_daily / 2020-01-16

all etf daily files

  file:    by_date/etf_daily/2020/2020-01-16.parquet
  size:    74 KB
  rows:    1,942

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
2020-01-16	SPY	ETF	329.7	330.92	329.45	330.92	54050300.0
2020-01-16	QQQ	ETF	221.24	222.32	220.8	222.28	18804959.0
2020-01-16	IWM	ETF	168.59	169.87	168.43	169.53	19976200.0
2020-01-16	DIA	ETF	291.63	292.97	291.47	292.93	2522000.0
2020-01-16	GLD	ETF	146.27	146.47	145.76	146.31	6069100.0
2020-01-16	TLT	ETF	139.26	139.53	138.74	139.21	6798600.0
2020-01-16	AAAU	ETF	15.5	15.5	15.45	15.49	78200.0
2020-01-16	AADR	ETF	55.7	55.74	55.51	55.69	7100.0
2020-01-16	AAXJ	ETF	75.88	75.98	75.72	75.85	297000.0
2020-01-16	ACES	ETF	36.32	36.424	36.13	36.36	21000.0
2020-01-16	ACIO	ETF	25.707	25.763	25.707	25.763	17500.0
2020-01-16	ACSI	ETF	36.1625	36.2498	36.16	36.2498	966.0
2020-01-16	ACTX	ETF	11.2101	12.3901	11.2101	11.806	210.0
2020-01-16	ACWF	ETF	31.6367	31.73	31.6367	31.7289	3951.0
2020-01-16	ACWI	ETF	80.85	81.1	80.81	81.09	1401800.0
2020-01-16	ACWV	ETF	97.54	97.91	97.5	97.88	349600.0
2020-01-16	ACWX	ETF	49.72	49.84	49.71	49.83	667239.0
2020-01-16	ADME	ETF	30.86	31.18	30.86	31.18	32000.0
2020-01-16	ADRE	ETF	45.46	45.46	45.16	45.175	6582.0
2020-01-16	AESR	ETF	10.29	10.325	10.29	10.325	10400.0
2020-01-16	AFIF	ETF	9.7354	9.7354	9.7224	9.73	3154.0
2020-01-16	AFK	ETF	20.37	20.58	20.37	20.49	9460.0
2020-01-16	AFLG	ETF	20.901	20.901	20.901	20.901	100.0
2020-01-16	AFMC	ETF	20.836	20.836	20.836	20.836	100.0
2020-01-16	AFSM	ETF	20.846	20.907	20.846	20.907	1100.0
2020-01-16	AFTY	ETF	17.79	17.79	17.69	17.71	2600.0
2020-01-16	AGG	ETF	113.16	113.21	113.05	113.18	2801400.0
2020-01-16	AGGY	ETF	52.63	52.65	52.59	52.63	757400.0
2020-01-16	AGNG	ETF	24.22	24.3	24.165	24.2	3600.0
2020-01-16	AGQ	ETF	31.86	32.0	31.66	31.85	299000.0
2020-01-16	AGZ	ETF	116.22	116.22	116.0855	116.1423	44801.0
2020-01-16	AGZD	ETF	24.07	24.125	24.05	24.095	15800.0
2020-01-16	AIA	ETF	68.66	68.9299	68.64	68.8288	77136.0
2020-01-16	AIEQ	ETF	29.36	29.5	29.36	29.5	23700.0
2020-01-16	AIQ	ETF	18.92	19.02	18.91	18.985	7836.0
2020-01-16	AIRR	ETF	29.08	29.47	29.08	29.417	15500.0
2020-01-16	AIVI	ETF	42.78	42.92	42.76	42.91	2200.0
2020-01-16	ALTY	ETF	15.06	15.07	15.05	15.06	8400.0
2020-01-16	AMJ	ETF	22.8	22.86	22.71	22.75	1428416.0
2020-01-16	AMLP	ETF	44.5	44.65	44.3	44.4	2993260.0
2020-01-16	AMOM	ETF	26.84	26.9	26.84	26.9	200.0
2020-01-16	AMUB	ETF	14.3283	14.3283	14.3283	14.3283	0.0
2020-01-16	AMZA	ETF	46.9	47.31	46.9	47.2	58110.0
2020-01-16	ANGL	ETF	30.2	30.2	30.14	30.16	455300.0
2020-01-16	AOA	ETF	58.91	59.06	58.83	59.05	73400.0
2020-01-16	AOK	ETF	36.58	36.64	36.55	36.64	69856.0
2020-01-16	AOM	ETF	40.51	40.63	40.51	40.63	114494.0
2020-01-16	AOR	ETF	48.47	48.52	48.44	48.46	99583.0
2020-01-16	ARCM	ETF	100.0	100.075	100.0	100.075	1400.0
2020-01-16	ARGT	ETF	26.26	26.58	26.26	26.45	30000.0

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

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