PREVIEW / etf_daily / 2019-03-26

all etf daily files

  file:    by_date/etf_daily/2019/2019-03-26.parquet
  size:    68 KB
  rows:    1,754

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
2019-03-26	SPY	ETF	280.99	282.18	279.56	281.12	68125900.0
2019-03-26	QQQ	ETF	179.58	180.69	178.14	179.05	33248121.0
2019-03-26	IWM	ETF	151.47	152.82	150.79	151.86	21308600.0
2019-03-26	DIA	ETF	257.05	257.83	255.3	256.46	3278700.0
2019-03-26	GLD	ETF	124.48	124.51	124.07	124.3	5056100.0
2019-03-26	TLT	ETF	124.7	125.29	124.62	124.97	7502000.0
2019-03-26	AAAU	ETF	13.17	13.17	13.14	13.15	15200.0
2019-03-26	AADR	ETF	45.44	45.54	45.31	45.45	9000.0
2019-03-26	AAXJ	ETF	69.85	70.06	69.53	69.8	1011700.0
2019-03-26	ACES	ETF	26.949	27.04	26.775	26.87	6600.0
2019-03-26	ACSI	ETF	32.4499	32.4828	32.3407	32.3407	868.0
2019-03-26	ACTX	ETF	49.5604	58.4105	49.5604	54.2805	923.0
2019-03-26	ACWF	ETF	28.84	28.9099	28.68	28.84	6289.0
2019-03-26	ACWI	ETF	71.79	72.07	71.51	71.82	2033200.0
2019-03-26	ACWV	ETF	89.12	89.36	88.96	89.2	182600.0
2019-03-26	ACWX	ETF	46.21	46.29	46.01	46.12	1307249.0
2019-03-26	ADRE	ETF	40.84	40.9	40.6851	40.6851	2701.0
2019-03-26	AFIF	ETF	9.98	10.02	9.98	10.0	53514.0
2019-03-26	AFK	ETF	21.45	21.74	21.41	21.44	16610.0
2019-03-26	AFTY	ETF	16.02	16.16	16.02	16.12	14900.0
2019-03-26	AGG	ETF	108.76	108.93	108.71	108.84	3120500.0
2019-03-26	AGGY	ETF	49.75	49.82	49.71	49.73	50800.0
2019-03-26	AGNG	ETF	21.637	21.637	21.4	21.4	1200.0
2019-03-26	AGQ	ETF	25.77	25.81	25.47	25.59	72500.0
2019-03-26	AGZ	ETF	113.46	113.58	113.4101	113.53	16523.0
2019-03-26	AGZD	ETF	23.805	23.865	23.78	23.82	8400.0
2019-03-26	AIA	ETF	60.48	60.77	60.3338	60.6	38351.0
2019-03-26	AIEQ	ETF	25.58	25.811	25.54	25.65	22000.0
2019-03-26	AIQ	ETF	15.7	15.84	15.64	15.64	37643.0
2019-03-26	AIRR	ETF	24.04	24.1	23.907	24.08	38900.0
2019-03-26	AIVI	ETF	41.21	41.23	41.15	41.18	1600.0
2019-03-26	ALTY	ETF	14.73	14.82	14.73	14.82	6200.0
2019-03-26	AMJ	ETF	25.41	25.76	25.2701	25.42	1224989.0
2019-03-26	AMLP	ETF	50.2	50.8	49.8	50.1	2575160.0
2019-03-26	AMUB	ETF	15.981	15.981	15.981	15.981	0.0
2019-03-26	AMZA	ETF	59.5	60.36	59.1	59.5	73570.0
2019-03-26	ANGL	ETF	28.68	28.78	28.62	28.75	415700.0
2019-03-26	AOA	ETF	53.32	53.42	53.17	53.27	40300.0
2019-03-26	AOK	ETF	34.39	34.4534	34.37	34.37	42951.0
2019-03-26	AOM	ETF	37.94	37.9976	37.8907	37.95	66394.0
2019-03-26	AOR	ETF	44.59	44.6663	44.4695	44.54	61031.0
2019-03-26	ARGT	ETF	28.22	28.22	27.55	27.7	32600.0
2019-03-26	ARKF	ETF	21.39	21.438	21.175	21.272	19400.0
2019-03-26	ARKG	ETF	32.44	32.49	31.91	32.25	158800.0
2019-03-26	ARKK	ETF	46.5	46.648	45.8	46.15	329200.0
2019-03-26	ARKQ	ETF	33.99	34.04	33.59	33.81	12600.0
2019-03-26	ARKW	ETF	51.79	52.02	50.94	51.3	69100.0
2019-03-26	ASEA	ETF	15.77	15.87	15.77	15.87	1500.0
2019-03-26	ASET	ETF	28.91	28.9309	28.9039	28.9039	949.0
2019-03-26	ASHR	ETF	27.62	27.75	27.61	27.7	3030400.0

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

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