PREVIEW / etf_daily / 2019-03-22

all etf daily files

  file:    by_date/etf_daily/2019/2019-03-22.parquet
  size:    68 KB
  rows:    1,768

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-03-22	SPY	ETF	283.22	283.8	279.18	279.25	122659300.0
2019-03-22	QQQ	ETF	181.76	182.27	178.37	178.56	70794543.0
2019-03-22	IWM	ETF	154.2	154.54	149.57	149.62	40663000.0
2019-03-22	DIA	ETF	257.92	258.64	254.87	254.96	6226500.0
2019-03-22	GLD	ETF	123.93	124.22	123.73	123.97	5874000.0
2019-03-22	TLT	ETF	124.21	125.28	124.06	124.86	13077000.0
2019-03-22	AAAU	ETF	13.1	13.14	13.1	13.12	10600.0
2019-03-22	AADR	ETF	45.92	45.92	45.1	45.22	7800.0
2019-03-22	AAXJ	ETF	70.49	70.56	69.56	69.56	1846400.0
2019-03-22	ACES	ETF	27.13	27.13	26.781	26.781	2200.0
2019-03-22	ACSI	ETF	32.6101	32.6101	32.1771	32.1771	1209.0
2019-03-22	ACTX	ETF	82.6007	82.6007	47.2004	60.7705	871.0
2019-03-22	ACWF	ETF	29.12	29.12	28.67	28.67	21614.0
2019-03-22	ACWI	ETF	72.24	72.35	71.33	71.34	4214500.0
2019-03-22	ACWV	ETF	88.69	89.01	88.34	88.36	224900.0
2019-03-22	ACWX	ETF	46.28	46.37	45.83	45.83	1830498.0
2019-03-22	ADRE	ETF	40.9	40.9	40.45	40.46	4845.0
2019-03-22	AFIF	ETF	12.0	12.0	9.98	10.0	15520.0
2019-03-22	AFK	ETF	21.89	22.09	21.6	21.6	4049.0
2019-03-22	AFTY	ETF	16.48	16.48	16.25	16.3	6700.0
2019-03-22	AGG	ETF	108.46	108.76	108.37	108.62	2464100.0
2019-03-22	AGGY	ETF	49.63	49.76	49.63	49.76	55700.0
2019-03-22	AGNG	ETF	21.64	21.64	21.253	21.4	1300.0
2019-03-22	AGQ	ETF	25.56	25.68	25.41	25.53	127000.0
2019-03-22	AGZ	ETF	113.12	113.36	113.12	113.33	56808.0
2019-03-22	AGZD	ETF	23.885	23.935	23.835	23.835	33400.0
2019-03-22	AIA	ETF	61.37	61.37	60.5853	60.59	19463.0
2019-03-22	AIEQ	ETF	26.15	26.15	25.56	25.56	72300.0
2019-03-22	AIQ	ETF	16.03	16.03	15.67	15.67	31059.0
2019-03-22	AIRR	ETF	24.58	24.581	23.78	23.78	14400.0
2019-03-22	AIVI	ETF	41.55	41.61	41.33	41.34	13200.0
2019-03-22	ALTY	ETF	14.801	14.83	14.742	14.742	13000.0
2019-03-22	AMJ	ETF	25.68	25.91	25.4	25.52	1720199.0
2019-03-22	AMLP	ETF	50.55	50.75	50.05	50.3	2227120.0
2019-03-22	AMUB	ETF	16.0719	16.0719	16.0719	16.0719	0.0
2019-03-22	AMZA	ETF	60.3	60.4	59.3	59.6	71490.0
2019-03-22	ANGL	ETF	28.68	28.72	28.58	28.61	133900.0
2019-03-22	AOA	ETF	53.6	53.6	53.01	53.01	49200.0
2019-03-22	AOK	ETF	34.45	34.45	34.33	34.34	37536.0
2019-03-22	AOM	ETF	38.05	38.05	37.83	37.85	44341.0
2019-03-22	AOR	ETF	44.72	44.72	44.3964	44.41	93972.0
2019-03-22	ARGT	ETF	28.56	28.58	27.86	28.1	44600.0
2019-03-22	ARKF	ETF	21.64	21.67	21.16	21.166	32000.0
2019-03-22	ARKG	ETF	33.38	33.58	31.98	31.99	204700.0
2019-03-22	ARKK	ETF	47.81	47.945	46.04	46.05	555800.0
2019-03-22	ARKQ	ETF	34.74	34.74	33.61	33.625	17900.0
2019-03-22	ARKW	ETF	52.71	52.956	51.311	51.35	114700.0
2019-03-22	ASEA	ETF	15.79	15.79	15.65	15.73	2200.0
2019-03-22	ASET	ETF	28.7501	28.7501	28.68	28.71	462.0
2019-03-22	ASHR	ETF	28.41	28.47	28.05	28.08	8157800.0

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

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