PREVIEW / etf_daily / 2018-11-01

all etf daily files

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

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-01	SPY	ETF	271.6	273.73	270.38	273.51	99495000.0
2018-11-01	QQQ	ETF	170.08	172.24	168.78	172.06	52706823.0
2018-11-01	IWM	ETF	150.89	153.77	150.81	153.49	28496400.0
2018-11-01	DIA	ETF	252.15	253.83	250.91	253.73	3267900.0
2018-11-01	GLD	ETF	116.33	117.07	116.18	116.63	13662900.0
2018-11-01	TLT	ETF	112.85	113.56	112.84	113.41	6100200.0
2018-11-01	AAAU	ETF	12.3	12.36	12.3	12.34	5600.0
2018-11-01	AADR	ETF	46.7	47.43	46.25	47.33	19600.0
2018-11-01	AAXJ	ETF	63.94	65.24	63.64	65.24	841300.0
2018-11-01	ACES	ETF	24.38	24.38	24.38	24.38	100.0
2018-11-01	ACSI	ETF	32.4395	32.5452	32.4395	32.5452	905.0
2018-11-01	ACTX	ETF	82.6007	82.6007	73.7507	79.0607	961.0
2018-11-01	ACWF	ETF	28.2974	28.62	28.2974	28.6199	31826.0
2018-11-01	ACWI	ETF	69.15	69.74	68.85	69.7	4500200.0
2018-11-01	ACWV	ETF	83.8	84.32	83.69	84.17	224200.0
2018-11-01	ACWX	ETF	44.32	44.71	44.15	44.69	1909975.0
2018-11-01	ADRE	ETF	38.0	38.7456	37.56	38.6226	5173.0
2018-11-01	AFIF	ETF	10.0401	10.06	10.02	10.0336	12564.0
2018-11-01	AFK	ETF	20.32	20.76	20.32	20.76	8743.0
2018-11-01	AFTY	ETF	14.51	14.9	14.5	14.88	13600.0
2018-11-01	AGG	ETF	104.22	104.41	104.21	104.34	7919000.0
2018-11-01	AGGY	ETF	47.49	47.56	47.47	47.54	63800.0
2018-11-01	AGNG	ETF	19.711	19.711	19.711	19.711	100.0
2018-11-01	AGQ	ETF	23.77	24.53	23.76	24.26	169300.0
2018-11-01	AGZ	ETF	110.28	110.3795	110.2	110.3631	16250.0
2018-11-01	AGZD	ETF	23.83	23.83	23.815	23.815	2400.0
2018-11-01	AIA	ETF	55.96	57.11	55.86	57.01	28230.0
2018-11-01	AIEQ	ETF	26.67	27.06	26.6	27.01	104100.0
2018-11-01	AIQ	ETF	13.99	14.16	13.82	14.16	23021.0
2018-11-01	AIRR	ETF	24.5	25.0	24.5	25.0	4900.0
2018-11-01	AIVI	ETF	40.01	40.18	39.96	40.18	4600.0
2018-11-01	ALTY	ETF	14.488	14.531	14.462	14.51	7100.0
2018-11-01	AMJ	ETF	25.44	25.65	25.28	25.53	1558227.0
2018-11-01	AMLP	ETF	49.2	49.8	48.95	49.5	4202440.0
2018-11-01	AMZA	ETF	64.1	65.3	64.1	65.0	83470.0
2018-11-01	ANGL	ETF	28.09	28.19	28.08	28.14	1540300.0
2018-11-01	AOA	ETF	51.22	51.69	51.2	51.68	96900.0
2018-11-01	AOK	ETF	33.16	33.35	33.1375	33.27	100066.0
2018-11-01	AOM	ETF	36.42	36.64	36.4108	36.57	273953.0
2018-11-01	AOR	ETF	42.66	43.13	42.66	43.13	84205.0
2018-11-01	ARGT	ETF	25.82	26.66	25.65	26.65	233100.0
2018-11-01	ARKG	ETF	27.94	28.735	27.92	28.68	275400.0
2018-11-01	ARKK	ETF	43.18	44.8	43.13	44.72	450700.0
2018-11-01	ARKQ	ETF	32.93	34.34	32.93	34.22	69800.0
2018-11-01	ARKW	ETF	53.61	55.37	53.25	55.26	225800.0
2018-11-01	ARVR	ETF	18.7634	18.7634	18.7634	18.7634	100.0
2018-11-01	ASEA	ETF	15.36	15.76	15.36	15.75	14000.0
2018-11-01	ASET	ETF	26.648	26.67	26.648	26.66	847.0
2018-11-01	ASHR	ETF	23.4	24.18	23.35	24.14	11663300.0
2018-11-01	ASHS	ETF	22.75	23.8	22.7	23.6	29300.0

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

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