PREVIEW / etf_daily / 2019-05-17

all etf daily files

  file:    by_date/etf_daily/2019/2019-05-17.parquet
  size:    69 KB
  rows:    1,794

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-05-17	SPY	ETF	285.14	288.6	285.12	285.84	100353000.0
2019-05-17	QQQ	ETF	183.1	185.5813	182.88	183.04	44702276.0
2019-05-17	IWM	ETF	153.82	155.27	152.66	152.84	21534000.0
2019-05-17	DIA	ETF	256.36	259.39	256.21	257.44	3652900.0
2019-05-17	GLD	ETF	121.03	121.06	120.33	120.65	6589300.0
2019-05-17	TLT	ETF	126.28	126.3	125.69	125.99	4747100.0
2019-05-17	AAAU	ETF	12.81	12.81	12.74	12.76	8200.0
2019-05-17	AADR	ETF	45.96	45.96	45.04	45.05	32300.0
2019-05-17	AAXJ	ETF	66.42	66.79	66.23	66.38	3360100.0
2019-05-17	ACES	ETF	28.2	28.2	28.02	28.026	2600.0
2019-05-17	ACSI	ETF	33.0477	33.2513	33.0477	33.0562	981.0
2019-05-17	ACTX	ETF	38.3503	40.7045	38.3503	38.3503	258.0
2019-05-17	ACWF	ETF	28.4	28.5641	28.3416	28.353	7374.0
2019-05-17	ACWI	ETF	71.96	72.56	71.94	71.99	2023600.0
2019-05-17	ACWV	ETF	89.4	90.0	89.4	89.65	147300.0
2019-05-17	ACWX	ETF	45.53	45.76	45.495	45.51	932738.0
2019-05-17	ADRE	ETF	38.76	38.8	38.2516	38.2516	4709.0
2019-05-17	AFIF	ETF	9.88	9.969	9.88	9.945	7565.0
2019-05-17	AFK	ETF	21.15	21.16	20.863	20.8698	37245.0
2019-05-17	AFTY	ETF	16.062	16.18	16.03	16.03	8400.0
2019-05-17	AGG	ETF	109.12	109.15	108.94	109.03	2090800.0
2019-05-17	AGGY	ETF	50.09	50.09	50.0	50.07	72100.0
2019-05-17	AGNG	ETF	20.466	20.597	20.466	20.597	900.0
2019-05-17	AGQ	ETF	22.06	22.07	21.9	21.99	311400.0
2019-05-17	AGZ	ETF	113.71	113.7408	113.6	113.64	172377.0
2019-05-17	AGZD	ETF	23.935	23.935	23.835	23.86	5600.0
2019-05-17	AIA	ETF	58.22	58.52	58.17	58.18	26144.0
2019-05-17	AIEQ	ETF	25.99	26.306	25.97	26.11	24600.0
2019-05-17	AIQ	ETF	16.18	16.27	16.0	16.0	9839.0
2019-05-17	AIRR	ETF	24.8	24.915	24.682	24.682	1200.0
2019-05-17	AIVI	ETF	40.4	40.46	40.32	40.35	7300.0
2019-05-17	ALTY	ETF	14.88	14.89	14.86	14.863	7400.0
2019-05-17	AMJ	ETF	25.9	25.945	25.74	25.76	910110.0
2019-05-17	AMLP	ETF	50.3	50.3	49.9	50.0	2384340.0
2019-05-17	AMUB	ETF	16.2476	16.2476	16.2476	16.2476	0.0
2019-05-17	AMZA	ETF	57.9	58.0	57.3	57.4	77170.0
2019-05-17	ANGL	ETF	28.73	28.85	28.73	28.8	155000.0
2019-05-17	AOA	ETF	53.28	53.66	53.28	53.31	27100.0
2019-05-17	AOK	ETF	34.5	34.5537	34.4485	34.46	25988.0
2019-05-17	AOM	ETF	37.97	38.08	37.9	38.0	71511.0
2019-05-17	AOR	ETF	44.56	44.7782	44.52	44.62	42086.0
2019-05-17	ARCM	ETF	100.72	100.725	100.72	100.725	200.0
2019-05-17	ARGT	ETF	28.21	28.48	27.87	27.98	108700.0
2019-05-17	ARKF	ETF	21.97	22.13	21.87	21.87	22500.0
2019-05-17	ARKG	ETF	31.43	31.57	30.93	31.04	89700.0
2019-05-17	ARKK	ETF	44.48	44.776	43.87	43.96	294900.0
2019-05-17	ARKQ	ETF	32.59	32.59	31.89	31.92	15300.0
2019-05-17	ARKW	ETF	51.58	51.886	50.88	50.97	134900.0
2019-05-17	ASEA	ETF	15.57	15.64	15.47	15.47	2100.0
2019-05-17	ASET	ETF	29.0106	29.02	29.0106	29.02	801.0

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

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