PREVIEW / etf_daily / 2019-03-07

all etf daily files

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

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-07	SPY	ETF	276.83	276.99	274.07	275.01	94885100.0
2019-03-07	QQQ	ETF	173.09	173.18	170.79	171.43	39407443.0
2019-03-07	IWM	ETF	153.02	153.14	151.37	151.68	26822500.0
2019-03-07	DIA	ETF	256.4	256.49	253.61	254.81	4104600.0
2019-03-07	GLD	ETF	121.27	121.71	121.18	121.51	6088800.0
2019-03-07	TLT	ETF	120.64	121.26	120.61	121.06	8187200.0
2019-03-07	AAAU	ETF	12.83	12.86	12.83	12.85	23000.0
2019-03-07	AADR	ETF	44.86	44.86	44.34	44.49	4600.0
2019-03-07	AAXJ	ETF	69.59	69.6	68.68	68.78	1157700.0
2019-03-07	ACES	ETF	26.41	26.71	26.406	26.453	6500.0
2019-03-07	ACSI	ETF	32.0	32.0	31.8566	31.8566	1187.0
2019-03-07	ACTX	ETF	56.0505	56.0505	52.5105	54.8705	414.0
2019-03-07	ACWF	ETF	28.76	28.76	28.48	28.56	49971.0
2019-03-07	ACWI	ETF	70.71	70.71	69.96	70.12	3671300.0
2019-03-07	ACWV	ETF	87.12	87.18	86.67	86.8	165900.0
2019-03-07	ACWX	ETF	45.75	45.769	45.24	45.27	7216834.0
2019-03-07	ADRE	ETF	40.0	40.0	39.6907	39.6907	2756.0
2019-03-07	AFIF	ETF	10.0371	10.06	10.02	10.04	20360.0
2019-03-07	AFK	ETF	21.698	21.698	21.5345	21.5345	2223.0
2019-03-07	AFTY	ETF	16.343	16.343	16.15	16.2	13700.0
2019-03-07	AGG	ETF	107.16	107.35	107.12	107.29	6089100.0
2019-03-07	AGGY	ETF	48.975	49.03	48.94	49.02	91200.0
2019-03-07	AGNG	ETF	20.952	21.187	20.93	21.1	5700.0
2019-03-07	AGQ	ETF	24.27	24.45	24.2	24.3	84600.0
2019-03-07	AGZ	ETF	112.18	112.2399	112.18	112.2	16990.0
2019-03-07	AGZD	ETF	23.85	23.91	23.785	23.84	23400.0
2019-03-07	AIA	ETF	60.54	60.55	59.89	59.99	47700.0
2019-03-07	AIEQ	ETF	25.45	25.456	25.24	25.28	62300.0
2019-03-07	AIQ	ETF	15.27	15.27	15.02	15.04	17034.0
2019-03-07	AIRR	ETF	24.99	25.047	24.819	24.87	25600.0
2019-03-07	AIVI	ETF	40.72	40.72	40.46	40.46	9900.0
2019-03-07	ALTY	ETF	14.53	14.6	14.521	14.55	5000.0
2019-03-07	AMJ	ETF	24.52	24.97	24.49	24.96	2328779.0
2019-03-07	AMLP	ETF	48.45	49.15	48.2	49.1	4061440.0
2019-03-07	AMUB	ETF	15.7064	15.7064	15.7064	15.7064	0.0
2019-03-07	AMZA	ETF	58.2	58.8	57.89	58.6	67860.0
2019-03-07	ANGL	ETF	28.47	28.47	28.36	28.4	690000.0
2019-03-07	AOA	ETF	52.62	52.62	52.17	52.29	72500.0
2019-03-07	AOK	ETF	33.95	33.95	33.8501	33.86	48764.0
2019-03-07	AOM	ETF	37.46	37.46	37.28	37.3	100332.0
2019-03-07	AOR	ETF	43.98	43.98	43.7	43.78	106988.0
2019-03-07	ARGT	ETF	27.01	27.15	26.6	26.76	40600.0
2019-03-07	ARKF	ETF	20.94	20.94	20.6	20.653	22700.0
2019-03-07	ARKG	ETF	30.34	30.844	29.83	30.51	175000.0
2019-03-07	ARKK	ETF	45.09	45.245	44.274	44.57	356800.0
2019-03-07	ARKQ	ETF	33.74	33.74	32.84	32.92	65400.0
2019-03-07	ARKW	ETF	50.4	50.41	49.676	49.83	126200.0
2019-03-07	ASEA	ETF	15.82	15.82	15.65	15.77	1200.0
2019-03-07	ASET	ETF	28.21	28.24	28.1799	28.1799	1507.0
2019-03-07	ASHR	ETF	28.33	28.33	27.93	27.99	10582200.0

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

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