PREVIEW / etf_daily / 2019-01-30

all etf daily files

  file:    by_date/etf_daily/2019/2019-01-30.parquet
  size:    67 KB
  rows:    1,737

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-01-30	SPY	ETF	265.1	268.52	264.25	267.58	92473700.0
2019-01-30	QQQ	ETF	163.39	166.28	162.89	165.68	41346533.0
2019-01-30	IWM	ETF	146.98	148.34	145.68	147.8	25516900.0
2019-01-30	DIA	ETF	248.41	251.0	247.78	250.18	5686200.0
2019-01-30	GLD	ETF	123.91	125.07	123.7	124.69	12104000.0
2019-01-30	TLT	ETF	120.84	120.98	120.33	120.93	10571300.0
2019-01-30	AAAU	ETF	13.1	13.2	13.09	13.17	18900.0
2019-01-30	AADR	ETF	43.56	43.74	43.21	43.74	13700.0
2019-01-30	AAXJ	ETF	67.59	68.55	67.31	68.34	1637700.0
2019-01-30	ACES	ETF	25.05	25.099	24.978	25.075	8400.0
2019-01-30	ACSI	ETF	30.9	31.0974	30.86	31.0974	2355.0
2019-01-30	ACTX	ETF	47.7904	52.5105	47.2004	48.9704	727.0
2019-01-30	ACWF	ETF	28.101	28.39	28.03	28.34	142764.0
2019-01-30	ACWI	ETF	68.26	69.11	68.07	68.87	4186000.0
2019-01-30	ACWV	ETF	84.33	85.14	84.18	84.9	647900.0
2019-01-30	ACWX	ETF	44.65	45.181	44.53	45.03	2092020.0
2019-01-30	ADRE	ETF	39.06	39.55	38.994	39.53	4369.0
2019-01-30	AFIF	ETF	9.96	10.0098	9.94	9.98	63882.0
2019-01-30	AFK	ETF	21.25	21.7095	21.1819	21.66	23405.0
2019-01-30	AFTY	ETF	14.53	14.645	14.51	14.645	4400.0
2019-01-30	AGG	ETF	106.79	107.15	106.79	107.14	6350400.0
2019-01-30	AGGY	ETF	48.63	48.76	48.55	48.747	38400.0
2019-01-30	AGNG	ETF	20.65	20.65	20.65	20.65	500.0
2019-01-30	AGQ	ETF	27.61	28.35	27.52	28.17	531500.0
2019-01-30	AGZ	ETF	112.19	112.299	112.0901	112.2647	76262.0
2019-01-30	AGZD	ETF	23.695	23.74	23.645	23.705	20400.0
2019-01-30	AIA	ETF	59.68	60.38	59.43	60.33	203037.0
2019-01-30	AIEQ	ETF	24.22	24.45	24.03	24.39	30100.0
2019-01-30	AIQ	ETF	14.11	14.4128	14.105	14.36	12795.0
2019-01-30	AIRR	ETF	23.71	23.82	23.34	23.71	71600.0
2019-01-30	AIVI	ETF	39.89	40.35	39.81	40.17	20500.0
2019-01-30	ALTY	ETF	14.46	14.6	14.46	14.584	3100.0
2019-01-30	AMJ	ETF	25.09	25.45	24.87	25.31	6484241.0
2019-01-30	AMLP	ETF	49.5	50.15	49.0	49.8	3763800.0
2019-01-30	AMUB	ETF	15.944	15.944	15.944	15.944	0.0
2019-01-30	AMZA	ETF	58.9	59.87	58.29	59.4	87400.0
2019-01-30	ANGL	ETF	27.9	28.22	27.85	28.15	983400.0
2019-01-30	AOA	ETF	50.99	51.55	50.96	51.42	387100.0
2019-01-30	AOK	ETF	33.42	33.6194	33.42	33.58	196937.0
2019-01-30	AOM	ETF	36.67	36.9029	36.64	36.84	230961.0
2019-01-30	AOR	ETF	42.83	43.21	42.8195	43.12	310768.0
2019-01-30	ARGT	ETF	27.24	27.78	27.16	27.62	163600.0
2019-01-30	ARKG	ETF	27.35	27.69	27.041	27.64	84500.0
2019-01-30	ARKK	ETF	41.75	42.46	41.27	42.27	327400.0
2019-01-30	ARKQ	ETF	32.0	32.63	31.91	32.55	19000.0
2019-01-30	ARKW	ETF	47.84	48.72	47.5	48.64	114700.0
2019-01-30	ASEA	ETF	15.96	16.12	15.81	16.12	900.0
2019-01-30	ASET	ETF	27.52	27.52	27.52	27.52	189.0
2019-01-30	ASHR	ETF	23.75	23.97	23.69	23.96	1762000.0
2019-01-30	ASHS	ETF	23.13	23.33	23.02	23.27	10600.0

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

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