PREVIEW / etf_daily / 2019-11-29

all etf daily files

  file:    by_date/etf_daily/2019/2019-11-29.parquet
  size:    71 KB
  rows:    1,872

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-11-29	SPY	ETF	314.86	315.13	314.06	314.31	36592700.0
2019-11-29	QQQ	ETF	205.59	205.83	205.0	205.1	9854553.0
2019-11-29	IWM	ETF	162.41	162.79	161.67	161.77	9988200.0
2019-11-29	DIA	ETF	281.3	281.57	280.84	280.95	811900.0
2019-11-29	GLD	ETF	137.1	138.13	137.08	137.86	4516400.0
2019-11-29	TLT	ETF	140.62	140.68	139.78	140.42	6251100.0
2019-11-29	AAAU	ETF	14.53	14.61	14.52	14.61	8100.0
2019-11-29	AADR	ETF	50.33	50.92	50.33	50.69	3500.0
2019-11-29	AAXJ	ETF	69.69	69.79	69.57	69.65	372400.0
2019-11-29	ACES	ETF	32.54	32.54	32.26	32.37	15400.0
2019-11-29	ACIO	ETF	25.4	25.4	25.338	25.338	2300.0
2019-11-29	ACSI	ETF	35.4	35.4001	35.3315	35.3315	1322.0
2019-11-29	ACTX	ETF	6.4901	7.0801	6.4901	7.0801	355.0
2019-11-29	ACWF	ETF	30.67	30.68	30.6138	30.6138	2158.0
2019-11-29	ACWI	ETF	77.71	77.78	77.54	77.54	4851300.0
2019-11-29	ACWV	ETF	95.62	95.8	95.45	95.45	196400.0
2019-11-29	ACWX	ETF	47.97	48.035	47.91	47.94	778373.0
2019-11-29	ADME	ETF	30.36	30.36	30.281	30.281	3400.0
2019-11-29	AFIF	ETF	9.7352	9.7352	9.7352	9.7352	100.0
2019-11-29	AFK	ETF	20.6	20.6	20.5	20.52	2641.0
2019-11-29	AFTY	ETF	17.15	17.15	17.03	17.14	6700.0
2019-11-29	AGG	ETF	113.01	113.02	112.85	112.86	4059000.0
2019-11-29	AGGY	ETF	52.27	52.3	52.215	52.27	88400.0
2019-11-29	AGNG	ETF	23.875	23.875	23.57	23.73	3500.0
2019-11-29	AGQ	ETF	28.58	29.03	28.44	28.94	99600.0
2019-11-29	AGZ	ETF	116.32	116.32	116.22	116.26	10832.0
2019-11-29	AGZD	ETF	23.98	24.02	23.925	23.975	25400.0
2019-11-29	AIA	ETF	61.63	61.6575	61.51	61.5483	11705.0
2019-11-29	AIEQ	ETF	27.91	27.917	27.8	27.858	11400.0
2019-11-29	AIQ	ETF	17.28	17.355	17.28	17.3119	18557.0
2019-11-29	AIRR	ETF	28.71	28.772	28.71	28.739	800.0
2019-11-29	AIVI	ETF	41.83	41.87	41.83	41.83	800.0
2019-11-29	ALTY	ETF	14.765	14.77	14.7	14.725	12500.0
2019-11-29	AMJ	ETF	20.25	20.28	20.06	20.14	1173546.0
2019-11-29	AMLP	ETF	39.35	39.45	39.0	39.15	2169440.0
2019-11-29	AMOM	ETF	26.748	26.748	26.748	26.748	100.0
2019-11-29	AMUB	ETF	12.6886	12.6886	12.6886	12.6886	2.0
2019-11-29	AMZA	ETF	41.0	41.1	40.6	40.7	49020.0
2019-11-29	ANGL	ETF	29.42	29.5	29.36	29.43	1296300.0
2019-11-29	AOA	ETF	57.05	57.09	56.94	56.94	19400.0
2019-11-29	AOK	ETF	36.14	36.14	36.06	36.0618	273705.0
2019-11-29	AOM	ETF	39.89	39.936	39.85	39.85	86058.0
2019-11-29	AOR	ETF	47.35	47.35	47.14	47.23	59765.0
2019-11-29	ARGT	ETF	23.88	23.9	23.53	23.66	25800.0
2019-11-29	ARKF	ETF	23.92	23.94	23.879	23.901	4500.0
2019-11-29	ARKG	ETF	34.65	35.0	34.5	34.92	85300.0
2019-11-29	ARKK	ETF	50.01	50.45	50.01	50.43	75400.0
2019-11-29	ARKQ	ETF	34.97	34.97	34.742	34.8	4500.0
2019-11-29	ARKW	ETF	56.35	56.35	56.11	56.196	18700.0
2019-11-29	ASEA	ETF	15.8	15.8	15.79	15.79	2800.0

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

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