PREVIEW / etf_daily / 2019-12-17

all etf daily files

  file:    by_date/etf_daily/2019/2019-12-17.parquet
  size:    73 KB
  rows:    1,920

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-12-17	SPY	ETF	319.92	320.25	319.48	319.57	61097700.0
2019-12-17	QQQ	ETF	209.5	209.71	209.04	209.39	16034647.0
2019-12-17	IWM	ETF	164.14	164.7	163.7	164.7	12980000.0
2019-12-17	DIA	ETF	283.19	284.0	282.91	283.4	1697900.0
2019-12-17	GLD	ETF	139.02	139.3	138.85	139.01	4287500.0
2019-12-17	TLT	ETF	138.21	138.34	137.21	137.6	6179700.0
2019-12-17	AAAU	ETF	14.72	14.74	14.71	14.72	24100.0
2019-12-17	AADR	ETF	53.34	53.34	52.84	52.84	5300.0
2019-12-17	AAXJ	ETF	72.57	72.79	72.47	72.61	330100.0
2019-12-17	ACES	ETF	33.23	33.365	33.23	33.36	18000.0
2019-12-17	ACIO	ETF	25.67	25.7	25.662	25.69	5500.0
2019-12-17	ACSI	ETF	35.7994	35.8	35.73	35.7889	3181.0
2019-12-17	ACTX	ETF	6.0181	7.2901	6.0181	6.791	151.0
2019-12-17	ACWF	ETF	30.88	31.02	30.88	30.9426	41551.0
2019-12-17	ACWI	ETF	78.61	78.63	78.48	78.5	1671200.0
2019-12-17	ACWV	ETF	94.91	95.04	94.88	94.88	210600.0
2019-12-17	ACWX	ETF	48.84	48.9	48.77	48.79	850203.0
2019-12-17	ADME	ETF	30.72	30.73	30.67	30.691	8000.0
2019-12-17	ADRE	ETF	44.17	44.17	43.95	44.055	5275.0
2019-12-17	AESR	ETF	10.03	10.03	10.03	10.03	100.0
2019-12-17	AFIF	ETF	9.745	9.7502	9.7445	9.75	2954.0
2019-12-17	AFK	ETF	20.78	20.875	20.75	20.85	23443.0
2019-12-17	AFMC	ETF	20.376	20.376	20.376	20.376	100.0
2019-12-17	AFSM	ETF	20.44	20.485	20.44	20.485	100.0
2019-12-17	AFTY	ETF	17.19	17.245	17.18	17.245	6200.0
2019-12-17	AGG	ETF	112.69	112.7	112.52	112.59	3016300.0
2019-12-17	AGGY	ETF	52.32	52.35	52.28	52.33	183600.0
2019-12-17	AGNG	ETF	23.84	23.84	23.56	23.68	2000.0
2019-12-17	AGQ	ETF	28.82	28.9	28.62	28.71	126800.0
2019-12-17	AGZ	ETF	115.9	115.92	115.589	115.62	1364823.0
2019-12-17	AGZD	ETF	24.1	24.11	24.05	24.105	8200.0
2019-12-17	AIA	ETF	65.35	65.6799	65.35	65.6	20511.0
2019-12-17	AIEQ	ETF	28.18	28.18	28.07	28.15	25100.0
2019-12-17	AIQ	ETF	17.62	17.7	17.62	17.65	9692.0
2019-12-17	AIRR	ETF	28.94	29.11	28.94	29.08	5700.0
2019-12-17	AIVI	ETF	43.11	43.11	43.03	43.07	2400.0
2019-12-17	ALTY	ETF	14.86	14.925	14.85	14.91	9200.0
2019-12-17	AMJ	ETF	21.41	21.9	21.41	21.61	4082125.0
2019-12-17	AMLP	ETF	41.75	42.8	41.75	42.25	9312180.0
2019-12-17	AMOM	ETF	27.23	27.23	27.194	27.194	200.0
2019-12-17	AMUB	ETF	13.5963	13.5963	13.5963	13.5963	1.0
2019-12-17	AMZA	ETF	44.2	45.6	44.2	44.7	107700.0
2019-12-17	ANGL	ETF	29.79	29.84	29.76	29.82	286900.0
2019-12-17	AOA	ETF	58.13	58.19	58.04	58.13	46300.0
2019-12-17	AOK	ETF	36.35	36.38	36.3	36.33	76276.0
2019-12-17	AOM	ETF	40.29	40.32	40.2	40.26	166588.0
2019-12-17	AOR	ETF	47.93	47.995	47.93	47.93	93570.0
2019-12-17	ARGT	ETF	25.11	25.11	24.73	25.07	139800.0
2019-12-17	ARKF	ETF	24.17	24.17	24.032	24.095	11800.0
2019-12-17	ARKG	ETF	35.23	35.529	34.728	35.49	249700.0

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

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