PREVIEW / etf_daily / 2019-08-12

all etf daily files

  file:    by_date/etf_daily/2019/2019-08-12.parquet
  size:    70 KB
  rows:    1,840

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-08-12	SPY	ETF	289.96	291.61	287.02	288.07	65527600.0
2019-08-12	QQQ	ETF	185.34	185.9	183.5	184.35	24642870.0
2019-08-12	IWM	ETF	149.81	150.12	148.33	148.67	15963000.0
2019-08-12	DIA	ETF	261.42	262.17	258.56	259.4	3072700.0
2019-08-12	GLD	ETF	141.67	143.38	141.64	142.63	15264000.0
2019-08-12	TLT	ETF	141.72	143.43	141.51	142.97	14094300.0
2019-08-12	AAAU	ETF	14.99	15.15	14.99	15.11	74000.0
2019-08-12	AADR	ETF	49.99	49.99	49.52	49.53	2500.0
2019-08-12	AAXJ	ETF	63.62	63.78	63.43	63.49	1608800.0
2019-08-12	ACES	ETF	30.775	30.775	30.441	30.617	4300.0
2019-08-12	ACIO	ETF	24.235	24.235	24.07	24.188	2000.0
2019-08-12	ACSI	ETF	33.35	33.42	33.26	33.26	2014.0
2019-08-12	ACTX	ETF	18.4377	23.6002	18.2902	22.2727	430.0
2019-08-12	ACWF	ETF	27.986	27.989	27.8204	27.83	5187.0
2019-08-12	ACWI	ETF	71.61	71.74	71.03	71.17	2750800.0
2019-08-12	ACWV	ETF	92.64	92.82	92.02	92.15	215300.0
2019-08-12	ACWX	ETF	44.41	44.5	44.18	44.2	720304.0
2019-08-12	ADRE	ETF	37.03	37.12	37.01	37.01	5546.0
2019-08-12	AFIF	ETF	9.71	9.7203	9.69	9.72	382589.0
2019-08-12	AFK	ETF	20.09	20.09	19.9728	19.9974	2012.0
2019-08-12	AFTY	ETF	16.3	16.33	16.245	16.245	3900.0
2019-08-12	AGG	ETF	112.93	113.19	112.87	113.05	2474900.0
2019-08-12	AGGY	ETF	52.17	52.3	52.13	52.29	63000.0
2019-08-12	AGNG	ETF	21.49	21.64	21.26	21.415	14800.0
2019-08-12	AGQ	ETF	29.86	30.63	29.81	30.3	385200.0
2019-08-12	AGZ	ETF	116.41	116.6066	116.37	116.58	45666.0
2019-08-12	AGZD	ETF	23.86	23.87	23.805	23.85	8200.0
2019-08-12	AIA	ETF	55.75	55.9103	55.57	55.6	36464.0
2019-08-12	AIEQ	ETF	25.98	25.98	25.56	25.62	36200.0
2019-08-12	AIQ	ETF	15.95	15.95	15.8	15.8	4010.0
2019-08-12	AIRR	ETF	25.206	25.206	25.079	25.079	2700.0
2019-08-12	AIVI	ETF	39.3	39.3	39.08	39.14	3800.0
2019-08-12	ALTY	ETF	14.749	14.77	14.65	14.72	11600.0
2019-08-12	AMJ	ETF	23.44	23.44	23.21	23.295	946205.0
2019-08-12	AMLP	ETF	45.1	45.15	44.65	44.75	3041420.0
2019-08-12	AMOM	ETF	26.5	26.5	26.5	26.5	200.0
2019-08-12	AMUB	ETF	14.6595	14.6595	14.6595	14.6595	0.0
2019-08-12	AMZA	ETF	49.6	49.6	48.5	48.5	78450.0
2019-08-12	ANGL	ETF	28.82	28.88	28.7	28.75	844400.0
2019-08-12	AOA	ETF	53.5	53.51	53.2	53.3	27100.0
2019-08-12	AOK	ETF	35.22	35.29	35.2	35.2457	366860.0
2019-08-12	AOM	ETF	38.67	38.69	38.5844	38.64	143278.0
2019-08-12	AOR	ETF	45.08	45.21	44.911	45.0	83515.0
2019-08-12	ARCM	ETF	100.175	100.175	100.175	100.175	7500.0
2019-08-12	ARGT	ETF	26.61	26.8	23.71	25.21	1510000.0
2019-08-12	ARKF	ETF	21.36	21.36	21.084	21.137	15600.0
2019-08-12	ARKG	ETF	32.51	32.52	32.03	32.154	69300.0
2019-08-12	ARKK	ETF	44.95	45.014	44.21	44.334	264200.0
2019-08-12	ARKQ	ETF	30.5	30.627	30.29	30.31	10200.0
2019-08-12	ARKW	ETF	49.63	49.63	48.918	49.08	42400.0

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

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