PREVIEW / etf_daily / 2019-03-29

all etf daily files

  file:    by_date/etf_daily/2019/2019-03-29.parquet
  size:    68 KB
  rows:    1,767

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-03-29	SPY	ETF	282.39	282.84	281.14	282.48	82186800.0
2019-03-29	QQQ	ETF	179.63	179.83	178.59	179.66	35205511.0
2019-03-29	IWM	ETF	153.68	153.97	152.1	153.09	28298900.0
2019-03-29	DIA	ETF	258.58	259.34	257.57	259.13	4255900.0
2019-03-29	GLD	ETF	122.64	122.75	122.01	122.01	7093900.0
2019-03-29	TLT	ETF	125.68	126.47	125.64	126.44	10841400.0
2019-03-29	AAAU	ETF	12.98	12.98	12.91	12.91	19000.0
2019-03-29	AADR	ETF	45.25	45.6	45.25	45.5	10400.0
2019-03-29	AAXJ	ETF	70.68	70.81	70.33	70.69	2777700.0
2019-03-29	ACES	ETF	26.973	26.973	26.973	26.973	300.0
2019-03-29	ACSI	ETF	32.5713	32.6257	32.54	32.6257	2551.0
2019-03-29	ACTX	ETF	50.7405	53.1005	49.5663	50.7405	1436.0
2019-03-29	ACWF	ETF	29.02	29.09	28.94	29.0608	10973.0
2019-03-29	ACWI	ETF	72.11	72.16	71.77	72.15	3205800.0
2019-03-29	ACWV	ETF	89.36	89.56	89.17	89.48	212000.0
2019-03-29	ACWX	ETF	46.31	46.31	46.07	46.27	1380853.0
2019-03-29	ADRE	ETF	40.99	41.215	40.94	41.21	2553.0
2019-03-29	AFIF	ETF	9.98	10.02	9.975	9.9863	67859.0
2019-03-29	AFK	ETF	21.44	21.52	21.44	21.51	2840.0
2019-03-29	AFTY	ETF	16.891	16.91	16.78	16.787	7300.0
2019-03-29	AGG	ETF	108.85	109.07	108.83	109.07	5988300.0
2019-03-29	AGGY	ETF	49.82	49.87	49.807	49.83	52100.0
2019-03-29	AGNG	ETF	21.383	21.55	21.383	21.468	4300.0
2019-03-29	AGQ	ETF	24.7	24.74	24.45	24.48	146800.0
2019-03-29	AGZ	ETF	113.53	113.61	113.5001	113.5703	74727.0
2019-03-29	AGZD	ETF	23.98	23.98	23.81	23.885	18200.0
2019-03-29	AIA	ETF	61.14	61.3	60.97	61.14	51948.0
2019-03-29	AIEQ	ETF	25.87	25.92	25.8	25.88	22800.0
2019-03-29	AIQ	ETF	15.66	15.76	15.66	15.7397	53690.0
2019-03-29	AIRR	ETF	24.49	24.5	24.28	24.38	7400.0
2019-03-29	AIVI	ETF	41.26	41.26	41.1	41.17	2900.0
2019-03-29	ALTY	ETF	14.93	14.93	14.852	14.86	10800.0
2019-03-29	AMJ	ETF	25.5	25.57	25.39	25.51	901141.0
2019-03-29	AMLP	ETF	50.25	50.35	50.0	50.15	2660940.0
2019-03-29	AMUB	ETF	16.0565	16.0565	16.0565	16.0565	0.0
2019-03-29	AMZA	ETF	59.5	60.0	59.3	59.6	40470.0
2019-03-29	ANGL	ETF	28.72	28.79	28.7	28.75	232800.0
2019-03-29	AOA	ETF	53.47	53.52	53.34	53.52	61300.0
2019-03-29	AOK	ETF	34.5	34.52	34.44	34.52	69917.0
2019-03-29	AOM	ETF	38.0	38.06	37.9601	38.06	63333.0
2019-03-29	AOR	ETF	44.67	44.76	44.59	44.7	102343.0
2019-03-29	ARCM	ETF	100.245	100.245	100.245	100.245	100.0
2019-03-29	ARGT	ETF	27.49	27.81	27.42	27.61	81100.0
2019-03-29	ARKF	ETF	21.46	21.577	21.45	21.56	24700.0
2019-03-29	ARKG	ETF	32.67	32.88	32.428	32.88	137100.0
2019-03-29	ARKK	ETF	46.58	46.83	46.21	46.73	242400.0
2019-03-29	ARKQ	ETF	34.07	34.11	33.94	34.04	7100.0
2019-03-29	ARKW	ETF	51.62	51.873	51.427	51.81	124100.0
2019-03-29	ASEA	ETF	15.89	15.89	15.8	15.82	500.0
2019-03-29	ASET	ETF	28.9962	28.9962	28.9701	28.9701	783.0

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

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