PREVIEW / etf_daily / 2019-07-01

all etf daily files

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

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-01	SPY	ETF	296.68	296.92	294.33	295.66	78705600.0
2019-07-01	QQQ	ETF	190.3	190.5699	188.38	189.26	31193393.0
2019-07-01	IWM	ETF	157.54	158.03	155.22	156.1	22850500.0
2019-07-01	DIA	ETF	268.45	268.75	266.0	266.97	3970200.0
2019-07-01	GLD	ETF	131.56	131.76	130.55	130.62	13317700.0
2019-07-01	TLT	ETF	132.57	132.75	131.59	132.24	14131200.0
2019-07-01	AAAU	ETF	13.8	13.96	13.75	13.81	26300.0
2019-07-01	AADR	ETF	50.12	50.23	49.76	49.88	18000.0
2019-07-01	AAXJ	ETF	71.05	71.22	70.48	70.74	825700.0
2019-07-01	ACES	ETF	30.18	33.47	29.83	29.877	4400.0
2019-07-01	ACSI	ETF	33.9406	33.9451	33.74	33.74	1255.0
2019-07-01	ACTX	ETF	28.3203	33.6303	28.3203	28.9103	485.0
2019-07-01	ACWF	ETF	29.59	29.59	29.37	29.4855	8008.0
2019-07-01	ACWI	ETF	74.5	74.64	74.04	74.29	2812100.0
2019-07-01	ACWV	ETF	92.64	92.72	91.96	92.31	216800.0
2019-07-01	ACWX	ETF	47.3	47.3367	46.96	47.095	1774104.0
2019-07-01	ADRE	ETF	40.79	41.0	40.631	40.69	9776.0
2019-07-01	AFIF	ETF	9.8769	9.88	9.85	9.88	24454.0
2019-07-01	AFK	ETF	22.11	22.2243	22.1	22.11	4156.0
2019-07-01	AFTY	ETF	17.99	18.02	17.89	17.936	5000.0
2019-07-01	AGG	ETF	111.25	111.27	111.01	111.18	4186800.0
2019-07-01	AGGY	ETF	51.35	51.38	51.25	51.307	131100.0
2019-07-01	AGNG	ETF	21.62	21.68	21.5	21.523	13800.0
2019-07-01	AGQ	ETF	24.34	24.6	24.04	24.07	289400.0
2019-07-01	AGZ	ETF	115.07	115.07	114.84	114.93	12493.0
2019-07-01	AGZD	ETF	23.825	23.85	23.795	23.84	14000.0
2019-07-01	AIA	ETF	62.26	62.495	61.805	62.12	39603.0
2019-07-01	AIEQ	ETF	26.52	26.701	26.46	26.53	34300.0
2019-07-01	AIQ	ETF	16.62	16.62	16.42	16.42	7706.0
2019-07-01	AIRR	ETF	26.7	26.849	26.31	26.49	26800.0
2019-07-01	AIVI	ETF	41.54	41.54	41.22	41.3	5800.0
2019-07-01	ALTY	ETF	15.0	15.05	14.933	14.98	13200.0
2019-07-01	AMJ	ETF	25.3	25.31	24.94	24.94	1047526.0
2019-07-01	AMLP	ETF	49.5	49.8	49.35	49.35	2155100.0
2019-07-01	AMOM	ETF	25.961	25.961	25.961	25.961	100.0
2019-07-01	AMUB	ETF	15.7981	15.7981	15.7981	15.7981	0.0
2019-07-01	AMZA	ETF	56.2	56.5	55.7	55.9	68610.0
2019-07-01	ANGL	ETF	29.27	29.36	29.13	29.13	722000.0
2019-07-01	AOA	ETF	55.52	55.75	55.3	55.45	137900.0
2019-07-01	AOK	ETF	35.44	35.55	35.4	35.45	56076.0
2019-07-01	AOM	ETF	39.14	39.24	39.055	39.23	169564.0
2019-07-01	AOR	ETF	46.28	46.38	46.0508	46.2	91770.0
2019-07-01	ARCM	ETF	100.31	100.31	100.31	100.31	100.0
2019-07-01	ARGT	ETF	32.71	32.93	32.33	32.38	77000.0
2019-07-01	ARKF	ETF	23.03	23.11	22.829	22.874	25400.0
2019-07-01	ARKG	ETF	35.07	35.18	34.39	34.487	161700.0
2019-07-01	ARKK	ETF	48.76	48.84	47.82	47.92	412100.0
2019-07-01	ARKQ	ETF	34.35	34.54	33.701	33.86	26200.0
2019-07-01	ARKW	ETF	53.06	53.15	52.37	52.48	133200.0
2019-07-01	ASEA	ETF	16.98	17.07	16.52	16.77	6500.0

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

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