PREVIEW / etf_daily / 2019-06-26

all etf daily files

  file:    by_date/etf_daily/2019/2019-06-26.parquet
  size:    69 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-26	SPY	ETF	291.75	292.31	290.35	290.47	51584900.0
2019-06-26	QQQ	ETF	186.13	187.33	185.49	185.79	22595721.0
2019-06-26	IWM	ETF	151.7	152.22	150.76	150.8	15726900.0
2019-06-26	DIA	ETF	266.12	266.49	265.21	265.22	2141400.0
2019-06-26	GLD	ETF	132.99	133.55	132.41	132.97	12016400.0
2019-06-26	TLT	ETF	132.68	132.7	131.88	131.97	12766800.0
2019-06-26	AAAU	ETF	14.08	14.13	14.03	14.08	52300.0
2019-06-26	AADR	ETF	48.98	48.98	48.82	48.9	6300.0
2019-06-26	AAXJ	ETF	69.22	69.51	69.2	69.26	1023900.0
2019-06-26	ACES	ETF	29.13	29.13	28.858	28.858	15500.0
2019-06-26	ACSI	ETF	33.335	33.335	33.2114	33.2114	1146.0
2019-06-26	ACTX	ETF	18.8802	29.5003	18.8802	29.5003	903.0
2019-06-26	ACWF	ETF	28.96	29.045	28.88	28.88	3233.0
2019-06-26	ACWI	ETF	73.32	73.44	73.08	73.12	2500700.0
2019-06-26	ACWV	ETF	92.38	92.47	91.62	91.64	221700.0
2019-06-26	ACWX	ETF	46.58	46.65	46.49	46.49	775668.0
2019-06-26	ADRE	ETF	39.9028	39.9061	39.84	39.84	3278.0
2019-06-26	AFIF	ETF	9.84	9.86	9.83	9.8397	3302.0
2019-06-26	AFK	ETF	22.04	22.09	22.01	22.07	3304.0
2019-06-26	AFTY	ETF	17.28	17.289	17.2	17.202	2500.0
2019-06-26	AGG	ETF	111.29	111.31	111.06	111.09	3703200.0
2019-06-26	AGGY	ETF	51.2	51.2	51.07	51.106	61800.0
2019-06-26	AGNG	ETF	21.27	21.27	20.96	20.98	3900.0
2019-06-26	AGQ	ETF	24.58	24.84	24.45	24.6	218400.0
2019-06-26	AGZ	ETF	115.23	115.23	115.04	115.04	26846.0
2019-06-26	AGZD	ETF	23.805	23.825	23.77	23.78	99600.0
2019-06-26	AIA	ETF	60.57	60.84	60.5	60.62	163733.0
2019-06-26	AIEQ	ETF	26.0	26.2	26.0	26.059	13700.0
2019-06-26	AIQ	ETF	16.24	16.24	16.1479	16.1479	15691.0
2019-06-26	AIRR	ETF	25.45	25.52	25.45	25.51	1700.0
2019-06-26	AIVI	ETF	40.87	40.96	40.85	40.86	5200.0
2019-06-26	ALTY	ETF	14.94	14.96	14.85	14.855	7700.0
2019-06-26	AMJ	ETF	24.85	24.955	24.68	24.8	1051164.0
2019-06-26	AMLP	ETF	48.8	49.15	48.7	48.75	2120860.0
2019-06-26	AMOM	ETF	25.52	25.52	25.273	25.273	2800.0
2019-06-26	AMUB	ETF	15.63	15.63	15.6289	15.6289	200.0
2019-06-26	AMZA	ETF	54.6	55.4	54.2	54.9	55460.0
2019-06-26	ANGL	ETF	29.12	29.23	29.1	29.14	257800.0
2019-06-26	AOA	ETF	54.78	54.92	54.68	54.73	27300.0
2019-06-26	AOK	ETF	35.28	35.33	35.2201	35.23	146370.0
2019-06-26	AOM	ETF	38.91	38.98	38.85	38.87	116257.0
2019-06-26	AOR	ETF	45.8	45.8	45.69	45.73	168501.0
2019-06-26	ARGT	ETF	32.23	32.26	31.73	31.75	42500.0
2019-06-26	ARKF	ETF	22.22	22.37	22.21	22.21	6400.0
2019-06-26	ARKG	ETF	32.57	32.72	32.02	32.14	232400.0
2019-06-26	ARKK	ETF	44.88	45.06	44.54	44.69	235500.0
2019-06-26	ARKQ	ETF	32.0	32.4	32.0	32.25	6800.0
2019-06-26	ARKW	ETF	50.69	51.33	50.69	50.84	42700.0
2019-06-26	ASEA	ETF	16.5	17.09	16.5	16.79	7600.0
2019-06-26	ASET	ETF	29.4707	29.515	29.4707	29.49	948.0

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

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