PREVIEW / etf_daily / 2018-10-24

all etf daily files

  file:    by_date/etf_daily/2018/2018-10-24.parquet
  size:    64 KB
  rows:    1,658

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-24	SPY	ETF	273.33	273.76	264.7	265.32	177806700.0
2018-10-24	QQQ	ETF	173.12	173.36	165.04	165.34	102997449.0
2018-10-24	IWM	ETF	151.43	151.98	145.82	145.95	40412400.0
2018-10-24	DIA	ETF	252.4	252.89	245.18	245.64	7624300.0
2018-10-24	GLD	ETF	116.38	116.72	116.11	116.66	8563300.0
2018-10-24	TLT	ETF	114.36	114.82	114.24	114.78	16008000.0
2018-10-24	AAAU	ETF	12.3	12.32	12.28	12.3	17600.0
2018-10-24	AADR	ETF	47.56	47.72	45.84	45.84	28000.0
2018-10-24	AAXJ	ETF	63.5	63.53	61.77	61.77	583400.0
2018-10-24	ACES	ETF	23.863	23.863	23.863	23.863	500.0
2018-10-24	ACSI	ETF	32.584	32.59	31.8099	31.8099	1700.0
2018-10-24	ACTX	ETF	98.5309	104.4309	94.4008	94.9909	1474.0
2018-10-24	ACWF	ETF	28.24	28.24	27.6	27.6	14104.0
2018-10-24	ACWI	ETF	69.19	69.24	67.21	67.43	4995800.0
2018-10-24	ACWV	ETF	84.41	84.53	83.13	83.2	101300.0
2018-10-24	ACWX	ETF	43.96	43.97	42.93	42.96	2286253.0
2018-10-24	ADRE	ETF	37.82	37.82	36.46	36.46	4736.0
2018-10-24	AFIF	ETF	9.35	10.06	9.35	10.02	12507.0
2018-10-24	AFK	ETF	20.68	20.68	20.11	20.11	2167.0
2018-10-24	AFTY	ETF	14.53	14.53	14.375	14.375	3400.0
2018-10-24	AGG	ETF	104.69	104.81	104.67	104.75	4465100.0
2018-10-24	AGGY	ETF	47.69	47.71	47.63	47.7	30300.0
2018-10-24	AGNG	ETF	20.372	20.372	19.64	19.64	1300.0
2018-10-24	AGQ	ETF	24.31	24.45	24.01	24.13	65500.0
2018-10-24	AGZ	ETF	110.56	110.63	110.48	110.55	38730.0
2018-10-24	AGZD	ETF	23.85	23.85	23.795	23.83	8400.0
2018-10-24	AIA	ETF	56.01	56.01	54.51	54.53	74626.0
2018-10-24	AIEQ	ETF	26.99	27.06	26.0	26.01	106100.0
2018-10-24	AIQ	ETF	14.2	14.2515	13.53	13.53	10713.0
2018-10-24	AIRR	ETF	24.85	24.86	23.84	23.84	79600.0
2018-10-24	AIVI	ETF	39.74	39.74	39.13	39.18	10100.0
2018-10-24	ALTY	ETF	14.514	14.58	14.46	14.474	10700.0
2018-10-24	AMJ	ETF	26.5	26.54	25.68	25.7	2209436.0
2018-10-24	AMLP	ETF	51.65	51.7	49.75	49.8	4214180.0
2018-10-24	AMZA	ETF	69.0	69.1	65.2	65.2	179500.0
2018-10-24	ANGL	ETF	28.55	28.6	28.38	28.38	372500.0
2018-10-24	AOA	ETF	51.34	51.38	50.2	50.2	274100.0
2018-10-24	AOK	ETF	33.19	33.25	32.9	32.91	29678.0
2018-10-24	AOM	ETF	36.46	36.53	36.04	36.04	124505.0
2018-10-24	AOR	ETF	42.84	42.9099	42.15	42.16	91104.0
2018-10-24	ARGT	ETF	24.35	24.4	23.64	23.68	25500.0
2018-10-24	ARKG	ETF	28.25	28.435	26.21	26.25	217800.0
2018-10-24	ARKK	ETF	41.89	42.0	39.39	39.39	304400.0
2018-10-24	ARKQ	ETF	32.33	32.33	30.945	30.96	77000.0
2018-10-24	ARKW	ETF	52.01	52.15	49.15	49.17	135900.0
2018-10-24	ARVR	ETF	18.79	18.79	18.73	18.73	1069.0
2018-10-24	ASEA	ETF	15.2	15.2	14.74	14.82	2700.0
2018-10-24	ASET	ETF	26.58	26.61	26.345	26.345	604.0
2018-10-24	ASHR	ETF	23.43	23.45	22.98	22.98	1968700.0
2018-10-24	ASHS	ETF	22.4	22.4	22.13	22.13	8300.0

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

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