PREVIEW / etf_daily / 2019-02-07

all etf daily files

  file:    by_date/etf_daily/2019/2019-02-07.parquet
  size:    67 KB
  rows:    1,746

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-02-07	SPY	ETF	270.94	271.55	268.29	270.14	95482000.0
2019-02-07	QQQ	ETF	169.03	169.4499	166.95	168.23	42036193.0
2019-02-07	IWM	ETF	149.92	150.7	148.39	149.69	22850800.0
2019-02-07	DIA	ETF	252.4	253.34	250.17	251.9	3884800.0
2019-02-07	GLD	ETF	123.8	123.95	123.44	123.74	5935500.0
2019-02-07	TLT	ETF	121.46	121.91	121.23	121.83	8781000.0
2019-02-07	AAAU	ETF	13.09	13.1	13.08	13.09	17300.0
2019-02-07	AADR	ETF	44.27	44.27	43.54	43.87	7800.0
2019-02-07	AAXJ	ETF	68.63	68.91	67.89	68.49	701700.0
2019-02-07	ACES	ETF	25.85	25.85	25.59	25.744	10100.0
2019-02-07	ACSI	ETF	31.5301	31.6599	31.52	31.6599	909.0
2019-02-07	ACTX	ETF	47.2004	48.3804	44.2504	47.7904	657.0
2019-02-07	ACWF	ETF	28.47	28.51	28.28	28.37	21878.0
2019-02-07	ACWI	ETF	69.4	69.45	68.69	69.05	3067000.0
2019-02-07	ACWV	ETF	85.46	85.57	84.99	85.42	142400.0
2019-02-07	ACWX	ETF	44.95	45.05	44.59	44.76	4703638.0
2019-02-07	ADRE	ETF	40.0	40.0	39.2	39.59	3971.0
2019-02-07	AFIF	ETF	9.983	9.9927	9.97	9.9911	13045.0
2019-02-07	AFK	ETF	22.03	22.03	21.59	21.7875	7656.0
2019-02-07	AFTY	ETF	14.756	14.79	14.65	14.701	3100.0
2019-02-07	AGG	ETF	107.15	107.2	107.03	107.1	3938900.0
2019-02-07	AGGY	ETF	48.9	48.96	48.86	48.96	71200.0
2019-02-07	AGNG	ETF	20.86	20.903	20.69	20.782	4500.0
2019-02-07	AGQ	ETF	26.81	27.05	26.74	27.0	72000.0
2019-02-07	AGZ	ETF	112.08	112.1899	112.08	112.18	26088.0
2019-02-07	AGZD	ETF	23.785	23.865	23.78	23.78	6600.0
2019-02-07	AIA	ETF	60.0	60.25	59.41	59.91	94122.0
2019-02-07	AIEQ	ETF	24.83	24.91	24.653	24.8	36200.0
2019-02-07	AIQ	ETF	14.86	14.86	14.6	14.688	102528.0
2019-02-07	AIRR	ETF	24.25	24.25	23.74	23.93	22600.0
2019-02-07	AIVI	ETF	40.14	40.14	39.87	39.96	6900.0
2019-02-07	ALTY	ETF	14.65	14.65	14.54	14.54	10500.0
2019-02-07	AMJ	ETF	25.03	25.03	24.39	24.56	3568097.0
2019-02-07	AMLP	ETF	49.45	49.45	48.05	48.5	4937540.0
2019-02-07	AMUB	ETF	15.48	15.48	15.48	15.48	0.0
2019-02-07	AMZA	ETF	58.9	58.93	56.8	57.5	111840.0
2019-02-07	ANGL	ETF	28.17	28.21	28.09	28.19	425700.0
2019-02-07	AOA	ETF	51.71	51.75	51.35	51.56	45000.0
2019-02-07	AOK	ETF	33.71	33.71	33.57	33.64	74106.0
2019-02-07	AOM	ETF	37.03	37.03	36.87	37.01	379966.0
2019-02-07	AOR	ETF	43.34	43.41	43.13	43.26	145186.0
2019-02-07	ARGT	ETF	27.58	27.58	26.95	27.3	36000.0
2019-02-07	ARKF	ETF	20.29	20.32	20.0	20.17	58200.0
2019-02-07	ARKG	ETF	28.07	28.236	27.34	27.59	77600.0
2019-02-07	ARKK	ETF	43.37	43.44	42.125	42.49	373700.0
2019-02-07	ARKQ	ETF	33.41	33.59	32.92	33.115	85600.0
2019-02-07	ARKW	ETF	49.64	49.64	48.5	49.27	117300.0
2019-02-07	ASEA	ETF	16.16	16.16	16.03	16.05	18700.0
2019-02-07	ASET	ETF	27.74	27.7639	27.67	27.67	1147.0
2019-02-07	ASHR	ETF	24.02	24.16	23.85	23.95	1562900.0

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

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