PREVIEW / etf_daily / 2018-10-04

all etf daily files

  file:    by_date/etf_daily/2018/2018-10-04.parquet
  size:    64 KB
  rows:    1,640

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-10-04	SPY	ETF	291.18	291.24	287.66	289.44	111545900.0
2018-10-04	QQQ	ETF	185.22	185.32	181.06	182.38	80557283.0
2018-10-04	IWM	ETF	165.44	165.65	163.13	163.64	29463000.0
2018-10-04	DIA	ETF	267.69	267.71	264.58	266.25	8720900.0
2018-10-04	GLD	ETF	113.83	114.19	113.26	113.48	6616200.0
2018-10-04	TLT	ETF	114.13	114.39	113.71	114.02	16207400.0
2018-10-04	AAAU	ETF	12.04	12.04	11.98	11.98	7300.0
2018-10-04	AADR	ETF	53.17	53.17	51.56	51.75	13400.0
2018-10-04	AAXJ	ETF	67.8	67.99	66.72	66.95	911700.0
2018-10-04	ACES	ETF	25.316	25.316	25.0	25.0	7400.0
2018-10-04	ACSI	ETF	33.7051	33.7051	33.7	33.7	1850.0
2018-10-04	ACTX	ETF	100.8909	102.6609	83.1908	87.3208	5718.0
2018-10-04	ACWF	ETF	30.49	30.49	30.0536	30.12	6975.0
2018-10-04	ACWI	ETF	73.83	73.84	72.96	73.38	2369900.0
2018-10-04	ACWV	ETF	86.87	86.87	86.2	86.59	68400.0
2018-10-04	ACWX	ETF	47.01	47.02	46.45	46.67	666256.0
2018-10-04	ADRE	ETF	40.19	40.19	39.21	39.39	8348.0
2018-10-04	AFIF	ETF	10.0521	10.0573	9.98	10.0501	15854.0
2018-10-04	AFK	ETF	21.17	21.2	21.0	21.0	21277.0
2018-10-04	AFTY	ETF	14.875	14.875	14.65	14.65	9300.0
2018-10-04	AGG	ETF	104.65	104.72	104.47	104.56	5268200.0
2018-10-04	AGGY	ETF	47.97	48.005	47.79	47.83	270500.0
2018-10-04	AGNG	ETF	22.25	22.25	21.6	21.8	3200.0
2018-10-04	AGQ	ETF	24.44	24.5	23.76	23.94	97000.0
2018-10-04	AGZ	ETF	110.08	110.18	110.05	110.16	68364.0
2018-10-04	AGZD	ETF	23.945	24.01	23.94	23.99	5800.0
2018-10-04	AIA	ETF	60.05	60.07	59.0	59.3	37228.0
2018-10-04	AIEQ	ETF	29.37	29.4	29.02	29.19	77700.0
2018-10-04	AIQ	ETF	15.72	15.72	15.3165	15.3991	8286.0
2018-10-04	AIRR	ETF	27.71	27.71	27.41	27.47	10500.0
2018-10-04	AIVI	ETF	41.73	41.73	41.41	41.54	5100.0
2018-10-04	ALTY	ETF	14.73	14.931	14.73	14.81	17900.0
2018-10-04	AMJ	ETF	28.07	28.115	27.87	27.91	1635828.0
2018-10-04	AMLP	ETF	54.2	54.5	54.05	54.2	2725040.0
2018-10-04	AMZA	ETF	76.0	76.24	75.5	75.8	54160.0
2018-10-04	ANGL	ETF	28.9	28.91	28.79	28.82	235900.0
2018-10-04	AOA	ETF	54.19	54.19	53.66	53.82	98000.0
2018-10-04	AOK	ETF	33.89	33.9399	33.75	33.79	27540.0
2018-10-04	AOM	ETF	37.48	37.48	37.2496	37.31	119530.0
2018-10-04	AOR	ETF	44.67	44.67	44.3482	44.5	57460.0
2018-10-04	ARGT	ETF	27.21	27.21	26.02	26.23	74400.0
2018-10-04	ARKG	ETF	31.96	31.96	30.556	30.76	258400.0
2018-10-04	ARKK	ETF	46.26	46.26	44.45	44.83	399700.0
2018-10-04	ARKQ	ETF	35.97	35.97	34.991	35.15	22500.0
2018-10-04	ARKW	ETF	57.0	57.01	55.4	55.8	188000.0
2018-10-04	ARVR	ETF	21.0	21.3799	20.83	20.83	1002.0
2018-10-04	ASEA	ETF	15.95	15.95	15.81	15.81	400.0
2018-10-04	ASET	ETF	27.53	27.53	27.38	27.38	2179.0
2018-10-04	ASHR	ETF	24.43	24.56	24.09	24.17	2829000.0
2018-10-04	ASHS	ETF	24.69	24.69	24.39	24.39	6600.0

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

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