PREVIEW / etf_daily / 2018-11-05

all etf daily files

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

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-05	SPY	ETF	272.44	274.01	271.35	273.39	65622500.0
2018-11-05	QQQ	ETF	169.61	169.66	167.08	168.96	39573533.0
2018-11-05	IWM	ETF	154.04	154.66	152.35	153.88	16940900.0
2018-11-05	DIA	ETF	252.84	254.93	252.5	254.48	2833700.0
2018-11-05	GLD	ETF	116.28	116.67	116.23	116.37	6291500.0
2018-11-05	TLT	ETF	112.48	112.71	112.35	112.44	4760200.0
2018-11-05	AAAU	ETF	12.28	12.32	12.28	12.31	2700.0
2018-11-05	AADR	ETF	47.32	47.51	46.93	47.4	22500.0
2018-11-05	AAXJ	ETF	65.31	65.65	65.15	65.57	1086600.0
2018-11-05	ACES	ETF	24.78	24.78	24.78	24.78	300.0
2018-11-05	ACSI	ETF	32.51	32.6741	32.51	32.6741	2566.0
2018-11-05	ACTX	ETF	82.3057	88.5008	81.4207	82.6007	1413.0
2018-11-05	ACWF	ETF	28.73	28.8	28.5601	28.65	6969.0
2018-11-05	ACWI	ETF	69.56	69.9	69.4	69.78	2073300.0
2018-11-05	ACWV	ETF	84.22	84.67	84.22	84.55	316800.0
2018-11-05	ACWX	ETF	44.82	44.93	44.68	44.83	1465064.0
2018-11-05	ADRE	ETF	38.49	38.5269	38.3	38.302	5099.0
2018-11-05	AFIF	ETF	9.33	10.08	9.33	10.05	12253.0
2018-11-05	AFK	ETF	20.69	21.05	20.69	20.94	11042.0
2018-11-05	AFTY	ETF	14.76	14.785	14.66	14.73	5800.0
2018-11-05	AGG	ETF	104.14	104.17	104.07	104.1	3412600.0
2018-11-05	AGGY	ETF	47.44	47.45	47.37	47.394	56600.0
2018-11-05	AGNG	ETF	20.18	20.18	20.18	20.18	1100.0
2018-11-05	AGQ	ETF	23.93	24.2	23.83	23.96	175600.0
2018-11-05	AGZ	ETF	110.03	110.12	110.03	110.04	7504.0
2018-11-05	AGZD	ETF	23.78	23.86	23.745	23.75	5600.0
2018-11-05	AIA	ETF	57.32	57.67	57.2	57.51	17244.0
2018-11-05	AIEQ	ETF	26.84	27.02	26.715	26.86	32700.0
2018-11-05	AIQ	ETF	13.9884	14.039	13.95	13.9907	1237.0
2018-11-05	AIRR	ETF	25.22	25.41	25.09	25.29	7900.0
2018-11-05	AIVI	ETF	40.13	40.28	40.08	40.18	5700.0
2018-11-05	ALTY	ETF	14.416	14.484	14.416	14.452	29800.0
2018-11-05	AMJ	ETF	25.43	25.9	25.35	25.74	1395272.0
2018-11-05	AMLP	ETF	49.45	50.4	49.2	50.25	2964220.0
2018-11-05	AMZA	ETF	64.0	65.0	63.6	64.8	137290.0
2018-11-05	ANGL	ETF	28.11	28.22	28.08	28.18	253800.0
2018-11-05	AOA	ETF	51.66	51.77	51.53	51.68	55900.0
2018-11-05	AOK	ETF	33.2	33.2421	33.134	33.22	65140.0
2018-11-05	AOM	ETF	36.53	36.63	36.4901	36.58	210648.0
2018-11-05	AOR	ETF	43.09	43.1662	42.9839	43.15	623308.0
2018-11-05	ARGT	ETF	27.05	27.17	26.89	27.01	38800.0
2018-11-05	ARKG	ETF	30.25	30.285	29.35	29.97	119800.0
2018-11-05	ARKK	ETF	45.52	45.52	44.12	44.82	246900.0
2018-11-05	ARKQ	ETF	34.04	34.205	33.509	33.73	47200.0
2018-11-05	ARKW	ETF	55.22	55.22	53.71	54.51	141400.0
2018-11-05	ARVR	ETF	19.09	19.09	19.09	19.09	132.0
2018-11-05	ASEA	ETF	15.77	15.91	15.53	15.91	111000.0
2018-11-05	ASET	ETF	26.78	26.78	26.76	26.7731	941.0
2018-11-05	ASHR	ETF	24.02	24.08	23.86	23.92	3716600.0
2018-11-05	ASHS	ETF	23.38	23.6	23.38	23.46	8800.0

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

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