PREVIEW / etf_daily / 2019-01-14

all etf daily files

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

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-14	SPY	ETF	256.86	258.3	256.41	257.4	70908200.0
2019-01-14	QQQ	ETF	159.32	159.96	158.59	159.27	30710234.0
2019-01-14	IWM	ETF	142.82	143.44	142.09	142.25	29185000.0
2019-01-14	DIA	ETF	237.93	239.65	237.64	238.94	2330700.0
2019-01-14	GLD	ETF	122.15	122.24	121.87	122.09	6477100.0
2019-01-14	TLT	ETF	120.9	121.01	120.24	120.48	6730500.0
2019-01-14	AAAU	ETF	12.91	12.91	12.89	12.91	4300.0
2019-01-14	AADR	ETF	42.72	42.72	42.19	42.27	12400.0
2019-01-14	AAXJ	ETF	64.63	65.03	64.48	64.73	894600.0
2019-01-14	ACES	ETF	25.14	25.14	24.06	24.189	1800.0
2019-01-14	ACSI	ETF	30.21	30.21	29.92	30.08	2885.0
2019-01-14	ACTX	ETF	47.2004	56.0505	47.2004	51.9205	358.0
2019-01-14	ACWF	ETF	27.04	27.1103	26.97	26.99	102789.0
2019-01-14	ACWI	ETF	66.15	66.47	66.02	66.24	4467500.0
2019-01-14	ACWV	ETF	82.55	82.68	82.4	82.53	220100.0
2019-01-14	ACWX	ETF	43.21	43.4501	43.17	43.32	8538354.0
2019-01-14	ADRE	ETF	37.87	38.15	37.8204	38.0762	5882.0
2019-01-14	AFIF	ETF	9.9629	9.9798	9.9301	9.955	10089.0
2019-01-14	AFK	ETF	20.73	20.73	20.5071	20.5071	2690.0
2019-01-14	AFTY	ETF	13.588	13.639	13.588	13.639	200.0
2019-01-14	AGG	ETF	106.57	106.61	106.4	106.4	7544300.0
2019-01-14	AGGY	ETF	48.43	48.44	48.34	48.371	53100.0
2019-01-14	AGNG	ETF	20.01	20.01	20.01	20.01	100.0
2019-01-14	AGQ	ETF	26.83	26.91	26.66	26.82	217200.0
2019-01-14	AGZ	ETF	112.1601	112.21	112.1001	112.18	14480.0
2019-01-14	AGZD	ETF	23.685	23.7	23.315	23.7	108200.0
2019-01-14	AIA	ETF	56.08	56.39	55.9874	56.19	95581.0
2019-01-14	AIEQ	ETF	23.11	23.28	23.04	23.25	47800.0
2019-01-14	AIQ	ETF	13.68	13.7315	13.59	13.67	11007.0
2019-01-14	AIRR	ETF	23.17	23.4	23.141	23.19	47800.0
2019-01-14	AIVI	ETF	38.88	39.03	38.88	38.96	10800.0
2019-01-14	ALTY	ETF	14.1	14.15	14.086	14.09	1900.0
2019-01-14	AMJ	ETF	24.34	24.48	24.18	24.21	3269297.0
2019-01-14	AMLP	ETF	47.9	48.2	47.55	47.7	5063380.0
2019-01-14	AMUB	ETF	15.281	15.281	15.281	15.281	0.0
2019-01-14	AMZA	ETF	57.5	58.0	56.79	57.3	78680.0
2019-01-14	ANGL	ETF	27.82	27.89	27.75	27.8	218700.0
2019-01-14	AOA	ETF	49.77	49.94	49.75	49.86	398500.0
2019-01-14	AOK	ETF	33.04	33.11	33.04	33.11	355013.0
2019-01-14	AOM	ETF	36.16	36.21	36.135	36.17	609956.0
2019-01-14	AOR	ETF	42.03	42.1375	42.03	42.05	471659.0
2019-01-14	ARCM	ETF	99.74	99.815	99.74	99.815	200.0
2019-01-14	ARGT	ETF	26.0	26.34	25.81	26.18	35400.0
2019-01-14	ARKG	ETF	27.72	27.807	27.36	27.36	78800.0
2019-01-14	ARKK	ETF	41.2	41.494	40.9	41.03	257100.0
2019-01-14	ARKQ	ETF	31.18	31.19	30.865	30.9	17400.0
2019-01-14	ARKW	ETF	46.38	46.64	46.004	46.45	55700.0
2019-01-14	ASEA	ETF	15.9	16.01	15.9	15.94	4100.0
2019-01-14	ASET	ETF	26.67	26.67	26.6599	26.6599	493.0
2019-01-14	ASHR	ETF	22.73	22.84	22.68	22.75	901700.0

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

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