PREVIEW / etf_daily / 2019-06-27

all etf daily files

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

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-27	SPY	ETF	291.31	292.06	290.89	291.5	40355200.0
2019-06-27	QQQ	ETF	186.47	186.94	185.99	186.5	19709228.0
2019-06-27	IWM	ETF	151.24	153.77	151.24	153.63	22278400.0
2019-06-27	DIA	ETF	265.45	265.91	264.5	265.15	1991500.0
2019-06-27	GLD	ETF	132.38	132.97	132.26	132.84	8412800.0
2019-06-27	TLT	ETF	132.31	133.09	131.99	132.9	9724200.0
2019-06-27	AAAU	ETF	14.02	14.06	14.01	14.06	26400.0
2019-06-27	AADR	ETF	49.01	49.26	48.95	49.26	6200.0
2019-06-27	AAXJ	ETF	69.79	69.99	69.68	69.96	2413000.0
2019-06-27	ACES	ETF	29.07	29.384	29.07	29.367	5700.0
2019-06-27	ACSI	ETF	33.3301	33.488	33.3301	33.488	1339.0
2019-06-27	ACTX	ETF	32.4503	32.4503	26.4322	28.9103	541.0
2019-06-27	ACWF	ETF	29.0186	29.08	28.9671	29.08	3162.0
2019-06-27	ACWI	ETF	73.31	73.47	73.24	73.4	1761300.0
2019-06-27	ACWV	ETF	91.74	91.94	91.63	91.89	211200.0
2019-06-27	ACWX	ETF	46.65	46.74	46.62	46.71	801112.0
2019-06-27	ADRE	ETF	40.02	40.095	39.8694	40.0658	2535.0
2019-06-27	AFIF	ETF	9.88	9.91	9.87	9.89	24295.0
2019-06-27	AFK	ETF	21.95	22.11	21.95	22.065	3116.0
2019-06-27	AFTY	ETF	17.379	17.385	17.37	17.385	600.0
2019-06-27	AGG	ETF	111.25	111.41	111.16	111.4	2963600.0
2019-06-27	AGGY	ETF	51.09	51.24	51.09	51.205	46400.0
2019-06-27	AGNG	ETF	21.064	21.115	21.064	21.115	2500.0
2019-06-27	AGQ	ETF	24.32	24.5	24.21	24.46	200500.0
2019-06-27	AGZ	ETF	115.14	115.29	115.14	115.27	21089.0
2019-06-27	AGZD	ETF	23.785	23.84	23.76	23.79	17800.0
2019-06-27	AIA	ETF	61.19	61.28	61.055	61.25	32716.0
2019-06-27	AIEQ	ETF	26.05	26.24	26.05	26.15	28600.0
2019-06-27	AIQ	ETF	16.1	16.2277	16.1	16.2	5207.0
2019-06-27	AIRR	ETF	25.51	25.97	25.51	25.97	10500.0
2019-06-27	AIVI	ETF	41.02	41.09	41.01	41.05	4200.0
2019-06-27	ALTY	ETF	14.77	14.902	14.77	14.902	6600.0
2019-06-27	AMJ	ETF	24.9	24.9	24.65	24.78	882455.0
2019-06-27	AMLP	ETF	48.95	48.95	48.5	48.6	1910840.0
2019-06-27	AMUB	ETF	15.5828	15.5828	15.5828	15.5828	2.0
2019-06-27	AMZA	ETF	54.7	55.0	54.5	54.5	40790.0
2019-06-27	ANGL	ETF	29.2	29.28	29.19	29.23	224700.0
2019-06-27	AOA	ETF	54.86	54.93	54.79	54.92	23700.0
2019-06-27	AOK	ETF	35.26	35.33	35.232	35.33	74252.0
2019-06-27	AOM	ETF	38.88	39.0251	38.87	38.93	80969.0
2019-06-27	AOR	ETF	45.83	45.9	45.752	45.89	47185.0
2019-06-27	ARGT	ETF	31.61	31.98	31.47	31.76	44400.0
2019-06-27	ARKF	ETF	22.37	22.52	22.37	22.509	12800.0
2019-06-27	ARKG	ETF	32.29	33.05	32.2	33.01	132100.0
2019-06-27	ARKK	ETF	44.83	45.84	44.83	45.82	277500.0
2019-06-27	ARKQ	ETF	32.17	32.83	32.17	32.81	77000.0
2019-06-27	ARKW	ETF	51.0	51.45	50.84	51.37	40500.0
2019-06-27	ASEA	ETF	16.33	16.57	16.33	16.57	3200.0
2019-06-27	ASET	ETF	29.18	29.2399	29.18	29.23	1298.0
2019-06-27	ASHR	ETF	28.13	28.14	28.0	28.01	3193900.0

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

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