PREVIEW / etf_daily / 2021-03-11

all etf daily files

  file:    by_date/etf_daily/2021/2021-03-11.parquet
  size:    86 KB
  rows:    2,272

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
2021-03-11	SPY	ETF	392.23	395.65	391.74	393.53	86245000.0
2021-03-11	QQQ	ETF	315.77	319.86	314.85	318.04	53484804.0
2021-03-11	IWM	ETF	229.55	232.28	228.79	232.22	25256700.0
2021-03-11	DIA	ETF	324.71	326.97	323.83	325.33	5745900.0
2021-03-11	GLD	ETF	161.47	161.98	161.12	161.52	6749200.0
2021-03-11	TLT	ETF	139.17	139.38	138.46	139.01	14150700.0
2021-03-11	AAA	ETF	25.09	25.09	25.08	25.08	559.0
2021-03-11	AAAU	ETF	17.16	17.2	17.12	17.15	1166000.0
2021-03-11	AADR	ETF	64.15	64.74	64.15	64.73	4600.0
2021-03-11	AAXJ	ETF	95.38	96.15	94.99	96.07	625200.0
2021-03-11	ABEQ	ETF	26.259	26.27	26.19	26.19	24500.0
2021-03-11	ACES	ETF	79.89	81.68	78.44	81.68	97700.0
2021-03-11	ACIO	ETF	27.81	27.95	27.735	27.85	30900.0
2021-03-11	ACSI	ETF	45.759	45.96	45.7399	45.782	4356.0
2021-03-11	ACTV	ETF	36.67	36.81	36.67	36.7765	2810.0
2021-03-11	ACTX	ETF	3.02	3.41	3.02	3.03	4057.0
2021-03-11	ACVF	ETF	29.19	29.39	29.19	29.385	700.0
2021-03-11	ACWF	ETF	35.72	35.97	35.72	35.93	16503.0
2021-03-11	ACWI	ETF	94.96	95.64	94.76	95.35	1440300.0
2021-03-11	ACWV	ETF	96.72	97.2	96.57	96.76	147400.0
2021-03-11	ACWX	ETF	55.63	55.98	55.52	55.94	1511951.0
2021-03-11	ADFI	ETF	9.67	9.67	9.657	9.657	300.0
2021-03-11	ADME	ETF	36.06	36.26	35.94	36.13	42200.0
2021-03-11	ADRE	ETF	59.41	60.03	58.98	59.9332	10434.0
2021-03-11	AESR	ETF	12.45	12.569	12.45	12.478	25400.0
2021-03-11	AFIF	ETF	9.7021	9.72	9.67	9.705	28289.0
2021-03-11	AFK	ETF	21.76	21.8	21.59	21.8	10561.0
2021-03-11	AFLG	ETF	23.59	23.643	23.59	23.643	400.0
2021-03-11	AFMC	ETF	24.407	24.407	24.407	24.407	100.0
2021-03-11	AFSM	ETF	25.86	25.937	25.86	25.937	400.0
2021-03-11	AFTY	ETF	23.25	23.38	23.14	23.362	4100.0
2021-03-11	AGG	ETF	114.47	114.54	114.3	114.44	8827800.0
2021-03-11	AGGY	ETF	51.6	51.72	51.58	51.65	573800.0
2021-03-11	AGNG	ETF	27.49	27.71	27.49	27.71	4000.0
2021-03-11	AGQ	ETF	47.0	47.51	46.13	47.39	592800.0
2021-03-11	AGZ	ETF	118.13	118.23	118.13	118.14	67541.0
2021-03-11	AGZD	ETF	23.685	23.695	23.63	23.675	28600.0
2021-03-11	AIA	ETF	95.52	96.3	95.05	96.2	510685.0
2021-03-11	AIEQ	ETF	38.81	39.69	38.81	39.69	67500.0
2021-03-11	AIQ	ETF	28.55	29.1197	28.55	29.1	25508.0
2021-03-11	AIRR	ETF	41.63	41.688	41.13	41.575	70800.0
2021-03-11	AIVI	ETF	42.58	42.71	42.58	42.64	7300.0
2021-03-11	ALTL	ETF	39.84	40.47	39.84	40.0364	71874.0
2021-03-11	ALTY	ETF	12.7	12.7	12.607	12.67	23700.0
2021-03-11	AMJ	ETF	17.33	17.54	17.24	17.41	1064730.0
2021-03-11	AMLP	ETF	32.48	32.48	32.02	32.14	1865200.0
2021-03-11	AMNA	ETF	30.5573	30.5573	30.5573	30.5573	1.0
2021-03-11	AMND	ETF	32.5875	32.5875	32.5875	32.5875	13.0
2021-03-11	AMOM	ETF	32.45	32.45	32.389	32.389	1400.0
2021-03-11	AMPS	ETF	10.11	10.18	10.0	10.18	57769.0

> showing 50 of 2,272 rows — these rows as CSV

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