PREVIEW / etf_daily / 2019-06-05

all etf daily files

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

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-06-05	SPY	ETF	282.33	282.99	280.32	282.96	71169700.0
2019-06-05	QQQ	ETF	176.6	176.61	174.38	176.21	34412697.0
2019-06-05	IWM	ETF	150.76	150.89	148.61	150.19	18184100.0
2019-06-05	DIA	ETF	255.22	255.8	254.07	255.73	2792400.0
2019-06-05	GLD	ETF	126.18	126.37	125.24	125.47	7637900.0
2019-06-05	TLT	ETF	130.52	130.95	130.12	130.19	8815200.0
2019-06-05	AAAU	ETF	13.36	13.36	13.26	13.27	28300.0
2019-06-05	AADR	ETF	47.48	47.48	46.77	47.03	5400.0
2019-06-05	AAXJ	ETF	66.63	66.63	65.93	66.17	891600.0
2019-06-05	ACES	ETF	27.99	27.99	27.83	27.848	2500.0
2019-06-05	ACSI	ETF	32.71	32.86	32.71	32.86	2618.0
2019-06-05	ACTX	ETF	31.8603	31.8603	26.5502	29.5003	506.0
2019-06-05	ACWF	ETF	28.32	28.32	28.19	28.26	5136.0
2019-06-05	ACWI	ETF	71.67	71.68	71.19	71.61	2512200.0
2019-06-05	ACWV	ETF	90.86	91.21	90.7	91.21	580700.0
2019-06-05	ACWX	ETF	45.76	45.76	45.4334	45.55	679547.0
2019-06-05	ADRE	ETF	37.745	37.835	37.7255	37.835	1318.0
2019-06-05	AFIF	ETF	9.9104	9.93	9.9	9.915	6678.0
2019-06-05	AFK	ETF	20.81	20.81	20.5891	20.76	7933.0
2019-06-05	AFTY	ETF	16.034	16.05	16.034	16.05	700.0
2019-06-05	AGG	ETF	110.36	110.47	110.23	110.24	3253500.0
2019-06-05	AGGY	ETF	50.64	50.688	50.56	50.61	127500.0
2019-06-05	AGNG	ETF	20.56	20.56	20.5	20.545	1200.0
2019-06-05	AGQ	ETF	23.72	23.72	23.06	23.14	213600.0
2019-06-05	AGZ	ETF	114.79	114.79	114.6401	114.7099	12318.0
2019-06-05	AGZD	ETF	23.755	23.755	23.705	23.705	2200.0
2019-06-05	AIA	ETF	57.74	57.74	57.28	57.43	48536.0
2019-06-05	AIEQ	ETF	25.5	25.52	25.26	25.46	20400.0
2019-06-05	AIQ	ETF	15.48	15.48	15.34	15.45	2277.0
2019-06-05	AIRR	ETF	25.02	25.063	24.82	24.94	7800.0
2019-06-05	AIVI	ETF	40.45	40.45	40.16	40.22	4600.0
2019-06-05	ALTY	ETF	14.75	14.75	14.53	14.625	5600.0
2019-06-05	AMJ	ETF	24.98	24.98	24.48	24.56	721928.0
2019-06-05	AMLP	ETF	49.1	49.1	48.2	48.65	1860480.0
2019-06-05	AMOM	ETF	24.921	24.921	24.921	24.921	100.0
2019-06-05	AMUB	ETF	15.485	15.485	15.485	15.485	2.0
2019-06-05	AMZA	ETF	54.9	54.9	53.6	53.9	72360.0
2019-06-05	ANGL	ETF	28.51	28.61	28.38	28.5	623700.0
2019-06-05	AOA	ETF	53.3	53.3	53.08	53.2	22900.0
2019-06-05	AOK	ETF	34.63	34.6772	34.61	34.67	55827.0
2019-06-05	AOM	ETF	38.2	38.2	38.0879	38.18	291954.0
2019-06-05	AOR	ETF	44.64	44.69	44.5415	44.61	224848.0
2019-06-05	ARGT	ETF	28.71	28.72	28.4	28.61	73100.0
2019-06-05	ARKF	ETF	21.31	21.418	21.09	21.37	18000.0
2019-06-05	ARKG	ETF	30.2	30.23	29.81	29.93	86100.0
2019-06-05	ARKK	ETF	42.33	42.36	41.641	42.11	551700.0
2019-06-05	ARKQ	ETF	30.26	30.5	29.75	30.12	19100.0
2019-06-05	ARKW	ETF	48.45	48.66	47.611	48.46	104200.0
2019-06-05	ASEA	ETF	16.17	16.17	15.91	15.94	3000.0
2019-06-05	ASET	ETF	28.97	29.08	28.97	28.99	1562.0

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

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