PREVIEW / etf_daily / 2019-05-07

all etf daily files

  file:    by_date/etf_daily/2019/2019-05-07.parquet
  size:    69 KB
  rows:    1,794

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-05-07	SPY	ETF	290.15	290.81	285.81	287.93	144729900.0
2019-05-07	QQQ	ETF	187.86	188.67	184.51	186.24	58818134.0
2019-05-07	IWM	ETF	159.31	159.87	156.25	157.53	25434500.0
2019-05-07	DIA	ETF	261.98	262.49	257.81	259.52	6758100.0
2019-05-07	GLD	ETF	121.02	121.42	120.91	121.21	4010700.0
2019-05-07	TLT	ETF	124.53	125.14	124.39	124.95	8984900.0
2019-05-07	AAAU	ETF	12.81	12.84	12.81	12.83	42200.0
2019-05-07	AADR	ETF	45.47	45.47	45.11	45.34	9300.0
2019-05-07	AAXJ	ETF	70.66	70.71	69.5	69.89	3086800.0
2019-05-07	ACES	ETF	28.5	33.515	28.5	28.778	5900.0
2019-05-07	ACSI	ETF	33.67	33.67	33.34	33.38	5052.0
2019-05-07	ACTX	ETF	40.1204	40.1204	37.1703	37.7603	372.0
2019-05-07	ACWF	ETF	29.13	29.13	28.745	28.9	13356.0
2019-05-07	ACWI	ETF	73.47	73.53	72.45	72.84	2985700.0
2019-05-07	ACWV	ETF	89.53	89.67	88.75	89.11	1258600.0
2019-05-07	ACWX	ETF	46.68	46.68	46.12	46.29	860338.0
2019-05-07	ADRE	ETF	40.95	40.95	40.36	40.365	2913.0
2019-05-07	AFIF	ETF	10.3	10.3	10.0	10.0048	19809.0
2019-05-07	AFK	ETF	21.98	21.98	21.3303	21.43	5082.0
2019-05-07	AFTY	ETF	16.71	16.71	16.28	16.388	15200.0
2019-05-07	AGG	ETF	108.63	108.7	108.59	108.61	3051400.0
2019-05-07	AGGY	ETF	49.87	49.948	49.87	49.94	273500.0
2019-05-07	AGNG	ETF	20.74	20.934	20.73	20.83	8600.0
2019-05-07	AGQ	ETF	23.52	23.62	23.42	23.61	184000.0
2019-05-07	AGZ	ETF	113.22	113.36	113.22	113.35	8885.0
2019-05-07	AGZD	ETF	23.97	23.97	23.9	23.945	7000.0
2019-05-07	AIA	ETF	61.79	61.93	61.057	61.41	35142.0
2019-05-07	AIEQ	ETF	26.57	26.74	26.28	26.45	220500.0
2019-05-07	AIQ	ETF	16.59	16.6	16.26	16.32	27164.0
2019-05-07	AIRR	ETF	25.822	25.822	25.32	25.37	6700.0
2019-05-07	AIVI	ETF	40.88	40.88	40.44	40.56	8200.0
2019-05-07	ALTY	ETF	14.98	14.98	14.88	14.94	8300.0
2019-05-07	AMJ	ETF	24.75	25.01	24.7	24.9	2336631.0
2019-05-07	AMLP	ETF	49.0	49.45	48.75	49.45	2003580.0
2019-05-07	AMUB	ETF	15.7175	15.7175	15.7175	15.7175	0.0
2019-05-07	AMZA	ETF	56.5	56.8	55.8	56.8	168820.0
2019-05-07	ANGL	ETF	29.04	29.04	28.86	28.87	351000.0
2019-05-07	AOA	ETF	54.21	54.23	53.6	53.88	64700.0
2019-05-07	AOK	ETF	34.61	34.65	34.5301	34.59	132369.0
2019-05-07	AOM	ETF	38.25	38.278	38.01	38.08	150635.0
2019-05-07	AOR	ETF	45.11	45.13	44.705	44.88	85073.0
2019-05-07	ARGT	ETF	27.81	27.81	27.12	27.21	16700.0
2019-05-07	ARKF	ETF	22.58	22.59	22.063	22.228	48300.0
2019-05-07	ARKG	ETF	33.68	33.717	32.357	32.61	180200.0
2019-05-07	ARKK	ETF	48.28	48.49	46.9	47.3	457700.0
2019-05-07	ARKQ	ETF	34.81	34.81	34.081	34.39	28400.0
2019-05-07	ARKW	ETF	53.7	53.96	52.24	52.74	109300.0
2019-05-07	ASEA	ETF	16.18	16.42	16.14	16.14	1600.0
2019-05-07	ASET	ETF	28.78	28.78	28.73	28.73	599.0
2019-05-07	ASHR	ETF	27.27	27.27	26.52	26.74	18787200.0

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

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