PREVIEW / etf_daily / 2018-04-03

all etf daily files

  file:    by_date/etf_daily/2018/2018-04-03.parquet
  size:    61 KB
  rows:    1,558

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-03	SPY	ETF	258.87	261.31	256.84	260.77	119956900.0
2018-04-03	QQQ	ETF	156.92	157.92	154.44	157.26	64090049.0
2018-04-03	IWM	ETF	149.02	150.6	148.3	150.25	29857800.0
2018-04-03	DIA	ETF	237.38	240.25	236.4	240.15	9874500.0
2018-04-03	GLD	ETF	126.54	126.59	126.01	126.3	6083700.0
2018-04-03	TLT	ETF	121.36	121.48	120.83	120.94	9855000.0
2018-04-03	AADR	ETF	57.55	57.97	57.52	57.86	13400.0
2018-04-03	AAXJ	ETF	76.87	77.08	76.32	77.03	365500.0
2018-04-03	ACSI	ETF	30.209	30.49	30.1533	30.38	1224.0
2018-04-03	ACTX	ETF	61.9506	61.9506	53.6905	55.4605	296.0
2018-04-03	ACWF	ETF	30.3	30.63	30.3	30.61	10460.0
2018-04-03	ACWI	ETF	70.74	71.08	70.22	71.01	4289400.0
2018-04-03	ACWV	ETF	82.88	83.44	82.74	83.32	161100.0
2018-04-03	ACWX	ETF	49.35	49.42	49.05	49.36	374350.0
2018-04-03	ADRE	ETF	43.71	44.049	43.52	43.6403	19998.0
2018-04-03	AFK	ETF	25.45	25.46	25.011	25.37	4846.0
2018-04-03	AFTY	ETF	17.32	17.41	17.31	17.41	1200.0
2018-04-03	AGG	ETF	106.82	106.87	106.74	106.78	9916100.0
2018-04-03	AGGY	ETF	49.27	49.28	49.19	49.23	30500.0
2018-04-03	AGNG	ETF	19.173	19.33	19.173	19.2	4400.0
2018-04-03	AGQ	ETF	31.52	31.52	31.1	31.3	90000.0
2018-04-03	AGZ	ETF	111.8	111.8248	111.49	111.51	700353.0
2018-04-03	AGZD	ETF	23.98	24.0	23.95	24.0	4800.0
2018-04-03	AIA	ETF	67.36	67.69	66.96	67.69	127873.0
2018-04-03	AIEQ	ETF	25.6	25.82	25.43	25.75	42600.0
2018-04-03	AIRR	ETF	25.42	25.73	25.35	25.66	10300.0
2018-04-03	AIVI	ETF	43.0	43.04	42.8	42.98	5800.0
2018-04-03	ALTY	ETF	14.58	14.58	14.45	14.54	11300.0
2018-04-03	AMJ	ETF	23.85	24.035	23.38	24.03	2754822.0
2018-04-03	AMLP	ETF	46.85	46.95	45.55	46.85	2601300.0
2018-04-03	AMZA	ETF	68.3	68.9	66.4	68.6	106380.0
2018-04-03	ANGL	ETF	28.93	28.98	28.82	28.92	503900.0
2018-04-03	AOA	ETF	52.83	52.98	52.55	52.98	69700.0
2018-04-03	AOK	ETF	34.09	34.09	33.9	34.04	37341.0
2018-04-03	AOM	ETF	37.4	37.4434	37.26	37.36	66989.0
2018-04-03	AOR	ETF	44.08	44.15	43.869	44.15	78386.0
2018-04-03	ARCM	ETF	100.15	100.15	100.149	100.149	600.0
2018-04-03	ARGT	ETF	35.49	35.55	35.21	35.43	83800.0
2018-04-03	ARKG	ETF	24.89	25.41	24.742	25.38	33800.0
2018-04-03	ARKK	ETF	38.41	38.585	37.62	38.35	332100.0
2018-04-03	ARKQ	ETF	32.19	32.38	31.861	32.21	20000.0
2018-04-03	ARKW	ETF	49.01	49.419	48.12	48.77	221100.0
2018-04-03	ASEA	ETF	17.6	17.84	17.6	17.74	1200.0
2018-04-03	ASET	ETF	27.2054	27.3452	27.168	27.3	15587.0
2018-04-03	ASHR	ETF	30.91	30.93	30.63	30.93	824500.0
2018-04-03	ASHS	ETF	35.16	35.32	35.07	35.25	5200.0
2018-04-03	ATMP	ETF	18.26	18.27	17.78	18.27	64900.0
2018-04-03	BAB	ETF	30.02	30.0397	29.97	30.01	410932.0
2018-04-03	BAL	ETF	53.76	54.13	53.68	54.0899	4585.0
2018-04-03	BAR	ETF	13.33	13.33	13.295	13.326	8640.0

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

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