PREVIEW / etf_daily / 2019-07-16

all etf daily files

  file:    by_date/etf_daily/2019/2019-07-16.parquet
  size:    70 KB
  rows:    1,825

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-07-16	SPY	ETF	300.65	300.88	299.44	299.78	36650100.0
2019-07-16	QQQ	ETF	193.86	194.09	192.56	193.15	20190891.0
2019-07-16	IWM	ETF	155.13	156.2	154.67	155.24	15152700.0
2019-07-16	DIA	ETF	273.62	273.99	272.9	273.42	1780400.0
2019-07-16	GLD	ETF	133.18	133.3	132.13	132.4	7966000.0
2019-07-16	TLT	ETF	130.17	130.6	129.96	130.58	6172700.0
2019-07-16	AAAU	ETF	14.1	14.1	14.0	14.01	16400.0
2019-07-16	AADR	ETF	51.18	51.31	51.14	51.17	67100.0
2019-07-16	AAXJ	ETF	69.84	70.04	69.67	69.67	385000.0
2019-07-16	ACES	ETF	30.48	30.523	30.413	30.45	22200.0
2019-07-16	ACIO	ETF	25.035	25.13	25.035	25.124	167100.0
2019-07-16	ACSI	ETF	34.6441	34.6441	34.6042	34.6042	1081.0
2019-07-16	ACTX	ETF	27.683	27.683	24.1902	24.1902	1179.0
2019-07-16	ACWF	ETF	29.69	29.7399	29.63	29.6627	8397.0
2019-07-16	ACWI	ETF	74.86	74.93	74.58	74.63	1942500.0
2019-07-16	ACWV	ETF	93.47	93.5	93.12	93.2	504100.0
2019-07-16	ACWX	ETF	46.88	46.96	46.76	46.78	604769.0
2019-07-16	ADRE	ETF	40.77	40.8	40.5012	40.62	1605.0
2019-07-16	AFIF	ETF	9.88	9.8838	9.85	9.87	6185.0
2019-07-16	AFK	ETF	22.0062	22.0062	21.9	21.9	6915.0
2019-07-16	AFTY	ETF	17.45	17.45	17.32	17.333	7600.0
2019-07-16	AGG	ETF	110.75	110.83	110.64	110.83	2149100.0
2019-07-16	AGGY	ETF	51.09	51.14	51.074	51.14	96000.0
2019-07-16	AGNG	ETF	21.44	21.44	21.192	21.192	1300.0
2019-07-16	AGQ	ETF	25.17	25.86	25.17	25.31	633700.0
2019-07-16	AGZ	ETF	114.63	114.69	114.61	114.68	23288.0
2019-07-16	AGZD	ETF	23.93	23.935	23.905	23.92	14800.0
2019-07-16	AIA	ETF	61.35	61.39	61.08	61.08	29965.0
2019-07-16	AIEQ	ETF	26.93	27.042	26.84	26.86	19500.0
2019-07-16	AIQ	ETF	16.95	16.95	16.72	16.72	14512.0
2019-07-16	AIRR	ETF	26.15	26.33	26.15	26.22	1900.0
2019-07-16	AIVI	ETF	40.99	41.0	40.88	40.88	14600.0
2019-07-16	ALTY	ETF	15.063	15.12	15.05	15.05	6300.0
2019-07-16	AMJ	ETF	25.78	25.78	25.62	25.62	573036.0
2019-07-16	AMLP	ETF	50.6	50.65	50.35	50.55	1846960.0
2019-07-16	AMOM	ETF	26.57	26.59	26.51	26.542	2900.0
2019-07-16	AMUB	ETF	16.1981	16.1981	16.1981	16.1981	0.0
2019-07-16	AMZA	ETF	57.8	57.8	57.4	57.7	55110.0
2019-07-16	ANGL	ETF	29.24	29.26	29.16	29.26	222300.0
2019-07-16	AOA	ETF	55.14	55.21	55.0	55.08	52700.0
2019-07-16	AOK	ETF	35.3	35.3	35.21	35.25	98545.0
2019-07-16	AOM	ETF	38.87	38.88	38.79	38.79	174664.0
2019-07-16	AOR	ETF	45.84	45.9052	45.77	45.84	114656.0
2019-07-16	ARGT	ETF	33.16	33.37	32.94	32.99	90700.0
2019-07-16	ARKF	ETF	23.37	23.37	23.17	23.18	18100.0
2019-07-16	ARKG	ETF	33.58	33.609	33.16	33.51	91100.0
2019-07-16	ARKK	ETF	48.59	48.59	48.051	48.37	114900.0
2019-07-16	ARKQ	ETF	34.05	34.2	33.93	34.168	5100.0
2019-07-16	ARKW	ETF	54.58	54.58	53.88	54.02	28100.0
2019-07-16	ASEA	ETF	16.73	16.73	16.66	16.66	400.0

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

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