PREVIEW / etf_daily / 2020-01-17

all etf daily files

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

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-17	SPY	ETF	331.7	332.18	330.85	331.95	95846000.0
2020-01-17	QQQ	ETF	223.24	223.56	222.1221	223.38	24325167.0
2020-01-17	IWM	ETF	170.28	170.56	168.67	169.07	18306400.0
2020-01-17	DIA	ETF	293.52	293.61	292.79	293.27	2147400.0
2020-01-17	GLD	ETF	146.51	146.99	146.31	146.58	11121100.0
2020-01-17	TLT	ETF	137.58	138.14	137.36	138.02	9693100.0
2020-01-17	AAAU	ETF	15.53	15.58	15.51	15.53	91600.0
2020-01-17	AADR	ETF	56.26	56.26	55.95	55.96	6000.0
2020-01-17	AAXJ	ETF	76.15	76.23	75.94	76.23	1091600.0
2020-01-17	ACES	ETF	36.46	36.63	36.46	36.604	10600.0
2020-01-17	ACIO	ETF	25.791	25.81	25.76	25.808	3200.0
2020-01-17	ACSI	ETF	36.3	36.3659	36.3	36.3659	1411.0
2020-01-17	ACTX	ETF	11.8001	12.6851	11.8001	11.806	155.0
2020-01-17	ACWF	ETF	31.85	31.89	31.83	31.8759	4673.0
2020-01-17	ACWI	ETF	81.34	81.39	81.14	81.31	1912400.0
2020-01-17	ACWV	ETF	98.03	98.29	98.02	98.29	414800.0
2020-01-17	ACWX	ETF	49.95	50.03	49.875	50.0	1036977.0
2020-01-17	ADME	ETF	31.25	31.25	31.19	31.213	5000.0
2020-01-17	ADRE	ETF	45.3776	45.44	45.21	45.44	4728.0
2020-01-17	AESR	ETF	10.37	10.38	10.355	10.375	1100.0
2020-01-17	AFIF	ETF	9.73	9.73	9.7	9.715	1137.0
2020-01-17	AFK	ETF	20.34	20.6	20.34	20.5	11870.0
2020-01-17	AFLG	ETF	20.923	20.959	20.923	20.959	300.0
2020-01-17	AFMC	ETF	20.809	20.809	20.809	20.809	100.0
2020-01-17	AFSM	ETF	20.85	20.859	20.85	20.859	300.0
2020-01-17	AFTY	ETF	17.73	17.786	17.73	17.785	4900.0
2020-01-17	AGG	ETF	113.02	113.1	112.97	113.05	3003300.0
2020-01-17	AGGY	ETF	52.59	52.64	52.57	52.63	163400.0
2020-01-17	AGNG	ETF	24.283	24.283	24.105	24.105	600.0
2020-01-17	AGQ	ETF	32.05	32.26	31.75	32.02	338300.0
2020-01-17	AGZ	ETF	115.95	116.08	115.95	116.01	46357.0
2020-01-17	AGZD	ETF	24.135	24.14	24.065	24.11	50800.0
2020-01-17	AIA	ETF	68.83	69.1	68.81	69.1	49786.0
2020-01-17	AIEQ	ETF	29.62	29.648	29.513	29.59	65400.0
2020-01-17	AIQ	ETF	19.05	19.05	18.92	18.98	37176.0
2020-01-17	AIRR	ETF	29.69	29.69	29.331	29.44	9900.0
2020-01-17	AIVI	ETF	43.1	43.1	42.98	43.06	4300.0
2020-01-17	ALTY	ETF	15.06	15.12	15.04	15.075	194800.0
2020-01-17	AMJ	ETF	22.75	22.8358	22.5401	22.61	4125403.0
2020-01-17	AMLP	ETF	44.5	44.55	44.0	44.2	4787380.0
2020-01-17	AMOM	ETF	26.94	27.0	26.94	27.0	800.0
2020-01-17	AMUB	ETF	14.29	14.29	14.25	14.25	274134.0
2020-01-17	AMZA	ETF	47.2	47.25	46.5	46.7	76260.0
2020-01-17	ANGL	ETF	30.21	30.25	30.12	30.16	484600.0
2020-01-17	AOA	ETF	59.06	59.21	59.05	59.2	66500.0
2020-01-17	AOK	ETF	36.56	36.68	36.56	36.68	92101.0
2020-01-17	AOM	ETF	40.69	40.69	40.56	40.68	169003.0
2020-01-17	AOR	ETF	48.6	48.61	48.5281	48.61	80908.0
2020-01-17	ARCM	ETF	100.09	100.09	100.09	100.09	100.0
2020-01-17	ARGT	ETF	26.43	26.83	26.43	26.78	102900.0

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

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