PREVIEW / etf_daily / 2019-07-03

all etf daily files

  file:    by_date/etf_daily/2019/2019-07-03.parquet
  size:    69 KB
  rows:    1,804

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-03	SPY	ETF	297.18	298.82	297.02	298.8	40898900.0
2019-07-03	QQQ	ETF	190.45	191.44	190.29	191.44	15792067.0
2019-07-03	IWM	ETF	155.6	156.34	155.17	156.26	9115100.0
2019-07-03	DIA	ETF	268.34	269.6	268.28	269.56	1262900.0
2019-07-03	GLD	ETF	133.61	134.1	133.23	133.63	6351500.0
2019-07-03	TLT	ETF	133.52	134.29	133.51	134.21	5380300.0
2019-07-03	AAAU	ETF	14.14	14.19	14.12	14.14	31600.0
2019-07-03	AADR	ETF	50.1	50.33	50.1	50.33	5300.0
2019-07-03	AAXJ	ETF	70.4	70.45	70.24	70.45	238900.0
2019-07-03	ACES	ETF	30.225	30.303	30.188	30.188	4000.0
2019-07-03	ACSI	ETF	33.9869	34.3099	33.9869	34.2437	1543.0
2019-07-03	ACTX	ETF	30.0903	33.0403	28.9103	33.0403	274.0
2019-07-03	ACWF	ETF	29.57	29.6579	29.57	29.6579	7286.0
2019-07-03	ACWI	ETF	74.66	74.94	74.58	74.94	863400.0
2019-07-03	ACWV	ETF	93.14	93.68	92.93	93.68	117000.0
2019-07-03	ACWX	ETF	47.26	47.375	47.23	47.36	719623.0
2019-07-03	ADRE	ETF	40.53	40.53	40.38	40.53	4032.0
2019-07-03	AFIF	ETF	10.14	10.14	9.89	9.9002	182191.0
2019-07-03	AFK	ETF	21.9427	21.985	21.9345	21.96	1748.0
2019-07-03	AFTY	ETF	17.83	17.83	17.722	17.775	5400.0
2019-07-03	AGG	ETF	111.44	111.6	111.43	111.56	1324800.0
2019-07-03	AGGY	ETF	51.47	51.54	51.46	51.53	84500.0
2019-07-03	AGNG	ETF	21.69	21.787	21.69	21.738	2700.0
2019-07-03	AGQ	ETF	24.65	24.7	24.49	24.62	109900.0
2019-07-03	AGZ	ETF	115.21	115.2499	115.1507	115.16	16761.0
2019-07-03	AGZD	ETF	23.85	23.88	23.85	23.87	4200.0
2019-07-03	AIA	ETF	61.37	61.61	61.305	61.61	23169.0
2019-07-03	AIEQ	ETF	26.6	27.04	26.6	26.802	53200.0
2019-07-03	AIQ	ETF	16.52	16.6437	16.52	16.59	5327.0
2019-07-03	AIRR	ETF	26.47	26.47	26.3	26.375	55300.0
2019-07-03	AIVI	ETF	41.71	41.75	41.64	41.72	2200.0
2019-07-03	ALTY	ETF	15.05	15.05	14.898	14.98	5400.0
2019-07-03	AMJ	ETF	25.2	25.435	25.09	25.35	457968.0
2019-07-03	AMLP	ETF	49.55	50.1	49.4	49.9	1647460.0
2019-07-03	AMOM	ETF	26.31	26.368	26.31	26.368	100.0
2019-07-03	AMUB	ETF	15.9548	15.9548	15.9548	15.9548	0.0
2019-07-03	AMZA	ETF	56.1	56.8	55.9	56.3	34600.0
2019-07-03	ANGL	ETF	29.25	29.35	29.23	29.34	204600.0
2019-07-03	AOA	ETF	55.15	55.35	55.1	55.35	28700.0
2019-07-03	AOK	ETF	35.39	35.4453	35.34	35.4205	31180.0
2019-07-03	AOM	ETF	38.99	39.08	38.8774	39.07	82903.0
2019-07-03	AOR	ETF	46.0	46.11	45.9055	46.11	63122.0
2019-07-03	ARCM	ETF	100.16	100.16	100.16	100.16	100.0
2019-07-03	ARGT	ETF	32.57	32.84	32.57	32.84	115100.0
2019-07-03	ARKF	ETF	22.9	22.99	22.863	22.989	6800.0
2019-07-03	ARKG	ETF	34.25	34.66	34.1	34.623	112400.0
2019-07-03	ARKK	ETF	48.05	48.06	47.636	48.06	149200.0
2019-07-03	ARKQ	ETF	33.67	33.67	33.33	33.5	25000.0
2019-07-03	ARKW	ETF	52.88	53.0	52.7	52.85	29800.0
2019-07-03	ASEA	ETF	16.73	16.8	16.66	16.72	1000.0

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

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