PREVIEW / etf_daily / 2018-11-20

all etf daily files

  file:    by_date/etf_daily/2018/2018-11-20.parquet
  size:    64 KB
  rows:    1,679

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-11-20	SPY	ETF	265.36	267.0	263.15	264.12	136021300.0
2018-11-20	QQQ	ETF	158.37	161.38	157.13	159.16	102652794.0
2018-11-20	IWM	ETF	147.25	148.43	145.59	145.99	25907000.0
2018-11-20	DIA	ETF	246.36	246.93	243.53	244.5	7341100.0
2018-11-20	GLD	ETF	115.94	115.95	115.37	115.67	9075100.0
2018-11-20	TLT	ETF	115.24	115.46	114.93	115.06	6332600.0
2018-11-20	AAAU	ETF	12.24	12.24	12.2	12.21	6900.0
2018-11-20	AADR	ETF	44.4	44.51	43.0	43.0	58300.0
2018-11-20	AAXJ	ETF	64.16	64.5	63.7	63.91	1362300.0
2018-11-20	ACES	ETF	24.03	24.03	23.897	24.02	2100.0
2018-11-20	ACSI	ETF	31.76	31.76	31.55	31.55	7366.0
2018-11-20	ACTX	ETF	69.6206	70.8006	64.9006	67.2606	796.0
2018-11-20	ACWF	ETF	27.75	27.75	27.55	27.6	14674.0
2018-11-20	ACWI	ETF	67.56	67.88	67.03	67.28	5946700.0
2018-11-20	ACWV	ETF	84.55	84.69	83.99	84.16	700800.0
2018-11-20	ACWX	ETF	43.54	43.6899	43.2	43.3	2183851.0
2018-11-20	ADRE	ETF	36.96	37.1389	36.59	36.62	18320.0
2018-11-20	AFIF	ETF	10.02	10.03	9.997	10.03	20562.0
2018-11-20	AFK	ETF	20.27	20.325	20.0757	20.1143	3899.0
2018-11-20	AFTY	ETF	14.175	14.175	14.023	14.1	3500.0
2018-11-20	AGG	ETF	104.67	104.72	104.61	104.61	3162700.0
2018-11-20	AGGY	ETF	47.39	47.4	47.36	47.36	273400.0
2018-11-20	AGNG	ETF	19.664	19.792	19.484	19.792	1600.0
2018-11-20	AGQ	ETF	23.11	23.11	22.55	22.83	84500.0
2018-11-20	AGZ	ETF	110.76	110.76	110.65	110.72	17807.0
2018-11-20	AGZD	ETF	23.725	23.74	23.69	23.74	334400.0
2018-11-20	AIA	ETF	55.45	55.62	54.99	55.26	118682.0
2018-11-20	AIEQ	ETF	25.25	25.54	24.94	25.17	81800.0
2018-11-20	AIQ	ETF	12.96	13.3	12.9262	13.1134	17108.0
2018-11-20	AIRR	ETF	24.66	24.748	24.27	24.3	17800.0
2018-11-20	AIVI	ETF	39.42	39.56	39.18	39.18	11800.0
2018-11-20	ALTY	ETF	14.42	14.42	14.33	14.355	2500.0
2018-11-20	AMJ	ETF	25.1	25.1	24.4436	24.71	2966365.0
2018-11-20	AMLP	ETF	47.9	48.2	46.55	46.95	4600740.0
2018-11-20	AMZA	ETF	61.5	61.7	59.0	59.7	193720.0
2018-11-20	ANGL	ETF	27.23	27.41	27.19	27.26	461200.0
2018-11-20	AOA	ETF	50.5	50.7	50.21	50.31	182500.0
2018-11-20	AOK	ETF	32.99	33.07	32.8826	32.92	106543.0
2018-11-20	AOM	ETF	36.23	36.28	36.08	36.1	245684.0
2018-11-20	AOR	ETF	42.43	42.4999	42.22	42.3	185959.0
2018-11-20	ARGT	ETF	25.51	25.51	24.74	24.8	25000.0
2018-11-20	ARKG	ETF	27.37	27.8	26.93	27.38	125700.0
2018-11-20	ARKK	ETF	40.17	41.524	39.89	40.82	506300.0
2018-11-20	ARKQ	ETF	31.29	31.898	31.0	31.56	23600.0
2018-11-20	ARKW	ETF	47.79	49.81	47.15	49.04	363800.0
2018-11-20	ARVR	ETF	16.9072	17.2347	16.9072	17.2347	1192.0
2018-11-20	ASEA	ETF	15.38	15.39	15.29	15.3	900.0
2018-11-20	ASET	ETF	26.67	26.67	26.67	26.67	676.0
2018-11-20	ASHR	ETF	23.41	23.45	23.18	23.25	3018300.0
2018-11-20	ASHS	ETF	24.0	24.0	23.81	23.89	17800.0

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

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