PREVIEW / etf_daily / 2018-05-08

all etf daily files

  file:    by_date/etf_daily/2018/2018-05-08.parquet
  size:    60 KB
  rows:    1,553

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-05-08	SPY	ETF	266.5	267.33	265.15	266.92	67499200.0
2018-05-08	QQQ	ETF	165.83	166.43	164.86	166.07	26040170.0
2018-05-08	IWM	ETF	156.92	157.83	156.75	157.83	17281200.0
2018-05-08	DIA	ETF	243.17	243.98	241.84	243.42	2927200.0
2018-05-08	GLD	ETF	124.14	124.95	123.79	124.59	5551100.0
2018-05-08	TLT	ETF	118.55	119.0	118.3	118.69	6091200.0
2018-05-08	AADR	ETF	57.8	57.8	56.97	57.48	21500.0
2018-05-08	AAXJ	ETF	75.8	76.08	75.47	76.04	610200.0
2018-05-08	ACSI	ETF	31.0648	31.0648	30.99	30.9902	1501.0
2018-05-08	ACTX	ETF	59.5905	66.0806	56.0505	64.3106	721.0
2018-05-08	ACWF	ETF	30.751	30.869	30.751	30.8399	7220.0
2018-05-08	ACWI	ETF	72.22	72.39	72.01	72.37	1379300.0
2018-05-08	ACWV	ETF	83.29	83.35	83.05	83.26	63800.0
2018-05-08	ACWX	ETF	49.77	49.96	49.66	49.96	193967.0
2018-05-08	ADRE	ETF	43.9	44.12	43.9	43.9816	6368.0
2018-05-08	AFK	ETF	25.31	25.45	25.1371	25.2378	5782.0
2018-05-08	AFTY	ETF	17.17	17.25	17.17	17.25	18000.0
2018-05-08	AGG	ETF	105.66	105.75	105.6	105.69	2591700.0
2018-05-08	AGGY	ETF	48.48	48.54	48.462	48.514	35700.0
2018-05-08	AGNG	ETF	19.63	19.63	19.62	19.62	300.0
2018-05-08	AGQ	ETF	31.26	31.58	30.77	31.36	194500.0
2018-05-08	AGZ	ETF	110.81	110.95	110.79	110.83	16590.0
2018-05-08	AGZD	ETF	24.115	24.115	23.955	23.955	800.0
2018-05-08	AIA	ETF	66.47	66.67	66.23	66.65	43635.0
2018-05-08	AIEQ	ETF	26.89	26.93	26.77	26.9	29700.0
2018-05-08	AIRR	ETF	25.81	26.06	25.78	26.06	55900.0
2018-05-08	AIVI	ETF	44.24	44.28	44.13	44.28	5100.0
2018-05-08	ALTY	ETF	14.67	14.68	14.67	14.674	3800.0
2018-05-08	AMJ	ETF	26.09	26.26	25.655	26.24	2805338.0
2018-05-08	AMLP	ETF	50.45	51.05	49.85	51.0	3226840.0
2018-05-08	AMZA	ETF	73.0	74.3	72.5	74.0	72220.0
2018-05-08	ANGL	ETF	29.03	29.03	28.93	29.0	386600.0
2018-05-08	AOA	ETF	53.51	53.63	53.41	53.62	31500.0
2018-05-08	AOK	ETF	33.96	33.9699	33.8701	33.95	34394.0
2018-05-08	AOM	ETF	37.4	37.47	37.3795	37.47	56084.0
2018-05-08	AOR	ETF	44.36	44.47	44.3001	44.46	61824.0
2018-05-08	ARGT	ETF	32.48	32.48	31.04	31.58	675600.0
2018-05-08	ARKG	ETF	26.51	26.51	26.08	26.25	25100.0
2018-05-08	ARKK	ETF	40.84	41.29	40.7	41.29	220700.0
2018-05-08	ARKQ	ETF	33.56	33.885	33.51	33.87	15000.0
2018-05-08	ARKW	ETF	52.2	52.84	52.11	52.84	286000.0
2018-05-08	ASEA	ETF	17.29	17.29	17.2	17.2	2400.0
2018-05-08	ASET	ETF	27.895	27.895	27.8767	27.8767	1223.0
2018-05-08	ASHR	ETF	30.36	30.42	30.27	30.36	1529400.0
2018-05-08	ASHS	ETF	34.55	34.55	34.33	34.33	3900.0
2018-05-08	ASHX	ETF	21.04	21.04	21.04	21.04	100.0
2018-05-08	ATMP	ETF	19.9	19.97	19.67	19.95	19600.0
2018-05-08	BAB	ETF	29.57	29.59	29.48	29.55	227787.0
2018-05-08	BAL	ETF	52.22	52.22	51.7108	51.7108	600.0
2018-05-08	BAR	ETF	13.063	13.158	13.063	13.148	43930.0

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

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