PREVIEW / etf_daily / 2020-02-18

all etf daily files

  file:    by_date/etf_daily/2020/2020-02-18.parquet
  size:    74 KB
  rows:    1,948

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
2020-02-18	SPY	ETF	336.51	337.67	335.21	336.73	57226200.0
2020-02-18	QQQ	ETF	233.47	235.17	233.25	234.73	24521242.0
2020-02-18	IWM	ETF	167.5	168.06	166.43	167.54	13412100.0
2020-02-18	DIA	ETF	293.15	293.88	291.76	292.95	2397800.0
2020-02-18	GLD	ETF	149.88	151.09	149.47	150.91	11524900.0
2020-02-18	TLT	ETF	145.34	146.05	144.92	145.54	6909200.0
2020-02-18	AAAU	ETF	15.89	16.0	15.84	15.99	109600.0
2020-02-18	AADR	ETF	56.43	56.58	56.3	56.51	4700.0
2020-02-18	AAXJ	ETF	72.59	72.8	72.47	72.58	921300.0
2020-02-18	ABEQ	ETF	24.878	24.989	24.87	24.989	5600.0
2020-02-18	ACES	ETF	40.67	41.216	40.67	41.15	88800.0
2020-02-18	ACIO	ETF	25.19	25.25	25.11	25.16	18800.0
2020-02-18	ACSI	ETF	37.48	37.5834	37.48	37.5773	928.0
2020-02-18	ACTX	ETF	7.3751	7.8766	7.3751	7.6701	78.0
2020-02-18	ACWF	ETF	31.59	31.7279	31.59	31.6579	21156.0
2020-02-18	ACWI	ETF	81.07	81.21	80.83	81.12	2040300.0
2020-02-18	ACWV	ETF	99.11	99.4	99.11	99.26	401200.0
2020-02-18	ACWX	ETF	48.55	48.68	48.5	48.58	885990.0
2020-02-18	ADME	ETF	31.58	31.724	31.58	31.67	9200.0
2020-02-18	ADRE	ETF	43.28	43.28	43.126	43.24	7925.0
2020-02-18	AESR	ETF	10.54	10.55	10.5	10.52	4400.0
2020-02-18	AFIF	ETF	9.88	9.88	9.74	9.765	4603.0
2020-02-18	AFK	ETF	19.75	19.82	19.69	19.69	9625.0
2020-02-18	AFLG	ETF	21.22	21.22	21.161	21.161	200.0
2020-02-18	AFTY	ETF	16.45	16.45	16.37	16.37	1400.0
2020-02-18	AGG	ETF	114.48	114.56	114.34	114.44	4874800.0
2020-02-18	AGGY	ETF	53.32	53.39	53.3	53.34	232900.0
2020-02-18	AGNG	ETF	24.74	24.74	24.5	24.5	26600.0
2020-02-18	AGQ	ETF	31.68	32.57	31.51	32.53	490200.0
2020-02-18	AGZ	ETF	117.17	117.1973	117.077	117.14	47908.0
2020-02-18	AGZD	ETF	24.065	24.09	24.025	24.065	12000.0
2020-02-18	AIA	ETF	65.64	65.95	65.64	65.66	39892.0
2020-02-18	AIEQ	ETF	30.12	30.16	30.02	30.14	29500.0
2020-02-18	AIQ	ETF	19.73	19.79	19.6362	19.76	29487.0
2020-02-18	AIRR	ETF	29.116	29.198	29.05	29.145	3600.0
2020-02-18	AIVI	ETF	41.41	41.45	41.38	41.4	5000.0
2020-02-18	ALTY	ETF	15.01	15.046	15.003	15.025	10500.0
2020-02-18	AMJ	ETF	20.54	20.6	20.43	20.54	1259254.0
2020-02-18	AMLP	ETF	39.2	39.2	38.9	39.15	3016180.0
2020-02-18	AMOM	ETF	27.906	27.906	27.906	27.906	100.0
2020-02-18	AMUB	ETF	12.9178	12.94	12.9	12.915	3209.0
2020-02-18	AMZA	ETF	40.0	40.1	39.9	40.1	68150.0
2020-02-18	ANGL	ETF	30.47	30.5	30.32	30.38	565500.0
2020-02-18	AOA	ETF	59.0	59.09	58.87	58.95	63900.0
2020-02-18	AOK	ETF	36.82	36.91	36.8024	36.89	75173.0
2020-02-18	AOM	ETF	40.92	41.0	40.79	40.82	120540.0
2020-02-18	AOR	ETF	48.58	48.73	48.58	48.65	173363.0
2020-02-18	ARCM	ETF	100.13	100.13	100.13	100.13	100.0
2020-02-18	ARGT	ETF	25.87	26.05	25.87	25.93	11100.0
2020-02-18	ARKF	ETF	27.0	27.08	26.92	27.03	46600.0

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

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