PREVIEW / etf_daily / 2019-02-22

all etf daily files

  file:    by_date/etf_daily/2019/2019-02-22.parquet
  size:    68 KB
  rows:    1,745

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-02-22	SPY	ETF	278.11	279.36	277.4	279.14	78114600.0
2019-02-22	QQQ	ETF	171.98	173.01	171.9	172.89	27735358.0
2019-02-22	IWM	ETF	157.27	158.27	157.1	158.15	20411800.0
2019-02-22	DIA	ETF	259.26	260.41	259.01	260.17	3938500.0
2019-02-22	GLD	ETF	125.53	125.95	125.39	125.5	5439400.0
2019-02-22	TLT	ETF	121.47	121.95	121.42	121.57	6374600.0
2019-02-22	AAAU	ETF	13.27	13.31	13.26	13.28	7000.0
2019-02-22	AADR	ETF	45.84	46.19	45.75	46.12	12400.0
2019-02-22	AAXJ	ETF	69.88	70.15	69.75	70.02	741700.0
2019-02-22	ACES	ETF	26.7	27.051	26.7	27.051	5800.0
2019-02-22	ACSI	ETF	32.3401	32.5648	32.3401	32.5648	1530.0
2019-02-22	ACTX	ETF	67.2606	68.4406	61.9506	66.6706	797.0
2019-02-22	ACWF	ETF	29.25	29.415	29.25	29.38	17163.0
2019-02-22	ACWI	ETF	71.0	71.27	70.93	71.2	1467400.0
2019-02-22	ACWV	ETF	87.3	87.73	87.28	87.64	211100.0
2019-02-22	ACWX	ETF	45.87	46.0469	45.85	45.95	1393195.0
2019-02-22	ADRE	ETF	40.44	40.6327	40.3943	40.5644	2242.0
2019-02-22	AFIF	ETF	9.98	9.9985	9.97	9.995	11289.0
2019-02-22	AFK	ETF	22.33	22.44	22.275	22.31	4041.0
2019-02-22	AFTY	ETF	15.5	15.59	15.497	15.564	4100.0
2019-02-22	AGG	ETF	107.25	107.52	107.22	107.4	2731500.0
2019-02-22	AGGY	ETF	48.89	48.959	48.845	48.908	54500.0
2019-02-22	AGNG	ETF	21.294	21.313	21.262	21.262	2000.0
2019-02-22	AGQ	ETF	27.41	27.66	27.38	27.46	467100.0
2019-02-22	AGZ	ETF	112.3	112.39	112.2718	112.29	15423.0
2019-02-22	AGZD	ETF	23.805	23.865	23.76	23.78	42800.0
2019-02-22	AIA	ETF	61.37	61.63	61.2951	61.5	51490.0
2019-02-22	AIEQ	ETF	25.62	25.793	25.6	25.79	32800.0
2019-02-22	AIQ	ETF	15.3247	15.368	15.3	15.3166	7885.0
2019-02-22	AIRR	ETF	25.62	25.798	25.62	25.71	23700.0
2019-02-22	AIVI	ETF	40.84	40.98	40.84	40.87	9700.0
2019-02-22	ALTY	ETF	14.837	14.91	14.837	14.9	7200.0
2019-02-22	AMJ	ETF	25.66	25.8	25.52	25.55	1379836.0
2019-02-22	AMLP	ETF	49.55	49.85	49.2	49.2	3137600.0
2019-02-22	AMUB	ETF	16.11	16.1116	16.11	16.1116	200.0
2019-02-22	AMZA	ETF	59.6	60.35	59.6	59.6	47750.0
2019-02-22	ANGL	ETF	28.56	28.58	28.48	28.54	166200.0
2019-02-22	AOA	ETF	52.79	52.96	52.75	52.95	46900.0
2019-02-22	AOK	ETF	33.98	34.08	33.95	34.06	46414.0
2019-02-22	AOM	ETF	37.45	37.54	37.41	37.54	117187.0
2019-02-22	AOR	ETF	44.06	44.1844	44.0325	44.15	198416.0
2019-02-22	ARGT	ETF	27.38	27.71	27.33	27.71	17700.0
2019-02-22	ARKF	ETF	20.78	21.057	20.78	21.057	62000.0
2019-02-22	ARKG	ETF	29.05	29.52	29.05	29.47	81100.0
2019-02-22	ARKK	ETF	45.11	45.78	45.02	45.77	245500.0
2019-02-22	ARKQ	ETF	35.08	35.11	34.87	35.11	13500.0
2019-02-22	ARKW	ETF	50.87	51.72	50.87	51.72	112700.0
2019-02-22	ASEA	ETF	16.2	16.23	16.08	16.23	2000.0
2019-02-22	ASET	ETF	28.5698	28.59	28.48	28.48	2757.0
2019-02-22	ASHR	ETF	26.33	26.52	26.31	26.47	5371900.0

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

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