PREVIEW / etf_daily / 2018-12-07

all etf daily files

  file:    by_date/etf_daily/2018/2018-12-07.parquet
  size:    65 KB
  rows:    1,687

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
2018-12-07	SPY	ETF	269.46	271.22	262.63	263.57	161018900.0
2018-12-07	QQQ	ETF	166.13	167.12	160.86	161.38	80432176.0
2018-12-07	IWM	ETF	147.14	148.26	143.27	144.02	28525100.0
2018-12-07	DIA	ETF	249.66	251.41	243.29	244.31	5963700.0
2018-12-07	GLD	ETF	117.62	118.23	117.54	118.09	10402900.0
2018-12-07	TLT	ETF	117.81	118.53	117.52	118.41	8608400.0
2018-12-07	AAAU	ETF	12.45	12.5	12.45	12.5	5300.0
2018-12-07	AADR	ETF	44.0	44.13	43.1	43.15	8600.0
2018-12-07	AAXJ	ETF	65.79	66.21	64.65	64.83	2650600.0
2018-12-07	ACES	ETF	25.24	25.24	24.742	24.742	3200.0
2018-12-07	ACSI	ETF	32.2302	32.2302	31.4902	31.4902	5407.0
2018-12-07	ACTX	ETF	55.4605	67.8506	55.4605	59.5905	501.0
2018-12-07	ACWF	ETF	27.94	27.94	27.2814	27.2814	96489.0
2018-12-07	ACWI	ETF	68.33	68.76	66.95	67.14	9034900.0
2018-12-07	ACWV	ETF	85.8	85.94	84.6	84.86	207600.0
2018-12-07	ACWX	ETF	43.71	43.9	43.03	43.141	4459758.0
2018-12-07	ADRE	ETF	37.93	38.12	37.3665	37.39	3452.0
2018-12-07	AFIF	ETF	9.93	9.9999	9.93	9.985	51373.0
2018-12-07	AFK	ETF	20.47	20.5	20.0	20.1	5892.0
2018-12-07	AFTY	ETF	14.28	14.39	14.055	14.055	3900.0
2018-12-07	AGG	ETF	105.39	105.55	105.28	105.48	5440200.0
2018-12-07	AGGY	ETF	47.8	47.85	47.753	47.84	39400.0
2018-12-07	AGNG	ETF	20.017	20.017	20.0	20.0	300.0
2018-12-07	AGQ	ETF	23.41	23.81	23.41	23.75	81100.0
2018-12-07	AGZ	ETF	111.28	111.3999	111.21	111.39	13385.0
2018-12-07	AGZD	ETF	23.775	23.78	23.735	23.745	21600.0
2018-12-07	AIA	ETF	57.1	57.56	56.28	56.38	100394.0
2018-12-07	AIEQ	ETF	25.83	26.1	25.15	25.31	22100.0
2018-12-07	AIQ	ETF	13.95	14.0554	13.63	13.63	1449.0
2018-12-07	AIRR	ETF	23.79	23.813	23.03	23.03	15700.0
2018-12-07	AIVI	ETF	39.15	39.3	38.73	38.8	17100.0
2018-12-07	ALTY	ETF	14.38	14.39	14.24	14.24	2800.0
2018-12-07	AMJ	ETF	24.58	24.92	24.21	24.29	7744399.0
2018-12-07	AMLP	ETF	48.0	48.65	47.25	47.3	5383940.0
2018-12-07	AMZA	ETF	60.8	62.11	59.7	59.8	68860.0
2018-12-07	ANGL	ETF	27.34	27.5	27.21	27.21	357700.0
2018-12-07	AOA	ETF	50.91	51.15	50.14	50.28	229900.0
2018-12-07	AOK	ETF	33.24	33.2499	33.0001	33.08	143098.0
2018-12-07	AOM	ETF	36.5	36.5749	36.2275	36.29	606538.0
2018-12-07	AOR	ETF	42.68	42.8601	42.27	42.34	212699.0
2018-12-07	ARCM	ETF	99.825	99.825	99.825	99.825	900.0
2018-12-07	ARGT	ETF	25.83	25.97	25.19	25.3	26800.0
2018-12-07	ARKG	ETF	28.87	29.08	27.739	27.9	115000.0
2018-12-07	ARKK	ETF	43.59	43.852	41.92	42.1	188800.0
2018-12-07	ARKQ	ETF	32.77	33.04	31.775	31.86	57700.0
2018-12-07	ARKW	ETF	53.36	53.87	51.136	51.45	127500.0
2018-12-07	ARVR	ETF	16.9756	16.9756	16.955	16.955	358.0
2018-12-07	ASEA	ETF	16.07	16.07	15.7	15.89	11100.0
2018-12-07	ASET	ETF	27.1	27.1	26.83	26.83	7704.0
2018-12-07	ASHR	ETF	23.27	23.29	22.85	22.99	1978200.0

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

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