PREVIEW / etf_daily / 2018-12-10

all etf daily files

  file:    by_date/etf_daily/2018/2018-12-10.parquet
  size:    66 KB
  rows:    1,725

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-10	SPY	ETF	263.37	265.16	258.62	264.07	151445900.0
2018-12-10	QQQ	ETF	161.11	163.78	159.41	163.07	73960758.0
2018-12-10	IWM	ETF	144.27	144.72	141.45	143.6	30776600.0
2018-12-10	DIA	ETF	243.94	245.49	239.25	244.71	6021000.0
2018-12-10	GLD	ETF	117.7	117.94	117.42	117.68	8117900.0
2018-12-10	TLT	ETF	118.87	119.28	118.44	118.9	8777700.0
2018-12-10	AAAU	ETF	12.44	12.47	12.42	12.44	663000.0
2018-12-10	AADR	ETF	42.9	42.9	42.27	42.65	19900.0
2018-12-10	AAXJ	ETF	64.33	64.58	63.49	64.38	1460700.0
2018-12-10	ACES	ETF	25.2	25.2	24.69	24.749	1800.0
2018-12-10	ACSI	ETF	31.43	31.4376	31.04	31.4342	3178.0
2018-12-10	ACTX	ETF	67.2606	67.2606	55.4605	58.4105	436.0
2018-12-10	ACWF	ETF	27.15	27.25	26.8299	27.2151	140965.0
2018-12-10	ACWI	ETF	66.96	67.23	65.91	66.94	7898900.0
2018-12-10	ACWV	ETF	84.73	85.0	83.65	84.79	834400.0
2018-12-10	ACWX	ETF	42.91	42.9863	42.31	42.78	5170327.0
2018-12-10	ADRE	ETF	36.97	37.1352	36.59	36.96	3424.0
2018-12-10	AFIF	ETF	9.9702	9.9999	9.96	9.98	16542.0
2018-12-10	AFK	ETF	19.86	20.21	19.7501	19.84	11539.0
2018-12-10	AFTY	ETF	14.02	14.068	13.9	14.049	5400.0
2018-12-10	AGG	ETF	105.55	105.63	105.43	105.55	6096000.0
2018-12-10	AGGY	ETF	47.85	47.92	47.79	47.89	41400.0
2018-12-10	AGNG	ETF	20.096	20.096	19.792	19.792	13300.0
2018-12-10	AGQ	ETF	23.39	23.64	23.28	23.35	61500.0
2018-12-10	AGZ	ETF	111.41	111.5	111.3699	111.4041	131329.0
2018-12-10	AGZD	ETF	23.75	23.75	23.7	23.745	25800.0
2018-12-10	AIA	ETF	56.14	56.4209	55.4931	56.27	58403.0
2018-12-10	AIEQ	ETF	25.18	25.382	24.858	25.28	72300.0
2018-12-10	AIQ	ETF	13.63	13.76	13.48	13.74	22948.0
2018-12-10	AIRR	ETF	23.01	23.125	22.69	22.98	74400.0
2018-12-10	AIVI	ETF	38.72	38.72	38.37	38.62	6900.0
2018-12-10	ALTY	ETF	14.14	14.238	14.079	14.176	6600.0
2018-12-10	AMJ	ETF	24.21	24.21	23.619	23.9	3229696.0
2018-12-10	AMLP	ETF	47.3	47.3	46.05	46.55	4835580.0
2018-12-10	AMUB	ETF	15.0214	15.0214	15.0214	15.0214	4.0
2018-12-10	AMZA	ETF	59.5	59.6	57.3	58.7	163370.0
2018-12-10	ANGL	ETF	27.2	27.33	27.19	27.3	222100.0
2018-12-10	AOA	ETF	50.16	50.24	49.5	50.14	229500.0
2018-12-10	AOK	ETF	33.05	33.0897	32.86	32.99	241965.0
2018-12-10	AOM	ETF	36.22	36.2899	36.0	36.26	712643.0
2018-12-10	AOR	ETF	42.22	42.3401	41.85	42.26	514961.0
2018-12-10	ARGT	ETF	25.19	25.47	24.84	25.03	33200.0
2018-12-10	ARKG	ETF	27.84	28.23	27.454	28.048	34700.0
2018-12-10	ARKK	ETF	41.95	42.7	41.46	42.54	230400.0
2018-12-10	ARKQ	ETF	31.52	32.05	31.35	31.94	51500.0
2018-12-10	ARKW	ETF	51.12	52.257	50.869	52.0	112600.0
2018-12-10	ARVR	ETF	16.02	17.0534	16.02	17.0534	415.0
2018-12-10	ASEA	ETF	15.55	15.77	15.38	15.58	22500.0
2018-12-10	ASET	ETF	26.84	26.92	26.81	26.81	10683.0
2018-12-10	ASHR	ETF	22.85	22.86	22.57	22.83	2662100.0

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

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