PREVIEW / etf_daily / 2019-07-12

all etf daily files

  file:    by_date/etf_daily/2019/2019-07-12.parquet
  size:    69 KB
  rows:    1,815

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-07-12	SPY	ETF	299.85	300.73	299.51	300.65	40326000.0
2019-07-12	QQQ	ETF	192.63	193.54	192.45	193.53	20211883.0
2019-07-12	IWM	ETF	155.14	156.67	154.88	156.11	16678000.0
2019-07-12	DIA	ETF	271.66	273.39	271.6	273.39	2411200.0
2019-07-12	GLD	ETF	132.89	133.69	132.53	133.53	6309500.0
2019-07-12	TLT	ETF	129.92	130.45	129.68	130.22	6992000.0
2019-07-12	AAAU	ETF	14.07	14.15	14.05	14.13	30000.0
2019-07-12	AADR	ETF	50.73	50.81	50.57	50.67	10800.0
2019-07-12	AAXJ	ETF	69.37	69.46	69.21	69.38	687800.0
2019-07-12	ACES	ETF	30.38	30.38	30.255	30.333	4300.0
2019-07-12	ACIO	ETF	25.15	25.22	25.15	25.22	229600.0
2019-07-12	ACSI	ETF	34.445	34.55	34.445	34.5411	1610.0
2019-07-12	ACTX	ETF	26.8865	26.8865	26.8806	26.8806	152.0
2019-07-12	ACWF	ETF	29.6305	29.76	29.6301	29.7353	3879.0
2019-07-12	ACWI	ETF	74.7	74.85	74.58	74.85	792200.0
2019-07-12	ACWV	ETF	93.38	93.38	93.03	93.27	264500.0
2019-07-12	ACWX	ETF	46.84	46.88	46.74	46.88	398576.0
2019-07-12	ADRE	ETF	40.41	40.48	40.3169	40.43	9305.0
2019-07-12	AFIF	ETF	9.95	9.95	9.91	9.935	3492.0
2019-07-12	AFK	ETF	22.13	22.13	22.0	22.0	2569.0
2019-07-12	AFTY	ETF	17.37	17.429	17.369	17.429	1800.0
2019-07-12	AGG	ETF	110.67	110.85	110.67	110.79	3836300.0
2019-07-12	AGGY	ETF	51.0	51.12	51.0	51.1	85400.0
2019-07-12	AGNG	ETF	21.09	21.31	21.09	21.31	900.0
2019-07-12	AGQ	ETF	24.0	24.38	23.92	24.31	134000.0
2019-07-12	AGZ	ETF	114.54	114.69	114.54	114.67	24473.0
2019-07-12	AGZD	ETF	23.895	23.915	23.895	23.905	32000.0
2019-07-12	AIA	ETF	60.95	61.08	60.8	61.08	23366.0
2019-07-12	AIEQ	ETF	26.9	27.024	26.887	26.97	28600.0
2019-07-12	AIQ	ETF	16.8	16.81	16.71	16.81	18896.0
2019-07-12	AIRR	ETF	25.92	26.335	25.92	26.335	3500.0
2019-07-12	AIVI	ETF	41.1	41.1	41.01	41.07	7100.0
2019-07-12	ALTY	ETF	15.075	15.15	15.042	15.12	6600.0
2019-07-12	AMJ	ETF	25.79	25.89	25.7	25.78	678061.0
2019-07-12	AMLP	ETF	50.65	50.85	50.5	50.6	1254700.0
2019-07-12	AMOM	ETF	26.55	26.615	26.44	26.615	900.0
2019-07-12	AMUB	ETF	16.2347	16.2347	16.2347	16.2347	0.0
2019-07-12	AMZA	ETF	57.4	57.9	57.4	57.8	40060.0
2019-07-12	ANGL	ETF	29.19	29.24	29.12	29.2	211800.0
2019-07-12	AOA	ETF	55.03	55.17	54.96	55.17	46600.0
2019-07-12	AOK	ETF	35.25	35.27	35.23	35.27	52457.0
2019-07-12	AOM	ETF	38.83	38.87	38.77	38.87	80161.0
2019-07-12	AOR	ETF	45.82	45.89	45.76	45.89	90708.0
2019-07-12	ARGT	ETF	33.68	33.95	33.67	33.89	19300.0
2019-07-12	ARKF	ETF	23.22	23.3	23.153	23.28	15000.0
2019-07-12	ARKG	ETF	33.73	33.928	33.45	33.64	190800.0
2019-07-12	ARKK	ETF	48.41	48.58	48.09	48.46	196700.0
2019-07-12	ARKQ	ETF	33.72	33.96	33.72	33.96	12700.0
2019-07-12	ARKW	ETF	53.93	54.17	53.9	54.17	100700.0
2019-07-12	ASEA	ETF	16.53	16.65	16.52	16.62	1400.0

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

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