PREVIEW / etf_daily / 2019-03-12

all etf daily files

  file:    by_date/etf_daily/2019/2019-03-12.parquet
  size:    67 KB
  rows:    1,744

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-12	SPY	ETF	279.06	280.07	278.85	279.49	79667500.0
2019-03-12	QQQ	ETF	175.17	176.14	174.7715	175.69	33953500.0
2019-03-12	IWM	ETF	154.4	154.98	153.8	154.37	18966800.0
2019-03-12	DIA	ETF	256.24	256.97	255.43	255.86	6570500.0
2019-03-12	GLD	ETF	122.54	123.03	122.4	122.98	6289900.0
2019-03-12	TLT	ETF	121.3	122.23	121.26	122.06	6422300.0
2019-03-12	AAAU	ETF	12.97	13.01	12.96	13.01	10000.0
2019-03-12	AADR	ETF	45.03	45.21	44.98	45.16	9900.0
2019-03-12	AAXJ	ETF	69.75	69.91	69.59	69.79	654300.0
2019-03-12	ACES	ETF	27.196	27.196	27.126	27.126	400.0
2019-03-12	ACSI	ETF	32.231	32.2729	32.231	32.2729	1233.0
2019-03-12	ACTX	ETF	53.1005	53.1005	48.3804	50.7405	702.0
2019-03-12	ACWF	ETF	28.8409	28.9011	28.83	28.9	10000.0
2019-03-12	ACWI	ETF	71.0	71.22	70.97	71.14	6770500.0
2019-03-12	ACWV	ETF	87.78	87.96	87.73	87.82	167200.0
2019-03-12	ACWX	ETF	45.73	45.84	45.73	45.795	986036.0
2019-03-12	ADRE	ETF	40.83	40.87	40.6401	40.7612	14012.0
2019-03-12	AFIF	ETF	10.0411	10.05	10.0	10.03	23716.0
2019-03-12	AFK	ETF	21.83	21.83	21.6867	21.7	8946.0
2019-03-12	AFTY	ETF	16.2	16.2	16.132	16.175	6200.0
2019-03-12	AGG	ETF	107.5	107.67	107.43	107.64	5243400.0
2019-03-12	AGGY	ETF	49.12	49.23	49.096	49.21	268600.0
2019-03-12	AGNG	ETF	21.42	21.485	21.378	21.485	1400.0
2019-03-12	AGQ	ETF	25.62	25.74	25.42	25.68	88100.0
2019-03-12	AGZ	ETF	112.37	112.4852	112.37	112.45	30841.0
2019-03-12	AGZD	ETF	23.85	23.85	23.83	23.83	2800.0
2019-03-12	AIA	ETF	60.82	61.0	60.77	60.9	93288.0
2019-03-12	AIEQ	ETF	25.65	25.8	25.61	25.68	40900.0
2019-03-12	AIQ	ETF	15.48	15.48	15.35	15.4	6356.0
2019-03-12	AIRR	ETF	25.06	25.06	24.92	24.92	7900.0
2019-03-12	AIVI	ETF	40.95	40.96	40.86	40.91	4300.0
2019-03-12	ALTY	ETF	14.89	15.0	14.66	14.66	17700.0
2019-03-12	AMJ	ETF	25.1	25.31	25.04	25.1	917164.0
2019-03-12	AMLP	ETF	49.55	49.85	49.3	49.45	2460160.0
2019-03-12	AMUB	ETF	15.7975	15.7975	15.7975	15.7975	4.0
2019-03-12	AMZA	ETF	59.7	59.9	59.2	59.3	35730.0
2019-03-12	ANGL	ETF	28.36	28.45	28.36	28.44	374200.0
2019-03-12	AOA	ETF	52.7	52.92	52.7	52.85	58900.0
2019-03-12	AOK	ETF	34.06	34.11	34.0201	34.07	57926.0
2019-03-12	AOM	ETF	37.54	37.62	37.53	37.6	114597.0
2019-03-12	AOR	ETF	44.13	44.2138	44.11	44.13	113712.0
2019-03-12	ARGT	ETF	28.03	28.22	27.81	27.97	63500.0
2019-03-12	ARKF	ETF	21.1	21.189	21.038	21.132	22900.0
2019-03-12	ARKG	ETF	31.85	32.25	31.52	32.13	176700.0
2019-03-12	ARKK	ETF	46.5	46.77	46.036	46.55	461900.0
2019-03-12	ARKQ	ETF	33.96	34.05	33.747	33.84	18300.0
2019-03-12	ARKW	ETF	51.45	51.76	51.16	51.54	76700.0
2019-03-12	ASEA	ETF	15.82	15.83	15.76	15.83	1400.0
2019-03-12	ASET	ETF	28.57	28.594	28.57	28.594	620.0
2019-03-12	ASHR	ETF	28.14	28.26	28.11	28.17	7252200.0

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

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