PREVIEW / etf_daily / 2018-10-18

all etf daily files

  file:    by_date/etf_daily/2018/2018-10-18.parquet
  size:    62 KB
  rows:    1,619

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-10-18	SPY	ETF	279.4	280.07	274.97	276.4	134557500.0
2018-10-18	QQQ	ETF	176.6	176.68	172.44	173.18	82486208.0
2018-10-18	IWM	ETF	157.41	157.63	154.37	155.0	31042700.0
2018-10-18	DIA	ETF	256.11	256.86	252.32	253.68	8694600.0
2018-10-18	GLD	ETF	115.83	116.41	115.63	115.92	7964100.0
2018-10-18	TLT	ETF	113.62	114.39	113.55	113.96	5728800.0
2018-10-18	AAAU	ETF	12.24	12.29	12.24	12.26	12200.0
2018-10-18	AADR	ETF	49.66	49.73	48.84	49.12	15000.0
2018-10-18	AAXJ	ETF	64.07	64.12	62.98	63.26	1144100.0
2018-10-18	ACES	ETF	24.83	24.83	24.36	24.39	6000.0
2018-10-18	ACSI	ETF	33.0883	33.0883	32.79	32.79	1932.0
2018-10-18	ACTX	ETF	143.9613	150.4514	130.3912	139.8313	3485.0
2018-10-18	ACWF	ETF	28.8542	28.9923	28.44	28.59	35126.0
2018-10-18	ACWI	ETF	70.66	70.83	69.61	69.93	3787500.0
2018-10-18	ACWV	ETF	85.18	85.45	84.42	84.72	300300.0
2018-10-18	ACWX	ETF	44.9	44.95	44.2038	44.33	1253459.0
2018-10-18	ADRE	ETF	38.59	38.6275	37.76	37.7932	6563.0
2018-10-18	AFIF	ETF	10.04	10.06	10.0375	10.0469	14614.0
2018-10-18	AFK	ETF	20.8579	20.8579	20.5765	20.5765	5034.0
2018-10-18	AFTY	ETF	13.96	13.99	13.8	13.82	12200.0
2018-10-18	AGG	ETF	104.39	104.62	104.38	104.46	3158200.0
2018-10-18	AGGY	ETF	47.74	47.81	47.705	47.77	32700.0
2018-10-18	AGQ	ETF	23.83	24.08	23.68	23.82	92800.0
2018-10-18	AGZ	ETF	110.19	110.3087	110.115	110.2323	7148.0
2018-10-18	AGZD	ETF	23.9	23.97	23.89	23.945	5000.0
2018-10-18	AIA	ETF	56.69	56.69	55.6301	55.86	84573.0
2018-10-18	AIEQ	ETF	27.98	27.98	27.4	27.54	69600.0
2018-10-18	AIQ	ETF	14.79	14.79	14.4	14.44	665.0
2018-10-18	AIRR	ETF	26.0	26.08	25.546	25.638	11500.0
2018-10-18	AIVI	ETF	40.67	40.81	40.23	40.29	11000.0
2018-10-18	ALTY	ETF	14.68	14.68	14.593	14.593	1200.0
2018-10-18	AMJ	ETF	27.02	27.54	27.01	27.03	1615443.0
2018-10-18	AMLP	ETF	52.6	53.6	52.55	52.6	3120440.0
2018-10-18	AMZA	ETF	73.1	74.4	72.3	73.0	74000.0
2018-10-18	ANGL	ETF	28.64	28.66	28.57	28.58	84900.0
2018-10-18	AOA	ETF	52.27	52.34	51.62	51.73	41300.0
2018-10-18	AOK	ETF	33.35	33.4082	33.2301	33.28	42928.0
2018-10-18	AOM	ETF	36.75	36.7934	36.531	36.59	80336.0
2018-10-18	AOR	ETF	43.56	43.56	43.05	43.17	116895.0
2018-10-18	ARGT	ETF	25.02	25.09	24.56	24.56	13800.0
2018-10-18	ARKG	ETF	30.14	30.18	29.15	29.37	95400.0
2018-10-18	ARKK	ETF	43.13	43.14	41.8	42.1	254600.0
2018-10-18	ARKQ	ETF	32.93	32.93	32.2	32.32	14800.0
2018-10-18	ARKW	ETF	53.15	53.175	51.71	51.94	81100.0
2018-10-18	ARVR	ETF	19.37	19.37	19.37	19.37	1049.0
2018-10-18	ASEA	ETF	15.31	15.31	15.25	15.25	500.0
2018-10-18	ASET	ETF	26.82	26.82	26.809	26.809	300.0
2018-10-18	ASHR	ETF	22.41	22.44	22.0	22.02	4106800.0
2018-10-18	ASHS	ETF	21.42	21.48	21.2	21.21	28700.0
2018-10-18	ASHX	ETF	15.77	15.77	15.77	15.77	320.0

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

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