PREVIEW / etf_daily / 2020-01-07

all etf daily files

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

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-07	SPY	ETF	323.02	323.54	322.24	322.73	40496400.0
2020-01-07	QQQ	ETF	215.64	216.14	214.85	215.53	23120994.0
2020-01-07	IWM	ETF	164.85	165.34	164.21	164.8	11817900.0
2020-01-07	DIA	ETF	286.3	286.79	285.58	285.74	1413000.0
2020-01-07	GLD	ETF	147.57	148.14	147.43	147.97	7978500.0
2020-01-07	TLT	ETF	138.22	138.47	137.64	137.65	8381200.0
2020-01-07	AAAU	ETF	15.64	15.7	15.64	15.68	35000.0
2020-01-07	AADR	ETF	54.35	54.52	54.19	54.43	10900.0
2020-01-07	AAXJ	ETF	73.58	73.74	73.4	73.68	580100.0
2020-01-07	ACES	ETF	34.72	34.805	34.6	34.75	27800.0
2020-01-07	ACIO	ETF	26.06	26.06	25.505	25.525	7700.0
2020-01-07	ACSI	ETF	35.42	35.44	35.3601	35.3695	2262.0
2020-01-07	ACTX	ETF	12.3901	13.5701	12.3901	12.3901	46.0
2020-01-07	ACWF	ETF	31.13	31.15	31.08	31.117	4900.0
2020-01-07	ACWI	ETF	79.46	79.56	79.29	79.36	2312900.0
2020-01-07	ACWV	ETF	95.85	95.85	95.58	95.68	212100.0
2020-01-07	ACWX	ETF	49.14	49.165	49.02	49.1	1026558.0
2020-01-07	ADME	ETF	30.54	30.54	30.432	30.48	21000.0
2020-01-07	ADRE	ETF	44.77	45.0199	44.717	44.93	36890.0
2020-01-07	AESR	ETF	10.1	10.47	10.085	10.085	2200.0
2020-01-07	AFIF	ETF	9.72	9.735	9.72	9.735	536.0
2020-01-07	AFK	ETF	20.32	20.32	20.13	20.165	6774.0
2020-01-07	AFLG	ETF	20.42	20.42	20.397	20.397	100.0
2020-01-07	AFMC	ETF	20.301	20.301	20.301	20.301	100.0
2020-01-07	AFTY	ETF	17.513	17.513	17.48	17.504	3600.0
2020-01-07	AGG	ETF	112.92	112.92	112.78	112.8	2883000.0
2020-01-07	AGGY	ETF	52.46	52.47	52.39	52.42	155100.0
2020-01-07	AGNG	ETF	23.69	23.81	23.64	23.651	10600.0
2020-01-07	AGQ	ETF	32.7	33.62	32.55	33.44	505300.0
2020-01-07	AGZ	ETF	116.05	116.05	116.0001	116.015	27593.0
2020-01-07	AGZD	ETF	24.06	24.085	24.03	24.06	5800.0
2020-01-07	AIA	ETF	66.22	66.5041	66.13	66.43	32429.0
2020-01-07	AIEQ	ETF	28.68	28.81	28.642	28.77	29300.0
2020-01-07	AIQ	ETF	18.3	18.39	18.24	18.3402	20262.0
2020-01-07	AIRR	ETF	28.97	28.985	28.85	28.97	13200.0
2020-01-07	AIVI	ETF	42.66	42.66	42.58	42.59	100900.0
2020-01-07	ALTY	ETF	14.88	14.88	14.827	14.87	11300.0
2020-01-07	AMJ	ETF	22.58	22.69	22.39	22.6	1766014.0
2020-01-07	AMLP	ETF	44.1	44.35	43.75	44.2	3426320.0
2020-01-07	AMOM	ETF	25.962	25.962	25.962	25.962	100.0
2020-01-07	AMUB	ETF	14.26	14.2658	14.26	14.2658	1110.0
2020-01-07	AMZA	ETF	46.6	47.1	46.2	47.1	80670.0
2020-01-07	ANGL	ETF	29.92	29.95	29.89	29.95	395400.0
2020-01-07	AOA	ETF	58.21	58.21	58.0	58.09	54700.0
2020-01-07	AOK	ETF	36.38	36.38	36.33	36.34	73129.0
2020-01-07	AOM	ETF	40.25	40.25	40.1928	40.23	217517.0
2020-01-07	AOR	ETF	47.98	47.98	47.85	47.91	152124.0
2020-01-07	ARCM	ETF	100.11	100.17	100.11	100.17	1100.0
2020-01-07	ARGT	ETF	26.45	26.54	26.21	26.54	25900.0
2020-01-07	ARKF	ETF	24.55	24.735	24.55	24.68	25300.0

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

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