PREVIEW / etf_daily / 2018-04-20

all etf daily files

  file:    by_date/etf_daily/2018/2018-04-20.parquet
  size:    60 KB
  rows:    1,554

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-04-20	SPY	ETF	268.81	269.06	265.61	266.61	99953100.0
2018-04-20	QQQ	ETF	164.49	164.61	161.73	162.3	49197140.0
2018-04-20	IWM	ETF	156.05	156.72	155.15	155.55	21480600.0
2018-04-20	DIA	ETF	246.37	246.66	243.59	244.48	3396500.0
2018-04-20	GLD	ETF	126.69	126.97	126.55	126.63	10403100.0
2018-04-20	TLT	ETF	118.89	119.13	118.43	118.46	7579400.0
2018-04-20	AADR	ETF	59.7	59.7	59.17	59.32	18700.0
2018-04-20	AAXJ	ETF	76.75	76.75	75.89	76.26	661700.0
2018-04-20	ACSI	ETF	31.32	31.32	30.86	30.87	3456.0
2018-04-20	ACTX	ETF	64.3106	64.3106	51.9205	55.4605	346.0
2018-04-20	ACWF	ETF	31.16	31.17	30.78	31.02	21015.0
2018-04-20	ACWI	ETF	72.91	72.91	72.26	72.46	1393100.0
2018-04-20	ACWV	ETF	84.16	84.16	83.58	83.76	75600.0
2018-04-20	ACWX	ETF	50.35	50.4	50.14	50.23	753644.0
2018-04-20	ADRE	ETF	44.06	44.06	43.7541	43.8262	4649.0
2018-04-20	AFK	ETF	25.7	25.7	25.57	25.58	3503.0
2018-04-20	AFTY	ETF	17.0	17.07	16.83	16.88	2800.0
2018-04-20	AGG	ETF	106.15	106.24	106.0	106.0	2766000.0
2018-04-20	AGGY	ETF	48.89	48.9	48.813	48.815	57400.0
2018-04-20	AGNG	ETF	19.65	19.74	19.42	19.42	1400.0
2018-04-20	AGQ	ETF	34.15	34.32	33.91	33.98	82400.0
2018-04-20	AGZ	ETF	111.08	111.216	111.0101	111.0101	8795.0
2018-04-20	AGZD	ETF	24.1	24.1	24.075	24.1	7000.0
2018-04-20	AIA	ETF	67.54	67.54	66.83	67.1	53923.0
2018-04-20	AIEQ	ETF	26.65	26.747	26.565	26.61	27000.0
2018-04-20	AIRR	ETF	26.1	26.26	25.944	25.97	13100.0
2018-04-20	AIVI	ETF	44.33	44.42	44.3	44.31	1800.0
2018-04-20	ALTY	ETF	14.48	14.524	14.48	14.49	700.0
2018-04-20	AMJ	ETF	25.68	25.91	25.57	25.75	1758137.0
2018-04-20	AMLP	ETF	50.25	50.55	49.85	50.1	1993540.0
2018-04-20	AMZA	ETF	72.9	73.59	72.4	72.7	58640.0
2018-04-20	ANGL	ETF	29.4	29.4	29.25	29.29	287700.0
2018-04-20	AOA	ETF	54.03	54.03	53.71	53.79	38400.0
2018-04-20	AOK	ETF	34.22	34.22	34.08	34.12	57185.0
2018-04-20	AOM	ETF	37.73	37.73	37.56	37.61	102573.0
2018-04-20	AOR	ETF	44.77	44.77	44.51	44.6	84500.0
2018-04-20	ARCM	ETF	100.19	100.19	100.19	100.19	100.0
2018-04-20	ARGT	ETF	35.46	35.46	35.04	35.24	50700.0
2018-04-20	ARKG	ETF	26.91	26.91	26.41	26.465	45200.0
2018-04-20	ARKK	ETF	41.14	41.25	40.67	40.87	183500.0
2018-04-20	ARKQ	ETF	34.16	34.16	33.58	33.76	30700.0
2018-04-20	ARKW	ETF	51.59	51.65	50.86	50.97	106500.0
2018-04-20	ASET	ETF	27.83	27.83	27.7076	27.77	14388.0
2018-04-20	ASHR	ETF	29.91	29.91	29.6	29.65	1439100.0
2018-04-20	ASHS	ETF	34.12	34.12	33.65	33.69	6200.0
2018-04-20	ASHX	ETF	20.55	20.59	20.365	20.365	2800.0
2018-04-20	ATMP	ETF	19.66	19.67	19.52	19.58	37900.0
2018-04-20	BAB	ETF	29.75	29.79	29.7	29.7	55300.0
2018-04-20	BAL	ETF	50.98	51.15	50.98	51.15	401.0
2018-04-20	BAR	ETF	13.358	13.358	13.358	13.358	4010.0

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

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