PREVIEW / etf_daily / 2018-09-07

all etf daily files

  file:    by_date/etf_daily/2018/2018-09-07.parquet
  size:    62 KB
  rows:    1,599

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-09-07	SPY	ETF	286.98	288.7	286.71	287.6	73524800.0
2018-09-07	QQQ	ETF	180.53	182.67	180.44	181.11	46629495.0
2018-09-07	IWM	ETF	170.21	171.45	169.66	170.54	17248000.0
2018-09-07	DIA	ETF	259.33	260.34	258.46	259.54	3796400.0
2018-09-07	GLD	ETF	113.26	113.6	112.97	113.23	3714000.0
2018-09-07	TLT	ETF	119.33	119.4	118.99	119.13	11212600.0
2018-09-07	AAAU	ETF	11.97	11.98	11.94	11.96	20500.0
2018-09-07	AADR	ETF	49.63	50.37	49.63	50.13	24000.0
2018-09-07	AAXJ	ETF	68.72	69.24	68.5	68.68	993300.0
2018-09-07	ACES	ETF	25.695	25.695	25.695	25.695	400.0
2018-09-07	ACSI	ETF	33.9932	34.22	33.9932	34.08	1251.0
2018-09-07	ACTX	ETF	55.4605	55.4605	51.9205	52.5105	649.0
2018-09-07	ACWF	ETF	30.24	30.34	30.1738	30.22	42141.0
2018-09-07	ACWI	ETF	72.39	72.72	72.26	72.44	1790900.0
2018-09-07	ACWV	ETF	86.64	86.79	86.44	86.55	94600.0
2018-09-07	ACWX	ETF	46.04	46.24	45.9	46.05	977659.0
2018-09-07	ADRE	ETF	39.65	40.1566	39.65	40.0219	10700.0
2018-09-07	AFK	ETF	20.98	21.0438	20.79	20.8054	70739.0
2018-09-07	AFTY	ETF	14.42	14.51	14.229	14.229	3800.0
2018-09-07	AGG	ETF	105.92	105.94	105.81	105.81	2571600.0
2018-09-07	AGGY	ETF	48.51	48.55	48.47	48.48	27800.0
2018-09-07	AGNG	ETF	21.896	21.91	21.833	21.833	1900.0
2018-09-07	AGQ	ETF	22.66	22.93	22.54	22.62	90100.0
2018-09-07	AGZ	ETF	110.87	110.95	110.7601	110.78	5459.0
2018-09-07	AGZD	ETF	23.915	24.005	23.91	23.945	10000.0
2018-09-07	AIA	ETF	60.02	60.54	60.002	60.3	58954.0
2018-09-07	AIEQ	ETF	29.11	29.36	29.1	29.18	77500.0
2018-09-07	AIQ	ETF	15.45	15.525	15.45	15.4941	2951.0
2018-09-07	AIRR	ETF	28.01	28.086	27.84	28.06	18500.0
2018-09-07	AIVI	ETF	40.79	40.98	40.79	40.88	3600.0
2018-09-07	ALTY	ETF	15.23	15.23	15.11	15.12	3900.0
2018-09-07	AMJ	ETF	27.81	27.95	27.68	27.86	894806.0
2018-09-07	AMLP	ETF	54.15	54.45	53.95	54.35	2190940.0
2018-09-07	AMZA	ETF	77.7	77.98	77.1	77.6	51330.0
2018-09-07	ANGL	ETF	28.84	28.88	28.83	28.83	155700.0
2018-09-07	AOA	ETF	53.66	53.88	53.63	53.75	31000.0
2018-09-07	AOK	ETF	33.94	34.03	33.94	33.97	40513.0
2018-09-07	AOM	ETF	37.54	37.62	37.54	37.56	116655.0
2018-09-07	AOR	ETF	44.58	44.66	44.5032	44.57	114372.0
2018-09-07	ARGT	ETF	25.53	25.98	25.45	25.68	102100.0
2018-09-07	ARKG	ETF	32.18	32.983	32.16	32.479	130900.0
2018-09-07	ARKK	ETF	46.6	47.35	46.18	46.73	410400.0
2018-09-07	ARKQ	ETF	35.51	35.832	35.39	35.59	20500.0
2018-09-07	ARKW	ETF	56.4	57.63	56.07	56.94	146600.0
2018-09-07	ARVR	ETF	21.0322	21.0322	21.0322	21.0322	486.0
2018-09-07	ASEA	ETF	15.75	15.86	15.57	15.78	2900.0
2018-09-07	ASET	ETF	27.83	27.85	27.7546	27.7546	1028.0
2018-09-07	ASHR	ETF	24.16	24.3	23.99	24.05	845100.0
2018-09-07	ASHS	ETF	25.5	25.54	25.24	25.24	18500.0
2018-09-07	ASHX	ETF	17.21	17.29	17.21	17.25	1049.0

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

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