PREVIEW / etf_daily / 2019-02-06

all etf daily files

  file:    by_date/etf_daily/2019/2019-02-06.parquet
  size:    67 KB
  rows:    1,744

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-06	SPY	ETF	272.79	273.34	271.92	272.74	58347800.0
2019-02-06	QQQ	ETF	171.06	171.37	169.75	170.52	27970006.0
2019-02-06	IWM	ETF	151.04	151.37	150.1	150.93	13720600.0
2019-02-06	DIA	ETF	253.63	254.35	253.05	253.87	1913500.0
2019-02-06	GLD	ETF	124.16	124.19	123.4	123.44	6595100.0
2019-02-06	TLT	ETF	121.36	121.41	120.73	121.03	5184000.0
2019-02-06	AAAU	ETF	13.13	13.13	13.06	13.06	5800.0
2019-02-06	AADR	ETF	44.5	44.62	44.21	44.27	8800.0
2019-02-06	AAXJ	ETF	69.78	69.78	69.03	69.16	865200.0
2019-02-06	ACES	ETF	25.88	25.94	25.86	25.893	900.0
2019-02-06	ACSI	ETF	31.6111	31.6122	31.579	31.6122	870.0
2019-02-06	ACTX	ETF	49.3834	49.5604	46.0204	47.7904	249.0
2019-02-06	ACWF	ETF	28.68	28.78	28.68	28.7284	10057.0
2019-02-06	ACWI	ETF	69.97	70.02	69.69	69.78	4517600.0
2019-02-06	ACWV	ETF	85.93	85.93	85.64	85.79	126600.0
2019-02-06	ACWX	ETF	45.46	45.5219	45.24	45.28	2606322.0
2019-02-06	ADRE	ETF	40.29	40.3399	40.0885	40.0969	4880.0
2019-02-06	AFIF	ETF	9.96	10.0199	9.96	9.995	15765.0
2019-02-06	AFK	ETF	21.68	22.0599	21.68	21.97	2901.0
2019-02-06	AFTY	ETF	14.94	14.94	14.841	14.841	100.0
2019-02-06	AGG	ETF	107.2	107.22	106.99	107.05	6449600.0
2019-02-06	AGGY	ETF	48.9	48.96	48.9	48.909	31500.0
2019-02-06	AGNG	ETF	20.97	21.024	20.89	21.024	1100.0
2019-02-06	AGQ	ETF	27.29	27.3	26.7	26.79	112600.0
2019-02-06	AGZ	ETF	112.07	112.07	111.9296	111.94	34772.0
2019-02-06	AGZD	ETF	23.85	23.885	23.78	23.785	46400.0
2019-02-06	AIA	ETF	61.28	61.28	60.59	60.68	52487.0
2019-02-06	AIEQ	ETF	25.17	25.21	24.96	25.09	19500.0
2019-02-06	AIQ	ETF	15.05	15.05	14.9282	14.9797	3001.0
2019-02-06	AIRR	ETF	24.45	24.555	24.41	24.46	18500.0
2019-02-06	AIVI	ETF	40.56	40.56	40.38	40.41	8000.0
2019-02-06	ALTY	ETF	14.68	14.69	14.659	14.663	7300.0
2019-02-06	AMJ	ETF	25.43	25.5	25.07	25.12	6628735.0
2019-02-06	AMLP	ETF	50.1	50.3	49.4	49.55	2931280.0
2019-02-06	AMUB	ETF	15.8392	15.8392	15.8392	15.8392	0.0
2019-02-06	AMZA	ETF	59.8	60.0	59.1	59.1	42150.0
2019-02-06	ANGL	ETF	28.25	28.33	28.19	28.3	423000.0
2019-02-06	AOA	ETF	52.08	52.11	51.91	51.97	71400.0
2019-02-06	AOK	ETF	33.79	33.8	33.69	33.72	53914.0
2019-02-06	AOM	ETF	37.15	37.19	37.06	37.06	846690.0
2019-02-06	AOR	ETF	43.59	43.615	43.47	43.49	157479.0
2019-02-06	ARGT	ETF	28.1	28.17	27.67	27.73	49300.0
2019-02-06	ARKF	ETF	20.52	20.534	20.31	20.47	45300.0
2019-02-06	ARKG	ETF	28.4	28.59	28.16	28.36	46200.0
2019-02-06	ARKK	ETF	43.86	44.2	43.549	43.96	306600.0
2019-02-06	ARKQ	ETF	34.11	34.44	34.07	34.21	39600.0
2019-02-06	ARKW	ETF	50.67	50.798	49.94	50.43	117000.0
2019-02-06	ASEA	ETF	16.31	16.31	16.1	16.14	3600.0
2019-02-06	ASET	ETF	27.9206	27.9206	27.78	27.79	17085.0
2019-02-06	ASHR	ETF	24.45	24.45	24.17	24.17	743800.0

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

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