PREVIEW / etf_daily / 2019-10-09

all etf daily files

  file:    by_date/etf_daily/2019/2019-10-09.parquet
  size:    71 KB
  rows:    1,840

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
2019-10-09	SPY	ETF	290.75	292.3	290.06	291.27	62359400.0
2019-10-09	QQQ	ETF	186.96	188.08	186.43	187.23	20829012.0
2019-10-09	IWM	ETF	147.54	147.69	146.64	147.13	10929500.0
2019-10-09	DIA	ETF	263.44	264.24	262.48	263.43	2020800.0
2019-10-09	GLD	ETF	142.16	142.58	141.62	142.05	6927700.0
2019-10-09	TLT	ETF	144.6	144.61	143.8	144.35	8608800.0
2019-10-09	AAAU	ETF	15.06	15.08	15.02	15.05	60300.0
2019-10-09	AADR	ETF	47.61	47.74	47.37	47.61	9500.0
2019-10-09	AAXJ	ETF	66.1	66.35	66.0	66.08	1818000.0
2019-10-09	ACES	ETF	30.74	30.74	30.635	30.689	25100.0
2019-10-09	ACIO	ETF	24.22	24.29	24.21	24.29	10600.0
2019-10-09	ACSI	ETF	33.1622	33.2377	33.141	33.2377	644.0
2019-10-09	ACTX	ETF	12.101	14.7501	11.8001	14.1601	1564.0
2019-10-09	ACWF	ETF	28.2826	28.4139	28.2762	28.3354	3376.0
2019-10-09	ACWI	ETF	72.38	72.65	72.2	72.41	1536500.0
2019-10-09	ACWV	ETF	94.31	94.44	94.01	94.22	179300.0
2019-10-09	ACWX	ETF	45.29	45.39	45.185	45.28	681917.0
2019-10-09	ADRE	ETF	38.42	38.5977	38.291	38.5977	2340.0
2019-10-09	AFIF	ETF	9.79	9.8	9.78	9.79	12426.0
2019-10-09	AFK	ETF	19.8376	19.8617	19.6845	19.6845	4307.0
2019-10-09	AFTY	ETF	16.99	17.03	16.97	16.97	1400.0
2019-10-09	AGG	ETF	113.55	113.56	113.36	113.49	3332800.0
2019-10-09	AGGY	ETF	52.59	52.59	52.475	52.53	234300.0
2019-10-09	AGNG	ETF	21.273	21.273	21.273	21.273	3600.0
2019-10-09	AGQ	ETF	32.3	32.3	31.76	32.03	164800.0
2019-10-09	AGZ	ETF	116.92	116.92	116.68	116.8	29915.0
2019-10-09	AGZD	ETF	23.885	23.885	23.805	23.87	2800.0
2019-10-09	AIA	ETF	58.64	58.87	58.61	58.63	25202.0
2019-10-09	AIEQ	ETF	25.79	25.921	25.71	25.85	8800.0
2019-10-09	AIQ	ETF	15.7645	15.8591	15.76	15.8591	4501.0
2019-10-09	AIRR	ETF	25.88	25.88	25.79	25.83	2500.0
2019-10-09	AIVI	ETF	39.78	39.78	39.68	39.75	6300.0
2019-10-09	ALTY	ETF	14.62	14.629	14.58	14.59	5900.0
2019-10-09	AMJ	ETF	22.65	22.65	22.22	22.22	1671510.0
2019-10-09	AMLP	ETF	44.5	44.65	43.75	43.9	3503100.0
2019-10-09	AMUB	ETF	14.0178	14.0178	14.0178	14.0178	0.0
2019-10-09	AMZA	ETF	47.3	47.5	46.25	46.3	102630.0
2019-10-09	ANGL	ETF	29.03	29.1	28.99	28.99	576400.0
2019-10-09	AOA	ETF	53.98	54.12	53.89	54.02	31100.0
2019-10-09	AOK	ETF	35.52	35.52	35.4207	35.49	40751.0
2019-10-09	AOM	ETF	38.9	38.92	38.83	38.91	107622.0
2019-10-09	AOR	ETF	45.36	45.48	45.33	45.43	104525.0
2019-10-09	ARCM	ETF	100.154	100.238	100.14	100.14	3400.0
2019-10-09	ARGT	ETF	22.5	22.6	22.31	22.44	18300.0
2019-10-09	ARKF	ETF	21.256	21.329	21.256	21.302	5600.0
2019-10-09	ARKG	ETF	28.28	28.31	27.97	28.02	74700.0
2019-10-09	ARKK	ETF	41.06	41.38	40.831	41.19	133100.0
2019-10-09	ARKQ	ETF	30.95	31.274	30.95	31.167	6300.0
2019-10-09	ARKW	ETF	47.81	48.471	47.81	48.29	43400.0
2019-10-09	ASEA	ETF	15.53	15.71	15.35	15.52	2200.0

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

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