PREVIEW / etf_daily / 2019-02-15

all etf daily files

  file:    by_date/etf_daily/2019/2019-02-15.parquet
  size:    67 KB
  rows:    1,740

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-02-15	SPY	ETF	276.36	277.41	276.13	277.37	97088700.0
2019-02-15	QQQ	ETF	172.51	172.5623	171.1392	171.94	32521685.0
2019-02-15	IWM	ETF	154.78	156.24	154.27	156.22	27240200.0
2019-02-15	DIA	ETF	256.17	258.68	256.15	258.65	4751100.0
2019-02-15	GLD	ETF	124.59	125.0	124.18	124.8	12190100.0
2019-02-15	TLT	ETF	121.56	122.02	121.54	121.98	5527200.0
2019-02-15	AAAU	ETF	13.18	13.21	13.15	13.2	7900.0
2019-02-15	AADR	ETF	45.26	45.43	45.09	45.43	37900.0
2019-02-15	AAXJ	ETF	68.33	68.41	68.09	68.26	527500.0
2019-02-15	ACES	ETF	26.27	26.35	26.26	26.273	3700.0
2019-02-15	ACSI	ETF	32.3089	32.4066	32.3089	32.4066	1390.0
2019-02-15	ACTX	ETF	52.5105	52.5105	46.0204	47.2004	424.0
2019-02-15	ACWF	ETF	28.95	29.065	28.95	29.0647	17807.0
2019-02-15	ACWI	ETF	70.27	70.51	70.19	70.51	2482800.0
2019-02-15	ACWV	ETF	86.6	86.91	86.53	86.91	193800.0
2019-02-15	ACWX	ETF	45.24	45.41	45.16	45.41	1318955.0
2019-02-15	ADRE	ETF	39.8266	39.8655	39.7627	39.7992	3567.0
2019-02-15	AFIF	ETF	10.003	10.003	9.96	9.98	14393.0
2019-02-15	AFK	ETF	21.59	21.8042	21.59	21.78	1522.0
2019-02-15	AFTY	ETF	14.86	14.98	14.86	14.95	17900.0
2019-02-15	AGG	ETF	107.25	107.31	107.19	107.3	2413900.0
2019-02-15	AGGY	ETF	48.92	49.01	48.92	49.01	56300.0
2019-02-15	AGNG	ETF	21.4	21.4	21.349	21.38	5300.0
2019-02-15	AGQ	ETF	26.7	27.14	26.43	27.1	165900.0
2019-02-15	AGZ	ETF	112.2	112.21	112.182	112.21	16268.0
2019-02-15	AGZD	ETF	23.855	23.89	23.765	23.78	6800.0
2019-02-15	AIA	ETF	59.9	60.05	59.7925	59.89	23807.0
2019-02-15	AIEQ	ETF	25.5	25.6	25.5	25.58	62200.0
2019-02-15	AIQ	ETF	15.09	15.12	15.0705	15.0826	2079.0
2019-02-15	AIRR	ETF	24.83	25.248	24.83	25.2	28900.0
2019-02-15	AIVI	ETF	40.36	40.55	40.36	40.55	4000.0
2019-02-15	ALTY	ETF	14.69	14.69	14.667	14.673	1800.0
2019-02-15	AMJ	ETF	25.58	25.7333	25.53	25.62	3565962.0
2019-02-15	AMLP	ETF	49.45	49.75	49.3	49.55	2045000.0
2019-02-15	AMUB	ETF	16.1225	16.1225	16.1225	16.1225	0.0
2019-02-15	AMZA	ETF	60.0	60.5	60.0	60.2	86940.0
2019-02-15	ANGL	ETF	28.33	28.42	28.3	28.42	132000.0
2019-02-15	AOA	ETF	52.31	52.48	52.31	52.46	55900.0
2019-02-15	AOK	ETF	33.84	33.89	33.84	33.88	48123.0
2019-02-15	AOM	ETF	37.24	37.32	37.24	37.32	86862.0
2019-02-15	AOR	ETF	43.74	43.9	43.6599	43.9	67471.0
2019-02-15	ARGT	ETF	27.91	28.06	27.71	27.74	13000.0
2019-02-15	ARKF	ETF	20.66	20.66	20.541	20.616	11800.0
2019-02-15	ARKG	ETF	28.91	29.11	28.62	29.014	69700.0
2019-02-15	ARKK	ETF	45.12	45.19	44.899	45.19	208600.0
2019-02-15	ARKQ	ETF	34.69	34.94	34.69	34.93	39400.0
2019-02-15	ARKW	ETF	50.94	51.146	50.782	50.97	77100.0
2019-02-15	ASEA	ETF	16.08	16.08	15.96	16.06	2100.0
2019-02-15	ASET	ETF	28.0903	28.1049	28.0901	28.0901	1858.0
2019-02-15	ASHR	ETF	24.95	25.04	24.9	25.03	2286700.0

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

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