PREVIEW / etf_daily / 2019-01-28

all etf daily files

  file:    by_date/etf_daily/2019/2019-01-28.parquet
  size:    67 KB
  rows:    1,740

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-01-28	SPY	ETF	263.39	263.83	261.79	263.76	85613700.0
2019-01-28	QQQ	ETF	163.03	163.12	161.75	163.11	33491216.0
2019-01-28	IWM	ETF	145.96	146.91	145.37	146.55	22784700.0
2019-01-28	DIA	ETF	244.73	245.23	243.14	245.1	3560300.0
2019-01-28	GLD	ETF	122.75	123.29	122.72	123.29	8522200.0
2019-01-28	TLT	ETF	120.54	120.94	120.41	120.41	6435800.0
2019-01-28	AAAU	ETF	12.98	13.04	12.98	13.03	188000.0
2019-01-28	AADR	ETF	42.54	43.08	42.54	43.0	53700.0
2019-01-28	AAXJ	ETF	66.98	67.19	66.74	67.18	1507800.0
2019-01-28	ACES	ETF	26.27	26.27	24.81	24.883	3200.0
2019-01-28	ACSI	ETF	30.75	30.8674	30.75	30.8674	1650.0
2019-01-28	ACTX	ETF	51.3305	54.8705	47.2004	49.5604	1469.0
2019-01-28	ACWF	ETF	27.86	27.9078	27.8	27.89	5546.0
2019-01-28	ACWI	ETF	67.83	67.9	67.44	67.9	9778000.0
2019-01-28	ACWV	ETF	83.52	83.73	83.35	83.71	261700.0
2019-01-28	ACWX	ETF	44.17	44.365	44.13	44.34	7964321.0
2019-01-28	ADRE	ETF	38.67	38.8248	38.54	38.7345	3608.0
2019-01-28	AFIF	ETF	10.05	10.05	9.94	9.97	11373.0
2019-01-28	AFK	ETF	20.97	20.98	20.92	20.98	1985.0
2019-01-28	AFTY	ETF	14.29	14.4	14.29	14.384	3500.0
2019-01-28	AGG	ETF	106.62	106.75	106.58	106.62	7365700.0
2019-01-28	AGGY	ETF	48.49	48.51	48.44	48.51	56000.0
2019-01-28	AGNG	ETF	20.41	20.6	20.41	20.41	10100.0
2019-01-28	AGQ	ETF	26.65	27.13	26.63	27.12	127000.0
2019-01-28	AGZ	ETF	112.07	112.15	112.01	112.045	24541.0
2019-01-28	AGZD	ETF	23.75	23.75	23.48	23.71	70600.0
2019-01-28	AIA	ETF	58.91	59.12	58.8001	59.11	92316.0
2019-01-28	AIEQ	ETF	24.12	24.22	23.997	24.168	29600.0
2019-01-28	AIQ	ETF	14.24	14.24	14.1314	14.224	13298.0
2019-01-28	AIRR	ETF	23.46	23.64	23.32	23.57	23700.0
2019-01-28	AIVI	ETF	39.37	39.57	39.37	39.54	10900.0
2019-01-28	ALTY	ETF	14.42	14.48	14.408	14.44	10700.0
2019-01-28	AMJ	ETF	24.56	24.83	24.48	24.64	3696936.0
2019-01-28	AMLP	ETF	48.55	48.85	48.2	48.45	5224900.0
2019-01-28	AMZA	ETF	57.5	57.9	56.8	57.8	121460.0
2019-01-28	ANGL	ETF	27.89	27.93	27.83	27.85	216500.0
2019-01-28	AOA	ETF	50.79	50.81	50.57	50.79	660500.0
2019-01-28	AOK	ETF	33.39	33.39	33.31	33.38	583122.0
2019-01-28	AOM	ETF	36.58	36.58	36.48	36.56	1105781.0
2019-01-28	AOR	ETF	42.7	42.71	42.55	42.7	573318.0
2019-01-28	ARGT	ETF	26.67	27.17	26.55	27.09	32300.0
2019-01-28	ARKG	ETF	27.75	27.98	27.23	27.39	46000.0
2019-01-28	ARKK	ETF	41.76	41.89	41.16	41.68	282700.0
2019-01-28	ARKQ	ETF	31.65	31.728	31.39	31.59	12900.0
2019-01-28	ARKW	ETF	48.11	48.16	47.28	48.15	130300.0
2019-01-28	ASEA	ETF	16.06	16.07	15.97	15.97	6400.0
2019-01-28	ASET	ETF	27.19	27.2062	27.19	27.2062	400.0
2019-01-28	ASHR	ETF	23.64	23.71	23.59	23.66	1190000.0
2019-01-28	ASHS	ETF	23.41	23.43	23.41	23.43	14200.0
2019-01-28	ASHX	ETF	17.11	17.11	17.11	17.11	200.0

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

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