PREVIEW / etf_daily / 2020-01-23

all etf daily files

  file:    by_date/etf_daily/2020/2020-01-23.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-23	SPY	ETF	330.63	332.17	329.41	331.72	51963000.0
2020-01-23	QQQ	ETF	223.71	224.69	222.7	224.59	26496113.0
2020-01-23	IWM	ETF	167.1	167.97	165.45	167.45	15954300.0
2020-01-23	DIA	ETF	290.75	291.86	289.6	291.54	1872600.0
2020-01-23	GLD	ETF	147.0	147.62	146.62	147.12	8419800.0
2020-01-23	TLT	ETF	140.85	141.38	140.78	140.94	9747400.0
2020-01-23	AAAU	ETF	15.54	15.64	15.54	15.59	125200.0
2020-01-23	AADR	ETF	55.72	55.72	55.39	55.57	26900.0
2020-01-23	AAXJ	ETF	73.4	73.91	73.03	73.79	3273300.0
2020-01-23	ABEQ	ETF	24.92	25.02	24.88	24.995	39500.0
2020-01-23	ACES	ETF	36.46	36.759	36.25	36.705	23300.0
2020-01-23	ACIO	ETF	25.655	25.76	25.645	25.734	68300.0
2020-01-23	ACSI	ETF	36.1315	36.5451	36.1315	36.5451	1430.0
2020-01-23	ACTX	ETF	10.918	11.9122	10.918	11.8001	26.0
2020-01-23	ACWF	ETF	31.5514	31.7195	31.5	31.7179	9783.0
2020-01-23	ACWI	ETF	80.68	80.96	80.35	80.94	2980400.0
2020-01-23	ACWV	ETF	98.27	98.66	98.1	98.64	331400.0
2020-01-23	ACWX	ETF	49.24	49.425	49.005	49.39	2102110.0
2020-01-23	ADME	ETF	31.14	31.34	31.14	31.3	120700.0
2020-01-23	ADRE	ETF	44.27	44.335	44.05	44.335	62226.0
2020-01-23	AESR	ETF	10.45	10.45	10.33	10.39	7100.0
2020-01-23	AFIF	ETF	9.755	9.7587	9.7543	9.7587	976.0
2020-01-23	AFK	ETF	20.28	20.28	20.0475	20.145	5211.0
2020-01-23	AFSM	ETF	20.7	20.786	20.7	20.786	1000.0
2020-01-23	AFTY	ETF	16.8	16.835	16.59	16.804	5900.0
2020-01-23	AGG	ETF	113.64	113.7	113.58	113.58	3429500.0
2020-01-23	AGGY	ETF	52.75	52.93	52.73	52.79	254600.0
2020-01-23	AGNG	ETF	24.09	24.32	24.09	24.24	2800.0
2020-01-23	AGQ	ETF	31.02	31.45	30.98	31.18	220700.0
2020-01-23	AGZ	ETF	116.43	116.5894	116.43	116.53	47348.0
2020-01-23	AGZD	ETF	24.045	24.085	23.995	24.04	8400.0
2020-01-23	AIA	ETF	66.69	67.1646	66.2994	67.15	32792.0
2020-01-23	AIEQ	ETF	29.56	29.69	29.39	29.69	12500.0
2020-01-23	AIQ	ETF	19.07	19.13	18.9652	19.115	15181.0
2020-01-23	AIRR	ETF	28.86	29.02	28.83	29.02	2800.0
2020-01-23	AIVI	ETF	42.5	42.58	42.3	42.58	6900.0
2020-01-23	ALTY	ETF	15.04	15.05	14.985	15.04	6300.0
2020-01-23	AMJ	ETF	21.47	21.8	21.3	21.66	3805180.0
2020-01-23	AMLP	ETF	42.2	42.5	41.5	42.2	4830160.0
2020-01-23	AMOM	ETF	27.068	27.068	27.068	27.068	100.0
2020-01-23	AMUB	ETF	13.64	13.695	13.64	13.6535	19348.0
2020-01-23	AMZA	ETF	43.0	43.3	42.1	43.0	103650.0
2020-01-23	ANGL	ETF	30.11	30.15	30.03	30.15	884000.0
2020-01-23	AOA	ETF	58.84	58.96	58.57	58.96	56000.0
2020-01-23	AOK	ETF	36.7	36.75	36.6201	36.72	125428.0
2020-01-23	AOM	ETF	40.68	40.7	40.5201	40.68	170833.0
2020-01-23	AOR	ETF	48.38	48.5374	48.3147	48.47	116463.0
2020-01-23	ARCM	ETF	100.15	100.15	100.15	100.15	10000.0
2020-01-23	ARGT	ETF	26.03	26.25	25.91	25.96	37000.0
2020-01-23	ARKF	ETF	25.47	25.65	25.359	25.61	23600.0

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

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