PREVIEW / etf_daily / 2018-10-22

all etf daily files

  file:    by_date/etf_daily/2018/2018-10-22.parquet
  size:    63 KB
  rows:    1,637

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-10-22	SPY	ETF	277.0	277.36	274.41	275.01	82415800.0
2018-10-22	QQQ	ETF	174.06	175.2485	172.59	173.91	52909281.0
2018-10-22	IWM	ETF	153.92	154.45	152.52	153.03	28218300.0
2018-10-22	DIA	ETF	255.07	255.44	252.2	253.04	4662600.0
2018-10-22	GLD	ETF	115.57	115.78	115.43	115.71	5200500.0
2018-10-22	TLT	ETF	113.95	114.08	113.53	113.56	3244200.0
2018-10-22	AAAU	ETF	12.21	12.22	12.21	12.22	501900.0
2018-10-22	AADR	ETF	49.06	49.06	48.62	48.76	9600.0
2018-10-22	AAXJ	ETF	65.01	65.11	64.51	64.73	749400.0
2018-10-22	ACES	ETF	23.97	24.27	23.97	24.27	6900.0
2018-10-22	ACSI	ETF	32.912	32.912	32.912	32.912	2184.0
2018-10-22	ACTX	ETF	141.6013	142.1913	107.971	108.561	4410.0
2018-10-22	ACWF	ETF	28.67	28.67	28.46	28.573	29631.0
2018-10-22	ACWI	ETF	70.27	70.36	69.7	69.89	2020000.0
2018-10-22	ACWV	ETF	85.2	85.33	84.73	84.82	51400.0
2018-10-22	ACWX	ETF	44.82	44.87	44.46	44.6	561766.0
2018-10-22	ADRE	ETF	38.73	38.7359	38.408	38.47	6005.0
2018-10-22	AFIF	ETF	10.07	10.08	10.05	10.08	61864.0
2018-10-22	AFK	ETF	20.87	20.93	20.7501	20.79	2799.0
2018-10-22	AFTY	ETF	14.94	14.94	14.816	14.89	17700.0
2018-10-22	AGG	ETF	104.47	104.52	104.34	104.35	2807300.0
2018-10-22	AGGY	ETF	47.74	47.74	47.655	47.67	25300.0
2018-10-22	AGNG	ETF	20.86	20.86	20.4	20.532	1400.0
2018-10-22	AGQ	ETF	23.8	23.83	23.62	23.75	57900.0
2018-10-22	AGZ	ETF	110.17	110.2599	110.1248	110.201	6324.0
2018-10-22	AGZD	ETF	23.885	23.965	23.885	23.945	10800.0
2018-10-22	AIA	ETF	57.58	57.81	57.2	57.44	56300.0
2018-10-22	AIEQ	ETF	27.41	27.49	27.16	27.2	109400.0
2018-10-22	AIQ	ETF	14.41	14.41	14.22	14.41	19722.0
2018-10-22	AIRR	ETF	25.56	25.72	25.495	25.5	17100.0
2018-10-22	AIVI	ETF	40.4	40.42	40.26	40.4	13200.0
2018-10-22	ALTY	ETF	14.8	14.8	14.57	14.585	4300.0
2018-10-22	AMJ	ETF	27.23	27.23	26.76	26.89	974227.0
2018-10-22	AMLP	ETF	52.85	52.9	52.05	52.25	2657600.0
2018-10-22	AMZA	ETF	71.7	72.1	70.0	70.5	110580.0
2018-10-22	ANGL	ETF	28.62	28.67	28.57	28.59	183700.0
2018-10-22	AOA	ETF	52.03	52.05	51.68	51.72	48100.0
2018-10-22	AOK	ETF	33.31	33.45	33.22	33.22	110421.0
2018-10-22	AOM	ETF	36.68	36.7077	36.53	36.53	120542.0
2018-10-22	AOR	ETF	43.27	43.27	43.07	43.07	76651.0
2018-10-22	ARGT	ETF	24.87	24.99	24.61	24.77	46200.0
2018-10-22	ARKG	ETF	28.85	28.886	28.04	28.28	72600.0
2018-10-22	ARKK	ETF	41.62	41.839	40.83	41.44	216000.0
2018-10-22	ARKQ	ETF	32.3	32.35	31.9	32.11	14000.0
2018-10-22	ARKW	ETF	51.47	51.9	50.89	51.7	111200.0
2018-10-22	ARVR	ETF	19.71	19.71	19.71	19.71	109.0
2018-10-22	ASEA	ETF	15.4	15.4	15.25	15.34	1500.0
2018-10-22	ASET	ETF	27.14	27.14	27.14	27.14	161.0
2018-10-22	ASHR	ETF	23.91	23.96	23.76	23.92	4474200.0
2018-10-22	ASHS	ETF	22.7	22.89	22.7	22.81	28900.0

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

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