PREVIEW / etf_daily / 2018-11-13

all etf daily files

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

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-13	SPY	ETF	273.09	275.33	271.25	272.06	98176600.0
2018-11-13	QQQ	ETF	167.15	169.48	166.0	166.47	64128079.0
2018-11-13	IWM	ETF	151.6	153.09	150.29	150.55	18468500.0
2018-11-13	DIA	ETF	253.83	255.37	252.23	253.06	3937900.0
2018-11-13	GLD	ETF	113.72	113.93	113.42	113.7	9309000.0
2018-11-13	TLT	ETF	113.71	114.02	113.48	114.02	6525800.0
2018-11-13	AAAU	ETF	11.99	12.04	11.99	12.0	4200.0
2018-11-13	AADR	ETF	45.4	46.02	45.26	45.44	16800.0
2018-11-13	AAXJ	ETF	64.11	65.01	64.0	64.42	509900.0
2018-11-13	ACES	ETF	24.49	24.6	24.33	24.34	6600.0
2018-11-13	ACSI	ETF	33.0999	33.11	33.0999	33.11	1802.0
2018-11-13	ACTX	ETF	85.5508	85.5508	73.7507	75.5207	829.0
2018-11-13	ACWF	ETF	28.5732	28.7186	28.3827	28.4399	10658.0
2018-11-13	ACWI	ETF	69.02	69.67	68.8	68.99	3785800.0
2018-11-13	ACWV	ETF	85.26	85.52	84.87	85.1	210600.0
2018-11-13	ACWX	ETF	44.04	44.43	43.9	44.07	2733421.0
2018-11-13	ADRE	ETF	36.95	37.21	36.88	37.1625	44940.0
2018-11-13	AFIF	ETF	10.05	10.08	10.05	10.0565	1299914.0
2018-11-13	AFK	ETF	20.13	20.2399	20.13	20.2399	1525.0
2018-11-13	AFTY	ETF	14.4	14.495	14.36	14.42	5800.0
2018-11-13	AGG	ETF	104.3	104.37	104.21	104.35	2977100.0
2018-11-13	AGGY	ETF	47.49	47.53	47.47	47.5	22100.0
2018-11-13	AGNG	ETF	20.0	20.001	19.73	19.73	1100.0
2018-11-13	AGQ	ETF	21.88	22.14	21.74	21.84	75500.0
2018-11-13	AGZ	ETF	110.18	110.3121	110.1609	110.3121	7006.0
2018-11-13	AGZD	ETF	23.84	23.92	23.835	23.855	175000.0
2018-11-13	AIA	ETF	56.05	56.8699	55.9	56.2	135607.0
2018-11-13	AIEQ	ETF	26.32	26.7	26.24	26.32	49800.0
2018-11-13	AIQ	ETF	13.7	13.826	13.7	13.826	1073.0
2018-11-13	AIRR	ETF	25.09	25.2	24.93	24.93	4300.0
2018-11-13	AIVI	ETF	39.76	39.9	39.66	39.68	3100.0
2018-11-13	ALTY	ETF	14.55	14.62	14.535	14.537	7900.0
2018-11-13	AMJ	ETF	25.64	25.86	25.14	25.16	1563252.0
2018-11-13	AMLP	ETF	48.95	49.4	47.95	47.95	4860200.0
2018-11-13	AMZA	ETF	63.7	64.5	62.2	62.4	93680.0
2018-11-13	ANGL	ETF	27.84	27.9	27.73	27.74	525000.0
2018-11-13	AOA	ETF	51.37	51.67	51.15	51.25	80600.0
2018-11-13	AOK	ETF	33.15	33.2493	33.08	33.15	46740.0
2018-11-13	AOM	ETF	36.49	36.62	36.4	36.46	257189.0
2018-11-13	AOR	ETF	42.85	43.08	42.76	42.81	119152.0
2018-11-13	ARGT	ETF	25.28	25.37	24.77	24.83	49300.0
2018-11-13	ARKG	ETF	28.66	29.25	28.66	28.85	54300.0
2018-11-13	ARKK	ETF	43.02	43.87	42.67	43.11	181400.0
2018-11-13	ARKQ	ETF	33.36	33.522	32.915	33.0	18100.0
2018-11-13	ARKW	ETF	51.62	53.15	51.47	52.13	212300.0
2018-11-13	ARVR	ETF	17.87	17.87	17.87	17.87	359.0
2018-11-13	ASEA	ETF	15.44	15.44	15.4	15.43	800.0
2018-11-13	ASET	ETF	26.82	26.8656	26.8	26.8147	1173.0
2018-11-13	ASHR	ETF	23.61	23.89	23.53	23.72	3048500.0
2018-11-13	ASHS	ETF	24.01	24.31	24.01	24.23	19300.0

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

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