PREVIEW / etf_daily / 2019-03-05

all etf daily files

  file:    by_date/etf_daily/2019/2019-03-05.parquet
  size:    67 KB
  rows:    1,753

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-05	SPY	ETF	279.54	279.76	278.41	279.02	59114600.0
2019-03-05	QQQ	ETF	174.52	175.085	173.685	174.55	22319863.0
2019-03-05	IWM	ETF	156.94	156.95	155.96	156.08	16798200.0
2019-03-05	DIA	ETF	258.22	258.86	257.39	258.19	2107200.0
2019-03-05	GLD	ETF	121.38	121.73	121.03	121.72	7120100.0
2019-03-05	TLT	ETF	119.28	119.87	119.27	119.84	5595200.0
2019-03-05	AAAU	ETF	12.84	12.87	12.81	12.87	7600.0
2019-03-05	AADR	ETF	45.56	45.65	45.35	45.53	19500.0
2019-03-05	AAXJ	ETF	69.98	70.39	69.81	70.28	966900.0
2019-03-05	ACES	ETF	27.04	27.04	26.874	26.874	300.0
2019-03-05	ACSI	ETF	32.457	32.457	32.4277	32.4277	746.0
2019-03-05	ACTX	ETF	76.7007	76.7007	54.2805	55.4605	3366.0
2019-03-05	ACWF	ETF	29.025	29.1699	29.01	29.1	13222.0
2019-03-05	ACWI	ETF	71.26	71.39	71.05	71.21	2561500.0
2019-03-05	ACWV	ETF	87.5	87.65	87.4	87.52	198100.0
2019-03-05	ACWX	ETF	46.0	46.2	45.94	46.13	1041904.0
2019-03-05	ADRE	ETF	40.51	40.9278	40.51	40.91	6311.0
2019-03-05	AFIF	ETF	10.0234	10.06	10.01	10.0336	20716.0
2019-03-05	AFK	ETF	21.81	21.81	21.81	21.81	862.0
2019-03-05	AFTY	ETF	16.783	16.899	16.78	16.89	9700.0
2019-03-05	AGG	ETF	106.73	106.84	106.67	106.83	5835800.0
2019-03-05	AGGY	ETF	48.82	48.87	48.77	48.87	43300.0
2019-03-05	AGNG	ETF	21.68	21.69	21.667	21.677	1600.0
2019-03-05	AGQ	ETF	24.49	24.73	24.4	24.71	109900.0
2019-03-05	AGZ	ETF	111.8152	111.9399	111.76	111.893	44829.0
2019-03-05	AGZD	ETF	23.825	23.915	23.81	23.81	22200.0
2019-03-05	AIA	ETF	60.95	61.4199	60.91	61.29	41027.0
2019-03-05	AIEQ	ETF	25.79	25.85	25.7	25.78	57500.0
2019-03-05	AIQ	ETF	15.43	15.44	15.32	15.4	123073.0
2019-03-05	AIRR	ETF	25.5	25.57	25.45	25.45	11100.0
2019-03-05	AIVI	ETF	40.76	40.88	40.74	40.87	9700.0
2019-03-05	ALTY	ETF	14.97	14.97	14.667	14.68	11600.0
2019-03-05	AMJ	ETF	24.9	24.9	24.61	24.77	1813129.0
2019-03-05	AMLP	ETF	48.95	49.0	48.4	48.85	3179340.0
2019-03-05	AMUB	ETF	15.6048	15.6048	15.6048	15.6048	0.0
2019-03-05	AMZA	ETF	58.8	59.0	58.1	58.7	90570.0
2019-03-05	ANGL	ETF	28.54	28.54	28.47	28.54	207000.0
2019-03-05	AOA	ETF	52.91	52.99	52.81	52.99	70200.0
2019-03-05	AOK	ETF	33.98	33.98	33.9028	33.96	31767.0
2019-03-05	AOM	ETF	37.47	37.51	37.43	37.49	118643.0
2019-03-05	AOR	ETF	44.14	44.24	44.05	44.24	233962.0
2019-03-05	ARGT	ETF	27.75	27.86	27.73	27.75	7400.0
2019-03-05	ARKF	ETF	21.0	21.149	20.87	21.09	9400.0
2019-03-05	ARKG	ETF	31.72	32.043	31.269	31.68	156700.0
2019-03-05	ARKK	ETF	46.18	46.69	45.65	46.36	395400.0
2019-03-05	ARKQ	ETF	34.56	34.72	34.25	34.529	24500.0
2019-03-05	ARKW	ETF	50.85	51.44	50.6	51.22	78600.0
2019-03-05	ASEA	ETF	15.95	15.99	15.71	15.99	2200.0
2019-03-05	ASET	ETF	28.24	28.3799	28.24	28.36	2263.0
2019-03-05	ASHR	ETF	28.58	28.72	28.45	28.67	7007400.0

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

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