PREVIEW / etf_daily / 2019-11-25

all etf daily files

  file:    by_date/etf_daily/2019/2019-11-25.parquet
  size:    72 KB
  rows:    1,892

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-25	SPY	ETF	311.98	313.37	311.98	313.37	48647200.0
2019-11-25	QQQ	ETF	202.67	204.26	202.67	204.22	17794718.0
2019-11-25	IWM	ETF	159.03	161.83	158.89	161.58	24753000.0
2019-11-25	DIA	ETF	279.68	280.81	279.64	280.8	1811100.0
2019-11-25	GLD	ETF	137.32	137.62	136.99	137.08	6415800.0
2019-11-25	TLT	ETF	140.3	140.53	140.18	140.31	4157300.0
2019-11-25	AAAU	ETF	14.55	14.57	14.51	14.52	24600.0
2019-11-25	AADR	ETF	50.19	50.45	50.17	50.42	3500.0
2019-11-25	AAXJ	ETF	70.48	70.83	70.42	70.8	1413100.0
2019-11-25	ACES	ETF	32.29	33.49	31.975	32.127	19800.0
2019-11-25	ACIO	ETF	25.27	25.337	25.27	25.337	13300.0
2019-11-25	ACSI	ETF	34.97	35.1739	34.9473	35.1739	2951.0
2019-11-25	ACTX	ETF	6.4901	7.0801	6.4901	6.4901	123.0
2019-11-25	ACWF	ETF	30.61	30.75	30.61	30.6906	2985.0
2019-11-25	ACWI	ETF	77.39	77.7	77.38	77.67	1427800.0
2019-11-25	ACWV	ETF	95.47	95.59	95.36	95.44	282900.0
2019-11-25	ACWX	ETF	48.11	48.28	48.09	48.24	1094825.0
2019-11-25	ADME	ETF	30.26	30.26	30.246	30.25	121300.0
2019-11-25	ADRE	ETF	41.27	41.62	41.27	41.53	3034.0
2019-11-25	AFIF	ETF	9.7497	9.7497	9.73	9.745	3039.0
2019-11-25	AFK	ETF	20.91	20.91	20.7399	20.7922	2131.0
2019-11-25	AFTY	ETF	17.52	17.52	17.35	17.392	13200.0
2019-11-25	AGG	ETF	112.91	113.01	112.89	112.98	4251200.0
2019-11-25	AGGY	ETF	52.19	52.22	52.15	52.2	137500.0
2019-11-25	AGNG	ETF	23.44	23.676	23.44	23.595	5200.0
2019-11-25	AGQ	ETF	28.68	28.95	28.6	28.62	73700.0
2019-11-25	AGZ	ETF	116.27	116.32	116.235	116.31	18061.0
2019-11-25	AGZD	ETF	23.935	23.985	23.935	23.975	23000.0
2019-11-25	AIA	ETF	62.62	63.01	62.62	63.0	21928.0
2019-11-25	AIEQ	ETF	27.55	27.75	27.55	27.66	24600.0
2019-11-25	AIQ	ETF	17.25	17.3426	17.25	17.32	3858.0
2019-11-25	AIRR	ETF	28.506	28.841	28.506	28.799	4900.0
2019-11-25	AIVI	ETF	42.05	42.08	42.03	42.08	37200.0
2019-11-25	ALTY	ETF	14.68	14.73	14.68	14.7	6300.0
2019-11-25	AMJ	ETF	20.95	21.1	20.86	21.05	2643797.0
2019-11-25	AMLP	ETF	39.8	40.2	39.7	40.2	4272000.0
2019-11-25	AMUB	ETF	13.19	13.2513	13.19	13.2513	401.0
2019-11-25	AMZA	ETF	41.4	42.2	41.3	42.2	80650.0
2019-11-25	ANGL	ETF	29.1	29.21	29.1	29.2	367000.0
2019-11-25	AOA	ETF	56.8	57.0	56.8	57.0	38900.0
2019-11-25	AOK	ETF	35.99	36.1	35.99	36.1	73524.0
2019-11-25	AOM	ETF	39.81	39.89	39.81	39.89	234535.0
2019-11-25	AOR	ETF	47.09	47.25	47.09	47.22	83517.0
2019-11-25	ARGT	ETF	22.99	23.33	22.82	23.33	54000.0
2019-11-25	ARKF	ETF	23.64	23.877	23.64	23.863	56200.0
2019-11-25	ARKG	ETF	33.13	34.04	33.101	34.02	207700.0
2019-11-25	ARKK	ETF	48.89	49.75	48.75	49.67	205000.0
2019-11-25	ARKQ	ETF	34.55	34.97	34.55	34.923	11100.0
2019-11-25	ARKW	ETF	55.19	56.0	55.16	55.94	54000.0
2019-11-25	ASEA	ETF	15.89	16.02	15.89	15.96	6100.0

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

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