PREVIEW / etf_daily / 2019-09-16

all etf daily files

  file:    by_date/etf_daily/2019/2019-09-16.parquet
  size:    69 KB
  rows:    1,809

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
2019-09-16	SPY	ETF	299.84	301.14	299.45	300.16	58191200.0
2019-09-16	QQQ	ETF	191.3	192.08	191.11	191.68	20318987.0
2019-09-16	IWM	ETF	156.97	158.75	156.7	157.9	23242600.0
2019-09-16	DIA	ETF	271.6	272.21	270.8	271.17	4077500.0
2019-09-16	GLD	ETF	141.6	142.05	141.02	141.32	8094600.0
2019-09-16	TLT	ETF	137.88	138.57	137.25	138.28	10971600.0
2019-09-16	AAAU	ETF	14.98	15.03	14.94	14.97	81500.0
2019-09-16	AADR	ETF	48.72	48.82	48.54	48.54	4500.0
2019-09-16	AAXJ	ETF	68.16	68.35	67.95	68.11	980900.0
2019-09-16	ACES	ETF	31.08	31.237	31.08	31.18	7200.0
2019-09-16	ACIO	ETF	25.179	25.179	25.146	25.156	2800.0
2019-09-16	ACSI	ETF	34.45	34.53	34.44	34.4851	1348.0
2019-09-16	ACTX	ETF	22.4202	22.4202	19.4702	19.4702	332.0
2019-09-16	ACWF	ETF	29.414	29.4146	29.3564	29.3881	3008.0
2019-09-16	ACWI	ETF	74.31	74.46	74.22	74.35	1620300.0
2019-09-16	ACWV	ETF	93.79	93.86	93.54	93.69	141700.0
2019-09-16	ACWX	ETF	46.52	46.56	46.4	46.45	809877.0
2019-09-16	ADRE	ETF	39.58	39.6	39.47	39.47	3076.0
2019-09-16	AFIF	ETF	9.88	9.88	9.784	9.81	5679.0
2019-09-16	AFK	ETF	20.93	21.0	20.8768	20.94	4360.0
2019-09-16	AFTY	ETF	17.35	17.351	17.26	17.26	7200.0
2019-09-16	AGG	ETF	112.05	112.15	111.89	112.05	2923500.0
2019-09-16	AGGY	ETF	51.79	51.86	51.75	51.85	130100.0
2019-09-16	AGNG	ETF	21.18	21.311	21.18	21.291	400.0
2019-09-16	AGQ	ETF	32.65	33.16	32.3	32.77	346300.0
2019-09-16	AGZ	ETF	115.59	115.76	115.588	115.68	30756.0
2019-09-16	AGZD	ETF	23.94	23.94	23.925	23.935	9000.0
2019-09-16	AIA	ETF	59.92	60.0231	59.7839	59.82	10252.0
2019-09-16	AIEQ	ETF	26.37	26.52	26.268	26.46	30500.0
2019-09-16	AIQ	ETF	16.31	16.39	16.3	16.39	7802.0
2019-09-16	AIRR	ETF	27.18	27.444	27.18	27.36	6500.0
2019-09-16	AIVI	ETF	41.35	41.38	41.28	41.28	5800.0
2019-09-16	ALTY	ETF	14.91	14.92	14.853	14.91	5600.0
2019-09-16	AMJ	ETF	24.19	24.43	23.97	23.99	1725181.0
2019-09-16	AMLP	ETF	47.8	48.1	47.2	47.2	5989080.0
2019-09-16	AMOM	ETF	25.95	25.95	25.877	25.877	300.0
2019-09-16	AMUB	ETF	15.1217	15.1217	15.1217	15.1217	0.0
2019-09-16	AMZA	ETF	52.6	52.8	51.4	51.5	101800.0
2019-09-16	ANGL	ETF	29.43	29.58	29.42	29.53	356200.0
2019-09-16	AOA	ETF	55.16	55.23	55.07	55.17	32900.0
2019-09-16	AOK	ETF	35.52	35.54	35.47	35.54	100532.0
2019-09-16	AOM	ETF	39.14	39.21	39.123	39.2	158878.0
2019-09-16	AOR	ETF	46.02	46.14	46.02	46.11	79874.0
2019-09-16	ARGT	ETF	22.6	22.97	22.56	22.92	16200.0
2019-09-16	ARKF	ETF	21.83	22.02	21.83	21.968	7500.0
2019-09-16	ARKG	ETF	31.82	32.2	31.73	32.12	140800.0
2019-09-16	ARKK	ETF	44.81	45.49	44.8	45.4	176600.0
2019-09-16	ARKQ	ETF	32.75	33.29	32.68	33.07	12700.0
2019-09-16	ARKW	ETF	50.78	51.25	50.6	51.12	43100.0
2019-09-16	ASEA	ETF	15.89	16.0	15.89	16.0	700.0

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

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