PREVIEW / etf_daily / 2019-01-02

all etf daily files

  file:    by_date/etf_daily/2019/2019-01-02.parquet
  size:    67 KB
  rows:    1,743

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-01-02	SPY	ETF	245.98	251.21	245.95	250.18	126925200.0
2019-01-02	QQQ	ETF	150.99	155.75	150.88	154.88	58576672.0
2019-01-02	IWM	ETF	132.17	135.17	131.54	134.66	27295100.0
2019-01-02	DIA	ETF	229.27	234.0	229.14	233.36	5319500.0
2019-01-02	GLD	ETF	121.35	121.75	120.88	121.33	12776200.0
2019-01-02	TLT	ETF	121.66	122.16	121.34	122.15	19841500.0
2019-01-02	AAAU	ETF	12.87	13.11	12.8	13.05	46500.0
2019-01-02	AADR	ETF	39.59	40.51	39.59	40.33	21100.0
2019-01-02	AAXJ	ETF	62.58	63.2	62.41	63.09	865600.0
2019-01-02	ACES	ETF	22.84	22.92	22.699	22.789	7700.0
2019-01-02	ACSI	ETF	28.6254	29.0999	28.6254	29.028	1106.0
2019-01-02	ACTX	ETF	46.0204	56.0505	46.0204	50.7405	425.0
2019-01-02	ACWF	ETF	25.849	26.0	25.76	25.96	97269.0
2019-01-02	ACWI	ETF	63.28	64.3	63.17	64.14	6642200.0
2019-01-02	ACWV	ETF	80.51	80.9	80.29	80.81	224600.0
2019-01-02	ACWX	ETF	41.32	41.86	41.3	41.81	5325599.0
2019-01-02	ADRE	ETF	35.6826	36.62	35.6826	36.51	12769.0
2019-01-02	AFIF	ETF	9.91	9.92	9.85	9.899	42940.0
2019-01-02	AFK	ETF	19.43	19.62	19.28	19.57	9823.0
2019-01-02	AFTY	ETF	13.005	13.032	13.003	13.02	5000.0
2019-01-02	AGG	ETF	106.55	106.61	106.47	106.57	11200700.0
2019-01-02	AGGY	ETF	48.22	48.31	48.19	48.26	65000.0
2019-01-02	AGNG	ETF	18.64	18.775	18.64	18.775	600.0
2019-01-02	AGQ	ETF	26.12	26.89	26.12	26.38	401400.0
2019-01-02	AGZ	ETF	112.2413	112.31	112.15	112.31	27079.0
2019-01-02	AGZD	ETF	23.605	23.685	23.545	23.675	80200.0
2019-01-02	AIA	ETF	54.36	54.85	54.35	54.82	62491.0
2019-01-02	AIEQ	ETF	21.5	22.04	21.48	21.93	30000.0
2019-01-02	AIQ	ETF	12.69	13.09	12.69	13.01	8326.0
2019-01-02	AIRR	ETF	21.36	21.89	21.36	21.82	29100.0
2019-01-02	AIVI	ETF	37.38	37.69	37.38	37.68	6200.0
2019-01-02	ALTY	ETF	13.08	13.42	13.08	13.41	1100.0
2019-01-02	AMJ	ETF	21.88	22.84	21.88	22.57	5177222.0
2019-01-02	AMLP	ETF	43.2	44.8	42.95	44.45	5113460.0
2019-01-02	AMUB	ETF	14.18	14.18	14.18	14.18	0.0
2019-01-02	AMZA	ETF	50.1	52.6	49.8	51.8	99410.0
2019-01-02	ANGL	ETF	26.61	26.75	26.57	26.74	582600.0
2019-01-02	AOA	ETF	48.05	48.65	48.02	48.56	308500.0
2019-01-02	AOK	ETF	32.64	32.79	32.6214	32.79	310090.0
2019-01-02	AOM	ETF	35.57	35.72	35.445	35.71	616494.0
2019-01-02	AOR	ETF	41.0	41.31	40.926	41.3	878615.0
2019-01-02	ARCM	ETF	99.65	99.695	99.65	99.695	5000.0
2019-01-02	ARGT	ETF	23.31	23.82	23.1	23.57	91900.0
2019-01-02	ARKG	ETF	23.69	24.52	23.452	24.52	107800.0
2019-01-02	ARKK	ETF	36.27	37.573	36.23	37.42	232200.0
2019-01-02	ARKQ	ETF	29.09	29.75	28.92	29.563	20700.0
2019-01-02	ARKW	ETF	41.42	42.66	41.251	42.46	215200.0
2019-01-02	ASEA	ETF	15.12	15.47	15.01	15.34	2200.0
2019-01-02	ASET	ETF	25.24	25.395	25.19	25.38	1017.0
2019-01-02	ASHR	ETF	21.66	21.78	21.62	21.76	1200200.0

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

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