PREVIEW / etf_daily / 2018-02-22

all etf daily files

  file:    by_date/etf_daily/2018/2018-02-22.parquet
  size:    60 KB
  rows:    1,551

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
2018-02-22	SPY	ETF	271.1	273.05	269.64	270.4	110511300.0
2018-02-22	QQQ	ETF	165.54	166.42	164.3769	164.8	37074413.0
2018-02-22	IWM	ETF	152.81	154.03	151.91	152.0	16340000.0
2018-02-22	DIA	ETF	248.63	251.36	248.53	249.49	6342300.0
2018-02-22	GLD	ETF	125.92	126.37	125.88	126.3	5346300.0
2018-02-22	TLT	ETF	117.24	117.66	117.0	117.09	9317900.0
2018-02-22	AADR	ETF	61.16	61.66	61.16	61.44	22900.0
2018-02-22	AAXJ	ETF	78.0	78.49	77.63	77.74	1159300.0
2018-02-22	ACSI	ETF	31.135	31.135	31.111	31.111	981.0
2018-02-22	ACTX	ETF	70.8006	70.8006	66.6706	67.8506	479.0
2018-02-22	ACWF	ETF	31.52	31.603	31.38	31.422	3725.0
2018-02-22	ACWI	ETF	73.16	73.69	72.95	73.08	1917500.0
2018-02-22	ACWV	ETF	83.51	83.98	83.34	83.46	327500.0
2018-02-22	ACWX	ETF	50.51	50.8154	50.41	50.51	958611.0
2018-02-22	ADRE	ETF	45.65	45.95	45.59	45.59	7130.0
2018-02-22	AFK	ETF	26.0	26.0	25.49	25.49	223979.0
2018-02-22	AFTY	ETF	18.95	18.95	18.81	18.881	24600.0
2018-02-22	AGG	ETF	106.49	106.56	106.36	106.36	2485400.0
2018-02-22	AGGY	ETF	49.023	49.117	49.0	49.024	54200.0
2018-02-22	AGNG	ETF	20.19	20.231	20.05	20.06	3400.0
2018-02-22	AGQ	ETF	32.15	32.52	32.03	32.29	57800.0
2018-02-22	AGZ	ETF	111.35	111.4	111.308	111.33	7865.0
2018-02-22	AGZD	ETF	24.04	24.14	24.04	24.115	6200.0
2018-02-22	AIA	ETF	68.53	68.8	68.07	68.19	64410.0
2018-02-22	AIEQ	ETF	26.59	26.8	26.44	26.48	69100.0
2018-02-22	AIRR	ETF	26.71	26.887	26.52	26.52	24900.0
2018-02-22	AIVI	ETF	43.37	43.56	43.26	43.36	10700.0
2018-02-22	ALTY	ETF	14.62	14.635	14.55	14.6	4700.0
2018-02-22	AMJ	ETF	27.5	27.85	26.78	26.8	1658797.0
2018-02-22	AMLP	ETF	52.65	53.0	51.4	51.5	3754540.0
2018-02-22	AMZA	ETF	80.3	80.8	78.6	78.9	271460.0
2018-02-22	ANGL	ETF	29.36	29.47	29.29	29.31	584900.0
2018-02-22	AOA	ETF	54.22	54.5	54.05	54.15	54100.0
2018-02-22	AOK	ETF	34.18	34.33	34.15	34.15	43832.0
2018-02-22	AOM	ETF	37.83	37.9378	37.75	37.81	133964.0
2018-02-22	AOR	ETF	44.84	45.075	44.79	44.79	90921.0
2018-02-22	ARGT	ETF	37.15	37.3	36.83	36.93	134800.0
2018-02-22	ARKG	ETF	26.98	27.09	26.6	26.62	84100.0
2018-02-22	ARKK	ETF	41.42	41.46	40.851	40.99	599700.0
2018-02-22	ARKQ	ETF	35.26	35.36	34.977	35.13	18500.0
2018-02-22	ARKW	ETF	51.58	51.62	51.03	51.14	178200.0
2018-02-22	ASEA	ETF	18.18	18.18	17.91	18.01	5000.0
2018-02-22	ASET	ETF	27.415	27.4499	27.415	27.4499	766.0
2018-02-22	ASHR	ETF	32.05	32.18	31.9	31.98	669600.0
2018-02-22	ASHS	ETF	33.86	34.05	33.7	33.7	7700.0
2018-02-22	ASHX	ETF	22.32	22.3275	22.32	22.3275	355.0
2018-02-22	ATMP	ETF	20.7	20.72	20.3	20.3	399500.0
2018-02-22	BAB	ETF	29.37	29.416	29.36	29.4	82012.0
2018-02-22	BAL	ETF	52.41	52.41	52.18	52.18	719.0
2018-02-22	BAR	ETF	13.305	13.305	13.305	13.305	3690.0

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

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