PREVIEW / etf_daily / 2019-08-30

all etf daily files

  file:    by_date/etf_daily/2019/2019-08-30.parquet
  size:    70 KB
  rows:    1,823

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-08-30	SPY	ETF	294.22	294.24	291.42	292.45	62901200.0
2019-08-30	QQQ	ETF	188.94	188.97	186.41	187.47	26332749.0
2019-08-30	IWM	ETF	149.89	149.97	148.04	148.84	18727100.0
2019-08-30	DIA	ETF	265.27	265.4	263.17	264.13	2442400.0
2019-08-30	GLD	ETF	143.84	144.88	143.02	143.75	9642200.0
2019-08-30	TLT	ETF	146.61	147.48	146.36	147.28	13550800.0
2019-08-30	AAAU	ETF	15.23	15.27	15.17	15.21	53900.0
2019-08-30	AADR	ETF	49.57	49.57	49.29	49.5	5800.0
2019-08-30	AAXJ	ETF	65.42	65.5	65.02	65.28	1954700.0
2019-08-30	ACES	ETF	30.96	30.99	30.495	30.61	12900.0
2019-08-30	ACIO	ETF	24.52	24.52	24.39	24.472	43200.0
2019-08-30	ACSI	ETF	33.5125	33.5125	33.2609	33.3393	798.0
2019-08-30	ACTX	ETF	23.0102	24.1902	23.0102	23.0102	598.0
2019-08-30	ACWF	ETF	28.43	28.43	28.2757	28.3712	7926.0
2019-08-30	ACWI	ETF	72.47	72.47	71.87	72.13	3108500.0
2019-08-30	ACWV	ETF	93.9	93.99	93.24	93.61	163600.0
2019-08-30	ACWX	ETF	44.94	44.97	44.655	44.85	1342558.0
2019-08-30	ADRE	ETF	38.24	38.24	38.108	38.16	882.0
2019-08-30	AFIF	ETF	9.67	9.675	9.65	9.675	42516.0
2019-08-30	AFK	ETF	20.11	20.12	20.07	20.105	8755.0
2019-08-30	AFTY	ETF	16.84	16.84	16.61	16.67	96000.0
2019-08-30	AGG	ETF	113.9	114.15	113.89	114.13	4661600.0
2019-08-30	AGGY	ETF	52.67	52.75	52.63	52.71	146600.0
2019-08-30	AGQ	ETF	34.59	35.21	34.16	34.82	406600.0
2019-08-30	AGZ	ETF	117.19	117.2995	117.111	117.24	18185.0
2019-08-30	AGZD	ETF	23.985	23.985	23.82	23.845	10000.0
2019-08-30	AIA	ETF	56.8	56.86	56.43	56.59	20182.0
2019-08-30	AIEQ	ETF	26.23	26.28	26.03	26.18	27900.0
2019-08-30	AIQ	ETF	16.1	16.1355	16.001	16.1	10774.0
2019-08-30	AIRR	ETF	25.19	25.219	25.05	25.14	4500.0
2019-08-30	AIVI	ETF	39.78	39.79	39.53	39.67	5400.0
2019-08-30	ALTY	ETF	14.67	14.682	14.64	14.664	3500.0
2019-08-30	AMJ	ETF	23.19	23.28	23.03	23.17	924475.0
2019-08-30	AMLP	ETF	45.5	45.75	45.3	45.45	1820340.0
2019-08-30	AMOM	ETF	26.635	26.635	26.635	26.635	300.0
2019-08-30	AMUB	ETF	14.5806	14.5806	14.5806	14.5806	0.0
2019-08-30	AMZA	ETF	48.8	49.48	48.05	48.5	61640.0
2019-08-30	ANGL	ETF	29.45	29.49	29.27	29.33	291900.0
2019-08-30	AOA	ETF	54.08	54.1	53.81	53.98	47900.0
2019-08-30	AOK	ETF	35.57	35.67	35.5101	35.61	73740.0
2019-08-30	AOM	ETF	39.02	39.0975	38.93	39.05	76550.0
2019-08-30	AOR	ETF	45.53	45.6924	45.4201	45.52	77048.0
2019-08-30	ARCM	ETF	100.25	100.25	99.92	100.205	3900.0
2019-08-30	ARGT	ETF	23.02	23.02	22.39	22.42	147900.0
2019-08-30	ARKF	ETF	21.78	21.78	21.511	21.63	6800.0
2019-08-30	ARKG	ETF	31.78	31.78	31.16	31.43	47200.0
2019-08-30	ARKK	ETF	44.65	44.84	43.928	44.32	202000.0
2019-08-30	ARKQ	ETF	31.23	31.52	31.16	31.28	9800.0
2019-08-30	ARKW	ETF	50.3	50.52	49.49	49.86	64900.0
2019-08-30	ASEA	ETF	15.6	15.72	15.54	15.65	4800.0

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

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