PREVIEW / etf_daily / 2019-01-16

all etf daily files

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

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-16	SPY	ETF	260.83	261.97	260.6	260.98	77636700.0
2019-01-16	QQQ	ETF	162.63	163.78	162.29	162.35	33812190.0
2019-01-16	IWM	ETF	143.68	145.25	143.67	144.52	20827300.0
2019-01-16	DIA	ETF	241.36	242.9	241.14	241.86	3718500.0
2019-01-16	GLD	ETF	122.04	122.44	122.02	122.27	6878100.0
2019-01-16	TLT	ETF	119.59	120.39	119.51	120.16	6048400.0
2019-01-16	AAAU	ETF	12.91	12.94	12.91	12.93	163700.0
2019-01-16	AADR	ETF	42.74	42.74	42.51	42.51	9900.0
2019-01-16	AAXJ	ETF	65.86	66.43	65.86	66.17	905900.0
2019-01-16	ACES	ETF	24.604	24.604	24.37	24.447	14300.0
2019-01-16	ACSI	ETF	30.4801	30.5177	30.46	30.5177	1820.0
2019-01-16	ACTX	ETF	50.7405	53.1005	49.5604	51.9205	348.0
2019-01-16	ACWF	ETF	27.3087	27.4	27.26	27.26	1397770.0
2019-01-16	ACWI	ETF	67.0	67.26	66.94	67.03	4148500.0
2019-01-16	ACWV	ETF	82.99	83.23	82.92	83.1	281400.0
2019-01-16	ACWX	ETF	43.65	43.8868	43.65	43.81	3444000.0
2019-01-16	ADRE	ETF	38.39	38.6728	38.39	38.6728	3334.0
2019-01-16	AFIF	ETF	9.93	9.9797	9.91	9.9448	10528.0
2019-01-16	AFK	ETF	20.758	20.76	20.6907	20.73	6304.0
2019-01-16	AFTY	ETF	14.027	14.1	14.027	14.06	5500.0
2019-01-16	AGG	ETF	106.33	106.52	106.31	106.51	4007800.0
2019-01-16	AGGY	ETF	48.32	48.45	48.31	48.425	36600.0
2019-01-16	AGNG	ETF	20.4	20.4	20.254	20.313	1500.0
2019-01-16	AGQ	ETF	26.74	26.84	26.63	26.64	97700.0
2019-01-16	AGZ	ETF	112.09	112.1532	111.9801	112.12	36259.0
2019-01-16	AGZD	ETF	23.625	23.735	23.625	23.71	32400.0
2019-01-16	AIA	ETF	57.24	57.76	57.24	57.45	32378.0
2019-01-16	AIEQ	ETF	23.59	23.7	23.54	23.64	86300.0
2019-01-16	AIQ	ETF	13.87	13.955	13.845	13.87	13291.0
2019-01-16	AIRR	ETF	23.3	23.477	23.3	23.34	47400.0
2019-01-16	AIVI	ETF	38.95	39.06	38.95	39.01	6700.0
2019-01-16	ALTY	ETF	14.186	14.3	14.186	14.3	11600.0
2019-01-16	AMJ	ETF	24.64	24.86	24.6	24.68	2301253.0
2019-01-16	AMLP	ETF	48.6	49.05	48.6	48.65	3838280.0
2019-01-16	AMUB	ETF	15.5728	15.5728	15.5728	15.5728	0.0
2019-01-16	AMZA	ETF	58.6	59.26	58.6	58.8	71000.0
2019-01-16	ANGL	ETF	27.92	27.96	27.85	27.9	308400.0
2019-01-16	AOA	ETF	50.2	50.45	50.2	50.29	130400.0
2019-01-16	AOK	ETF	33.11	33.25	33.1	33.24	78402.0
2019-01-16	AOM	ETF	36.27	36.4	36.27	36.38	264609.0
2019-01-16	AOR	ETF	42.28	42.47	42.28	42.36	140604.0
2019-01-16	ARCM	ETF	99.8	99.875	99.8	99.875	200.0
2019-01-16	ARGT	ETF	26.3	26.5	26.1	26.22	27500.0
2019-01-16	ARKG	ETF	28.28	28.89	28.28	28.33	190500.0
2019-01-16	ARKK	ETF	42.33	43.013	42.23	42.31	344600.0
2019-01-16	ARKQ	ETF	31.66	32.113	31.59	31.62	29500.0
2019-01-16	ARKW	ETF	47.5	47.992	47.42	47.58	157600.0
2019-01-16	ASEA	ETF	15.86	16.18	15.86	16.14	2300.0
2019-01-16	ASET	ETF	26.84	26.8897	26.84	26.8897	586.0
2019-01-16	ASHR	ETF	23.27	23.45	23.27	23.38	3292800.0

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

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