PREVIEW / etf_daily / 2018-11-29

all etf daily files

  file:    by_date/etf_daily/2018/2018-11-29.parquet
  size:    64 KB
  rows:    1,675

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-11-29	SPY	ETF	273.71	275.55	272.43	273.98	82346400.0
2018-11-29	QQQ	ETF	168.0	169.26	166.82	168.15	44885711.0
2018-11-29	IWM	ETF	151.61	152.74	150.44	151.83	15134500.0
2018-11-29	DIA	ETF	253.6	254.97	252.22	253.59	3471100.0
2018-11-29	GLD	ETF	115.97	116.24	115.56	115.74	6479300.0
2018-11-29	TLT	ETF	114.92	115.25	114.59	114.9	7295600.0
2018-11-29	AAAU	ETF	12.26	12.27	12.22	12.24	8600.0
2018-11-29	AADR	ETF	43.99	44.44	43.99	44.35	17600.0
2018-11-29	AAXJ	ETF	66.73	67.02	66.26	66.65	699700.0
2018-11-29	ACES	ETF	25.28	25.287	25.27	25.287	1000.0
2018-11-29	ACSI	ETF	32.8	32.8655	32.73	32.8655	4000.0
2018-11-29	ACTX	ETF	60.7705	64.3106	60.1805	60.7705	433.0
2018-11-29	ACWF	ETF	28.4511	28.6189	28.36	28.46	5448.0
2018-11-29	ACWI	ETF	69.59	69.99	69.32	69.62	2948500.0
2018-11-29	ACWV	ETF	86.0	86.46	85.88	86.06	158800.0
2018-11-29	ACWX	ETF	44.66	44.84	44.49	44.7	2836838.0
2018-11-29	ADRE	ETF	38.38	38.38	38.2	38.349	5492.0
2018-11-29	AFIF	ETF	10.0037	10.03	9.98	10.0079	33026.0
2018-11-29	AFK	ETF	20.96	20.96	20.65	20.7249	24124.0
2018-11-29	AFTY	ETF	14.05	14.14	13.85	14.14	11900.0
2018-11-29	AGG	ETF	104.92	104.99	104.84	104.91	5922600.0
2018-11-29	AGGY	ETF	47.52	47.52	47.43	47.48	45100.0
2018-11-29	AGNG	ETF	20.64	20.69	20.5	20.5	3800.0
2018-11-29	AGQ	ETF	22.84	23.03	22.66	22.74	266000.0
2018-11-29	AGZ	ETF	110.82	110.9043	110.79	110.8162	9841.0
2018-11-29	AGZD	ETF	23.745	23.775	23.72	23.755	12800.0
2018-11-29	AIA	ETF	57.95	58.2431	57.56	57.98	66361.0
2018-11-29	AIEQ	ETF	26.42	26.6	26.22	26.41	27100.0
2018-11-29	AIQ	ETF	14.0	14.12	13.91	14.09	39367.0
2018-11-29	AIRR	ETF	25.0	25.065	24.861	24.88	15600.0
2018-11-29	AIVI	ETF	39.83	39.98	39.77	39.88	3600.0
2018-11-29	ALTY	ETF	14.512	14.52	14.47	14.52	13400.0
2018-11-29	AMJ	ETF	24.73	25.0	24.45	24.8	4249769.0
2018-11-29	AMLP	ETF	47.75	48.7	47.7	48.2	4119500.0
2018-11-29	AMUB	ETF	15.5901	15.5901	15.5901	15.5901	100.0
2018-11-29	AMZA	ETF	61.0	62.6	60.9	62.1	109930.0
2018-11-29	ANGL	ETF	27.44	27.58	27.43	27.5	265300.0
2018-11-29	AOA	ETF	51.68	51.89	51.5	51.72	138100.0
2018-11-29	AOK	ETF	33.32	33.415	33.27	33.36	168126.0
2018-11-29	AOM	ETF	36.67	36.75	36.565	36.68	407027.0
2018-11-29	AOR	ETF	43.1	43.3899	43.0289	43.21	243126.0
2018-11-29	ARGT	ETF	25.23	25.95	25.23	25.86	113000.0
2018-11-29	ARKG	ETF	29.46	30.022	29.298	29.7	99700.0
2018-11-29	ARKK	ETF	43.99	44.48	43.39	44.05	157400.0
2018-11-29	ARKQ	ETF	32.87	33.26	32.856	32.95	11100.0
2018-11-29	ARKW	ETF	53.43	53.87	52.51	53.445	215400.0
2018-11-29	ARVR	ETF	17.77	17.77	17.77	17.77	178.0
2018-11-29	ASEA	ETF	15.83	15.83	15.83	15.83	300.0
2018-11-29	ASET	ETF	27.1599	27.2301	27.1599	27.2301	1122.0
2018-11-29	ASHR	ETF	23.0	23.18	22.92	23.06	2258500.0

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

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