PREVIEW / etf_daily / 2018-08-14

all etf daily files

  file:    by_date/etf_daily/2018/2018-08-14.parquet
  size:    62 KB
  rows:    1,594

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
2018-08-14	SPY	ETF	282.92	284.17	282.48	283.9	43842000.0
2018-08-14	QQQ	ETF	181.01	181.66	180.04	181.45	20913021.0
2018-08-14	IWM	ETF	166.91	168.6	166.89	168.2	17683100.0
2018-08-14	DIA	ETF	252.76	253.55	252.23	253.21	2815800.0
2018-08-14	GLD	ETF	113.25	113.48	112.84	113.07	7085900.0
2018-08-14	TLT	ETF	120.54	120.56	120.03	120.14	4251200.0
2018-08-14	AADR	ETF	51.69	51.79	51.13	51.21	153500.0
2018-08-14	AAXJ	ETF	70.24	70.44	70.04	70.29	554600.0
2018-08-14	ACES	ETF	25.97	25.97	25.97	25.97	100.0
2018-08-14	ACSI	ETF	33.47	33.72	33.444	33.72	1679.0
2018-08-14	ACTX	ETF	56.0505	56.0505	51.3305	56.0505	455.0
2018-08-14	ACWF	ETF	30.21	30.3794	30.21	30.3372	10895.0
2018-08-14	ACWI	ETF	72.45	72.64	72.27	72.55	1365400.0
2018-08-14	ACWV	ETF	85.36	85.61	85.29	85.51	113200.0
2018-08-14	ACWX	ETF	46.97	47.0	46.7969	46.96	271910.0
2018-08-14	ADRE	ETF	40.78	40.78	40.4	40.573	3200.0
2018-08-14	AFK	ETF	22.31	22.39	22.0	22.35	17103.0
2018-08-14	AFTY	ETF	14.509	14.56	14.488	14.49	17700.0
2018-08-14	AGG	ETF	106.3	106.33	106.16	106.19	6087400.0
2018-08-14	AGGY	ETF	48.75	48.77	48.712	48.72	19700.0
2018-08-14	AGNG	ETF	21.082	21.274	21.082	21.274	6900.0
2018-08-14	AGQ	ETF	25.68	25.88	25.58	25.8	65500.0
2018-08-14	AGZ	ETF	111.16	111.2	111.01	111.01	6824.0
2018-08-14	AGZD	ETF	23.935	24.0	23.935	23.955	4400.0
2018-08-14	AIA	ETF	61.57	61.69	61.43	61.69	183906.0
2018-08-14	AIEQ	ETF	28.96	29.09	28.911	29.07	26500.0
2018-08-14	AIQ	ETF	15.2	15.3	15.2	15.2938	5409.0
2018-08-14	AIRR	ETF	27.15	27.47	27.094	27.42	11500.0
2018-08-14	AIVI	ETF	41.87	41.87	41.71	41.79	7900.0
2018-08-14	ALTY	ETF	15.3	15.31	15.23	15.25	12000.0
2018-08-14	AMJ	ETF	29.14	29.23	28.96	29.12	1185238.0
2018-08-14	AMLP	ETF	55.4	55.5	55.0	55.2	2252420.0
2018-08-14	AMZA	ETF	80.0	80.6	79.8	80.3	65890.0
2018-08-14	ANGL	ETF	28.9	28.98	28.9	28.96	166800.0
2018-08-14	AOA	ETF	53.69	53.83	53.63	53.83	38700.0
2018-08-14	AOK	ETF	34.03	34.09	34.01	34.07	56960.0
2018-08-14	AOM	ETF	37.58	37.6599	37.53	37.59	74999.0
2018-08-14	AOR	ETF	44.55	44.6299	44.5001	44.61	36746.0
2018-08-14	ARGT	ETF	27.48	27.81	27.48	27.64	351800.0
2018-08-14	ARKG	ETF	30.75	31.22	30.75	30.97	118300.0
2018-08-14	ARKK	ETF	46.85	47.033	46.5	46.88	253300.0
2018-08-14	ARKQ	ETF	36.16	36.2	35.82	36.05	40600.0
2018-08-14	ARKW	ETF	57.49	57.616	56.92	57.55	121500.0
2018-08-14	ARVR	ETF	21.13	21.13	20.88	20.88	312.0
2018-08-14	ASEA	ETF	15.87	15.87	15.87	15.87	300.0
2018-08-14	ASET	ETF	27.95	28.03	27.95	27.98	5613.0
2018-08-14	ASHR	ETF	24.83	24.92	24.79	24.89	519500.0
2018-08-14	ASHS	ETF	26.69	26.76	26.69	26.76	400.0
2018-08-14	ASHX	ETF	17.67	17.67	17.67	17.67	101.0
2018-08-14	ATMP	ETF	22.09	22.17	22.02	22.06	290300.0

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

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