PREVIEW / etf_daily / 2019-06-28

all etf daily files

  file:    by_date/etf_daily/2019/2019-06-28.parquet
  size:    70 KB
  rows:    1,811

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-06-28	SPY	ETF	292.58	293.55	292.01	293.0	59350900.0
2019-06-28	QQQ	ETF	186.95	187.15	186.07	186.74	21179248.0
2019-06-28	IWM	ETF	153.95	156.02	153.94	155.5	35089900.0
2019-06-28	DIA	ETF	265.94	266.26	265.07	265.85	2176200.0
2019-06-28	GLD	ETF	133.05	133.34	132.61	133.2	8077000.0
2019-06-28	TLT	ETF	132.58	133.08	132.45	132.81	8149200.0
2019-06-28	AAAU	ETF	14.08	14.1	14.07	14.1	9600.0
2019-06-28	AADR	ETF	49.39	49.75	49.38	49.75	8200.0
2019-06-28	AAXJ	ETF	69.89	69.93	69.64	69.79	2508900.0
2019-06-28	ACES	ETF	29.595	29.65	29.5	29.632	1500.0
2019-06-28	ACSI	ETF	33.59	33.64	33.5801	33.6151	2058.0
2019-06-28	ACTX	ETF	28.9103	31.8603	28.3203	28.9103	746.0
2019-06-28	ACWF	ETF	29.165	29.3	29.15	29.28	5041.0
2019-06-28	ACWI	ETF	73.61	73.78	73.5	73.71	2653100.0
2019-06-28	ACWV	ETF	92.07	92.16	91.91	92.12	229100.0
2019-06-28	ACWX	ETF	46.85	46.86	46.66	46.76	11382304.0
2019-06-28	ADRE	ETF	40.15	40.15	39.845	39.9	10972.0
2019-06-28	AFIF	ETF	9.86	9.88	9.84	9.86	11780.0
2019-06-28	AFK	ETF	22.26	22.26	22.02	22.1	8987.0
2019-06-28	AFTY	ETF	17.43	17.44	17.4	17.428	7900.0
2019-06-28	AGG	ETF	111.36	111.47	111.32	111.35	9887800.0
2019-06-28	AGGY	ETF	51.26	51.32	51.234	51.24	121700.0
2019-06-28	AGNG	ETF	21.14	21.272	21.14	21.272	700.0
2019-06-28	AGQ	ETF	24.45	24.72	24.35	24.65	186200.0
2019-06-28	AGZ	ETF	115.23	115.29	115.19	115.23	34327.0
2019-06-28	AGZD	ETF	23.78	23.87	23.78	23.825	5200.0
2019-06-28	AIA	ETF	61.38	61.38	61.15	61.26	16602.0
2019-06-28	AIEQ	ETF	26.14	26.35	26.14	26.338	47500.0
2019-06-28	AIQ	ETF	16.151	16.262	16.151	16.2555	2530.0
2019-06-28	AIRR	ETF	26.198	26.461	26.12	26.4	4700.0
2019-06-28	AIVI	ETF	41.11	41.13	41.06	41.09	5000.0
2019-06-28	ALTY	ETF	14.95	14.972	14.925	14.972	1500.0
2019-06-28	AMJ	ETF	24.85	25.11	24.71	25.11	1156189.0
2019-06-28	AMLP	ETF	48.75	49.25	48.65	49.25	1953460.0
2019-06-28	AMOM	ETF	25.719	25.719	25.719	25.719	100.0
2019-06-28	AMUB	ETF	15.7369	15.7369	15.7369	15.7369	0.0
2019-06-28	AMZA	ETF	54.9	55.7	54.7	55.7	71090.0
2019-06-28	ANGL	ETF	29.3	29.32	29.26	29.3	309200.0
2019-06-28	AOA	ETF	54.98	55.15	54.98	55.15	36800.0
2019-06-28	AOK	ETF	35.28	35.39	35.28	35.39	33316.0
2019-06-28	AOM	ETF	39.06	39.095	39.0	39.02	88390.0
2019-06-28	AOR	ETF	45.96	46.02	45.86	46.02	87260.0
2019-06-28	ARGT	ETF	31.89	32.25	31.84	32.19	90200.0
2019-06-28	ARKF	ETF	22.54	22.65	22.47	22.65	8800.0
2019-06-28	ARKG	ETF	33.13	34.619	33.12	34.47	146900.0
2019-06-28	ARKK	ETF	45.94	48.05	45.82	47.98	480600.0
2019-06-28	ARKQ	ETF	32.8	33.81	32.8	33.76	19900.0
2019-06-28	ARKW	ETF	51.46	52.03	51.395	52.01	49600.0
2019-06-28	ASEA	ETF	16.8	16.84	16.75	16.75	5200.0
2019-06-28	ASET	ETF	29.31	29.32	29.31	29.32	400.0

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

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