PREVIEW / etf_daily / 2018-04-26

all etf daily files

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

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-26	SPY	ETF	264.79	267.25	264.29	266.31	67731900.0
2018-04-26	QQQ	ETF	160.72	162.53	160.18	161.99	43005532.0
2018-04-26	IWM	ETF	154.42	155.41	153.94	154.91	14862900.0
2018-04-26	DIA	ETF	241.43	243.88	241.12	243.12	3845800.0
2018-04-26	GLD	ETF	125.54	125.57	124.69	124.97	7517100.0
2018-04-26	TLT	ETF	117.73	118.13	117.59	117.98	6528600.0
2018-04-26	AADR	ETF	58.16	58.36	57.93	58.3	29100.0
2018-04-26	AAXJ	ETF	75.38	76.05	75.38	76.02	425200.0
2018-04-26	ACSI	ETF	30.88	31.085	30.88	31.085	2058.0
2018-04-26	ACTX	ETF	58.1155	64.3106	53.6905	60.4755	107.0
2018-04-26	ACWF	ETF	30.74	30.94	30.68	30.8448	28249.0
2018-04-26	ACWI	ETF	71.98	72.45	71.89	72.26	2000200.0
2018-04-26	ACWV	ETF	83.27	83.89	83.27	83.65	65100.0
2018-04-26	ACWX	ETF	50.02	50.17	49.93	50.11	425194.0
2018-04-26	ADRE	ETF	43.02	43.1434	42.93	43.1434	10375.0
2018-04-26	AFK	ETF	25.2661	25.4	25.2661	25.4	863.0
2018-04-26	AFTY	ETF	16.88	17.17	16.88	17.17	5900.0
2018-04-26	AGG	ETF	105.83	105.9	105.76	105.85	4870300.0
2018-04-26	AGGY	ETF	48.52	48.55	48.512	48.524	37200.0
2018-04-26	AGNG	ETF	19.425	19.65	19.37	19.57	2200.0
2018-04-26	AGQ	ETF	31.92	31.92	31.22	31.66	130300.0
2018-04-26	AGZ	ETF	110.89	111.0586	110.86	110.9	15783.0
2018-04-26	AGZD	ETF	23.96	24.075	23.945	24.0	19600.0
2018-04-26	AIA	ETF	66.66	67.0802	66.58	67.02	48415.0
2018-04-26	AIEQ	ETF	26.44	26.583	26.4	26.5	42900.0
2018-04-26	AIRR	ETF	25.74	25.74	25.35	25.45	17500.0
2018-04-26	AIVI	ETF	44.45	44.58	44.43	44.58	31600.0
2018-04-26	ALTY	ETF	14.47	14.53	14.47	14.53	2800.0
2018-04-26	AMJ	ETF	26.05	26.16	25.58	25.81	2619818.0
2018-04-26	AMLP	ETF	50.8	51.0	50.0	50.45	2734960.0
2018-04-26	AMZA	ETF	73.6	74.0	72.4	73.3	89120.0
2018-04-26	ANGL	ETF	29.06	29.14	29.02	29.06	699000.0
2018-04-26	AOA	ETF	53.46	53.77	53.4	53.59	45900.0
2018-04-26	AOK	ETF	33.96	34.08	33.92	34.07	27295.0
2018-04-26	AOM	ETF	37.38	37.563	37.37	37.53	63704.0
2018-04-26	AOR	ETF	44.45	44.5451	44.33	44.52	39962.0
2018-04-26	ARCM	ETF	100.32	100.33	100.32	100.33	1200.0
2018-04-26	ARGT	ETF	35.01	35.01	34.49	34.51	83200.0
2018-04-26	ARKG	ETF	25.45	26.0	25.45	26.0	64600.0
2018-04-26	ARKK	ETF	39.3	39.59	38.84	39.54	170800.0
2018-04-26	ARKQ	ETF	32.48	32.646	32.19	32.6	24100.0
2018-04-26	ARKW	ETF	49.28	49.9	49.035	49.68	131700.0
2018-04-26	ASEA	ETF	17.73	17.73	17.61	17.66	1200.0
2018-04-26	ASHR	ETF	29.77	29.9	29.72	29.81	758800.0
2018-04-26	ASHS	ETF	33.68	33.87	33.68	33.84	3500.0
2018-04-26	ASHX	ETF	20.62	20.66	20.62	20.66	300.0
2018-04-26	ATMP	ETF	19.64	19.64	19.43	19.6	15800.0
2018-04-26	BAB	ETF	29.46	29.55	29.41	29.53	102113.0
2018-04-26	BAR	ETF	13.197	13.197	13.161	13.161	17800.0
2018-04-26	BBC	ETF	31.2516	31.4499	31.2516	31.362	2998.0

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

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