PREVIEW / etf_daily / 2018-04-05

all etf daily files

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

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-05	SPY	ETF	265.55	266.64	264.32	265.64	82652600.0
2018-04-05	QQQ	ETF	161.33	161.58	159.48	160.65	43054868.0
2018-04-05	IWM	ETF	153.04	153.61	152.32	153.42	17301600.0
2018-04-05	DIA	ETF	243.8	246.09	243.38	244.91	4786400.0
2018-04-05	GLD	ETF	125.45	126.08	125.43	125.8	5333000.0
2018-04-05	TLT	ETF	120.1	120.27	119.77	119.79	7603700.0
2018-04-05	AADR	ETF	58.44	58.65	58.14	58.38	20500.0
2018-04-05	AAXJ	ETF	77.01	77.36	76.74	77.05	320200.0
2018-04-05	ACSI	ETF	30.8456	31.139	30.8456	31.139	2181.0
2018-04-05	ACTX	ETF	53.1005	56.0505	51.9205	53.1005	403.0
2018-04-05	ACWF	ETF	30.8834	31.01	30.8198	30.88	5523.0
2018-04-05	ACWI	ETF	71.79	72.23	71.74	72.02	1838000.0
2018-04-05	ACWV	ETF	84.12	84.43	83.98	84.25	72800.0
2018-04-05	ACWX	ETF	49.69	49.9422	49.67	49.83	390250.0
2018-04-05	ADRE	ETF	44.27	44.27	43.9464	43.9464	2778.0
2018-04-05	AFK	ETF	25.6	25.6	25.4672	25.4672	4479.0
2018-04-05	AFTY	ETF	17.54	17.61	17.41	17.61	1600.0
2018-04-05	AGG	ETF	106.71	106.76	106.63	106.67	2592500.0
2018-04-05	AGGY	ETF	49.14	49.18	49.11	49.12	34100.0
2018-04-05	AGNG	ETF	20.01	20.01	19.588	19.588	1900.0
2018-04-05	AGQ	ETF	30.5	31.32	30.5	31.27	87500.0
2018-04-05	AGZ	ETF	111.495	111.54	111.34	111.35	93264.0
2018-04-05	AGZD	ETF	23.945	23.96	23.945	23.96	7800.0
2018-04-05	AIA	ETF	67.61	67.8558	67.26	67.71	3246383.0
2018-04-05	AIEQ	ETF	26.06	26.279	26.05	26.23	44100.0
2018-04-05	AIRR	ETF	26.0	26.259	25.965	26.18	23200.0
2018-04-05	AIVI	ETF	43.43	43.56	43.43	43.55	9100.0
2018-04-05	ALTY	ETF	14.52	14.58	14.47	14.543	4800.0
2018-04-05	AMJ	ETF	24.02	24.45	23.95	24.36	1993112.0
2018-04-05	AMLP	ETF	46.8	47.7	46.6	47.45	3244320.0
2018-04-05	AMZA	ETF	68.6	70.2	68.4	69.8	97510.0
2018-04-05	ANGL	ETF	28.85	28.98	28.85	28.88	305100.0
2018-04-05	AOA	ETF	53.56	53.73	53.37	53.58	101000.0
2018-04-05	AOK	ETF	34.07	34.1499	34.07	34.08	69156.0
2018-04-05	AOM	ETF	37.57	37.66	37.54	37.56	103174.0
2018-04-05	AOR	ETF	44.5	44.56	44.38	44.48	107570.0
2018-04-05	ARGT	ETF	36.0	36.21	35.85	35.94	79200.0
2018-04-05	ARKG	ETF	26.32	26.52	25.471	25.65	47600.0
2018-04-05	ARKK	ETF	39.98	39.98	39.044	39.53	323900.0
2018-04-05	ARKQ	ETF	33.0	33.35	32.891	33.12	42400.0
2018-04-05	ARKW	ETF	50.02	50.214	49.42	49.86	152700.0
2018-04-05	ASEA	ETF	17.7	17.72	17.62	17.69	2700.0
2018-04-05	ASET	ETF	27.6	27.629	27.54	27.629	1204.0
2018-04-05	ASHR	ETF	31.09	31.18	30.99	31.07	1071700.0
2018-04-05	ASHS	ETF	35.14	35.29	35.14	35.21	5400.0
2018-04-05	ASHX	ETF	21.31	21.43	20.67	20.67	23617.0
2018-04-05	ATMP	ETF	18.18	18.67	18.18	18.64	36300.0
2018-04-05	BAB	ETF	29.93	29.93	29.86	29.88	54579.0
2018-04-05	BAL	ETF	53.253	54.63	53.253	54.63	7376.0
2018-04-05	BAR	ETF	13.218	13.244	13.218	13.242	13340.0

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

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