PREVIEW / etf_daily / 2018-04-17

all etf daily files

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

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-17	SPY	ETF	269.33	270.87	268.75	270.19	64682000.0
2018-04-17	QQQ	ETF	164.19	166.4592	163.91	166.1	35536087.0
2018-04-17	IWM	ETF	156.21	157.49	155.96	157.06	18624200.0
2018-04-17	DIA	ETF	248.15	248.48	247.27	247.8	3821900.0
2018-04-17	GLD	ETF	127.02	127.78	127.0	127.75	4184100.0
2018-04-17	TLT	ETF	120.92	121.58	120.82	121.27	5590400.0
2018-04-17	AADR	ETF	59.0	59.58	59.0	59.53	42200.0
2018-04-17	AAXJ	ETF	76.6	77.2	76.56	76.98	852000.0
2018-04-17	ACSI	ETF	31.21	31.31	31.21	31.31	520.0
2018-04-17	ACTX	ETF	68.4406	70.8006	59.0005	64.3106	1111.0
2018-04-17	ACWF	ETF	31.179	31.3	31.13	31.245	184229.0
2018-04-17	ACWI	ETF	72.83	73.3	72.77	73.1	865600.0
2018-04-17	ACWV	ETF	84.65	84.93	84.45	84.81	430200.0
2018-04-17	ACWX	ETF	50.23	50.51	50.215	50.4	284135.0
2018-04-17	ADRE	ETF	43.6986	44.1447	43.6644	44.06	4996.0
2018-04-17	AFK	ETF	25.31	25.85	25.31	25.65	4601.0
2018-04-17	AFTY	ETF	17.17	17.19	17.077	17.15	6500.0
2018-04-17	AGG	ETF	106.81	106.89	106.75	106.85	2363000.0
2018-04-17	AGGY	ETF	49.24	49.28	49.21	49.268	49800.0
2018-04-17	AGNG	ETF	19.711	19.75	19.711	19.75	1000.0
2018-04-17	AGQ	ETF	32.3	32.76	32.23	32.65	127900.0
2018-04-17	AGZ	ETF	111.33	111.41	111.33	111.39	11045.0
2018-04-17	AGZD	ETF	24.09	24.1	24.09	24.1	4000.0
2018-04-17	AIA	ETF	67.24	67.7862	67.24	67.6	67411.0
2018-04-17	AIEQ	ETF	26.5	26.67	26.43	26.6	69300.0
2018-04-17	AIRR	ETF	26.46	26.46	26.21	26.343	46500.0
2018-04-17	AIVI	ETF	44.3	44.44	44.25	44.42	5900.0
2018-04-17	ALTY	ETF	14.58	14.68	14.55	14.677	2500.0
2018-04-17	AMJ	ETF	25.74	26.61	25.68	26.61	3137162.0
2018-04-17	AMLP	ETF	50.65	52.0	50.2	51.25	4771160.0
2018-04-17	AMZA	ETF	74.0	76.19	74.0	75.1	118120.0
2018-04-17	ANGL	ETF	29.39	29.46	29.32	29.41	152000.0
2018-04-17	AOA	ETF	54.09	54.34	54.01	54.27	58500.0
2018-04-17	AOK	ETF	34.31	34.35	34.25	34.3344	24472.0
2018-04-17	AOM	ETF	37.81	37.91	37.74	37.83	93282.0
2018-04-17	AOR	ETF	44.84	44.999	44.771	44.91	97430.0
2018-04-17	ARGT	ETF	35.09	35.92	35.08	35.85	276600.0
2018-04-17	ARKG	ETF	26.64	27.15	26.51	27.05	70000.0
2018-04-17	ARKK	ETF	40.62	41.47	40.48	41.38	252300.0
2018-04-17	ARKQ	ETF	33.76	34.27	33.71	34.235	38200.0
2018-04-17	ARKW	ETF	50.6	51.79	50.46	51.67	225000.0
2018-04-17	ASEA	ETF	17.94	18.04	17.85	18.03	5900.0
2018-04-17	ASET	ETF	27.98	28.0947	27.97	28.0947	3063.0
2018-04-17	ASHR	ETF	30.24	30.31	30.1	30.1	861400.0
2018-04-17	ASHS	ETF	34.4	34.71	34.4	34.42	7200.0
2018-04-17	ATMP	ETF	19.39	20.03	19.39	19.88	28400.0
2018-04-17	BAB	ETF	30.03	30.09	29.98	30.07	111024.0
2018-04-17	BAL	ETF	49.93	50.24	49.8	50.2	1100.0
2018-04-17	BAR	ETF	13.44	13.453	13.44	13.453	9470.0
2018-04-17	BBC	ETF	31.87	32.95	31.87	32.95	19708.0

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

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