PREVIEW / etf_daily / 2019-01-11

all etf daily files

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

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-11	SPY	ETF	257.68	259.01	257.03	258.98	73858100.0
2019-01-11	QQQ	ETF	160.32	160.86	159.79	160.69	30176643.0
2019-01-11	IWM	ETF	143.01	143.99	142.68	143.68	22428400.0
2019-01-11	DIA	ETF	238.87	239.94	237.96	239.88	2047200.0
2019-01-11	GLD	ETF	121.74	122.05	121.66	121.8	8622400.0
2019-01-11	TLT	ETF	120.83	121.27	120.68	120.93	5786900.0
2019-01-11	AAAU	ETF	12.88	12.9	12.87	12.87	15900.0
2019-01-11	AADR	ETF	42.52	42.83	42.52	42.79	17400.0
2019-01-11	AAXJ	ETF	65.28	65.55	65.17	65.47	1019300.0
2019-01-11	ACES	ETF	24.41	24.61	24.41	24.47	12200.0
2019-01-11	ACSI	ETF	30.1504	30.2647	30.1504	30.2647	1067.0
2019-01-11	ACTX	ETF	50.1505	56.0505	47.2004	50.1505	688.0
2019-01-11	ACWF	ETF	27.02	27.1801	27.02	27.11	11835.0
2019-01-11	ACWI	ETF	66.41	66.66	66.28	66.62	15803900.0
2019-01-11	ACWV	ETF	82.69	82.9	82.55	82.84	397000.0
2019-01-11	ACWX	ETF	43.47	43.62	43.4	43.54	8168654.0
2019-01-11	ADRE	ETF	38.34	38.43	38.22	38.43	11576.0
2019-01-11	AFIF	ETF	9.5	9.95	9.5	9.94	23133.0
2019-01-11	AFK	ETF	20.77	20.77	20.5769	20.58	26301.0
2019-01-11	AFTY	ETF	13.66	13.798	13.66	13.798	7200.0
2019-01-11	AGG	ETF	106.58	106.66	106.5	106.55	5759000.0
2019-01-11	AGGY	ETF	48.4	48.45	48.37	48.406	59600.0
2019-01-11	AGNG	ETF	20.01	20.01	20.01	20.01	800.0
2019-01-11	AGQ	ETF	26.61	26.89	26.59	26.68	57300.0
2019-01-11	AGZ	ETF	112.11	112.25	112.11	112.21	17981.0
2019-01-11	AGZD	ETF	23.695	23.81	23.68	23.685	9000.0
2019-01-11	AIA	ETF	56.82	57.05	56.7	56.92	22261.0
2019-01-11	AIEQ	ETF	23.36	23.38	23.14	23.35	26600.0
2019-01-11	AIQ	ETF	13.71	13.81	13.66	13.79	22638.0
2019-01-11	AIRR	ETF	23.23	23.39	23.162	23.38	58200.0
2019-01-11	AIVI	ETF	39.11	39.25	39.09	39.16	214300.0
2019-01-11	ALTY	ETF	14.05	14.085	14.05	14.085	3200.0
2019-01-11	AMJ	ETF	24.59	24.865	24.41	24.46	4795847.0
2019-01-11	AMLP	ETF	48.65	48.75	48.05	48.1	5705160.0
2019-01-11	AMUB	ETF	15.4039	15.4039	15.4039	15.4039	0.0
2019-01-11	AMZA	ETF	58.3	58.9	57.6	58.0	89340.0
2019-01-11	ANGL	ETF	27.85	27.9	27.71	27.85	490300.0
2019-01-11	AOA	ETF	49.95	50.08	49.9	50.01	111100.0
2019-01-11	AOK	ETF	33.12	33.1533	33.08	33.1	1275988.0
2019-01-11	AOM	ETF	36.23	36.29	36.18	36.25	1483277.0
2019-01-11	AOR	ETF	42.15	42.25	42.12	42.18	432333.0
2019-01-11	ARCM	ETF	99.73	99.765	99.73	99.765	2200.0
2019-01-11	ARGT	ETF	26.01	26.32	25.89	26.25	26600.0
2019-01-11	ARKG	ETF	27.98	28.19	27.68	28.08	94300.0
2019-01-11	ARKK	ETF	41.28	41.89	41.16	41.78	312500.0
2019-01-11	ARKQ	ETF	31.05	31.44	31.05	31.35	45400.0
2019-01-11	ARKW	ETF	46.65	46.98	46.432	46.89	68100.0
2019-01-11	ASEA	ETF	16.01	16.02	15.96	15.96	2000.0
2019-01-11	ASET	ETF	26.66	26.66	26.66	26.66	190.0
2019-01-11	ASHR	ETF	22.89	23.04	22.84	23.03	891400.0

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

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