PREVIEW / etf_daily / 2020-03-06

all etf daily files

  file:    by_date/etf_daily/2020/2020-03-06.parquet
  size:    75 KB
  rows:    1,969

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-03-06	SPY	ETF	293.15	298.78	290.23	297.46	228667200.0
2020-03-06	QQQ	ETF	204.67	209.15	202.91	208.02	89828392.0
2020-03-06	IWM	ETF	142.71	145.98	140.99	144.4	39688300.0
2020-03-06	DIA	ETF	253.67	260.1	252.43	258.85	7372400.0
2020-03-06	GLD	ETF	158.33	159.25	154.54	157.55	26973400.0
2020-03-06	TLT	ETF	167.3	169.33	164.11	166.77	76288300.0
2020-03-06	AAAU	ETF	16.79	16.85	16.39	16.69	311400.0
2020-03-06	AADR	ETF	49.65	49.84	49.23	49.61	18500.0
2020-03-06	AAXJ	ETF	68.18	68.36	67.43	68.09	1706300.0
2020-03-06	ABEQ	ETF	23.02	23.205	22.823	23.112	114800.0
2020-03-06	ACES	ETF	37.91	38.61	37.55	38.231	57700.0
2020-03-06	ACIO	ETF	24.34	24.38	24.09	24.38	48600.0
2020-03-06	ACSI	ETF	32.6262	33.0751	32.3826	33.0751	1336.0
2020-03-06	ACTX	ETF	5.9591	6.8075	5.9591	6.7851	584.0
2020-03-06	ACWF	ETF	27.86	28.2192	27.8428	28.2192	15989.0
2020-03-06	ACWI	ETF	71.5	72.6	71.07	72.23	4586200.0
2020-03-06	ACWV	ETF	92.05	93.31	91.41	93.02	880200.0
2020-03-06	ACWX	ETF	43.84	44.17	43.55	44.02	1429209.0
2020-03-06	ADME	ETF	29.3	30.23	29.3	30.23	41900.0
2020-03-06	ADRE	ETF	39.29	39.39	38.8283	39.25	7433.0
2020-03-06	AESR	ETF	9.31	9.387	9.154	9.387	1200.0
2020-03-06	AFIF	ETF	10.09	10.12	10.08	10.08	42221.0
2020-03-06	AFK	ETF	17.3	17.3	17.12	17.1513	15001.0
2020-03-06	AFLG	ETF	18.796	18.796	18.794	18.794	900.0
2020-03-06	AFMC	ETF	17.98	17.98	17.98	17.98	7600.0
2020-03-06	AFTY	ETF	16.56	16.716	16.53	16.58	8900.0
2020-03-06	AGG	ETF	118.18	118.27	117.5	117.86	17456400.0
2020-03-06	AGGY	ETF	54.68	54.68	54.38	54.55	367600.0
2020-03-06	AGNG	ETF	22.27	22.788	22.25	22.543	11100.0
2020-03-06	AGQ	ETF	29.16	29.24	28.02	28.98	279500.0
2020-03-06	AGZ	ETF	120.88	121.1477	120.76	120.85	66180.0
2020-03-06	AGZD	ETF	23.835	23.855	23.68	23.73	35000.0
2020-03-06	AIA	ETF	61.61	62.0499	61.2598	61.81	46330.0
2020-03-06	AIEQ	ETF	26.14	26.488	25.8	26.34	27500.0
2020-03-06	AIQ	ETF	17.14	17.245	16.82	16.89	14454.0
2020-03-06	AIRR	ETF	25.12	25.12	24.64	24.76	12700.0
2020-03-06	AIVI	ETF	37.34	37.5	37.15	37.44	17500.0
2020-03-06	ALTY	ETF	13.26	13.52	13.259	13.33	8200.0
2020-03-06	AMJ	ETF	16.21	16.2979	15.515	15.58	6272967.0
2020-03-06	AMLP	ETF	31.5	31.65	30.05	30.25	8974000.0
2020-03-06	AMOM	ETF	24.84	25.156	24.84	25.156	100.0
2020-03-06	AMUB	ETF	9.87	9.9281	9.8367	9.8367	4693.0
2020-03-06	AMZA	ETF	29.1	29.1	26.6	26.9	251540.0
2020-03-06	ANGL	ETF	29.44	29.68	29.22	29.51	490500.0
2020-03-06	AOA	ETF	53.85	54.16	53.38	54.12	154900.0
2020-03-06	AOK	ETF	36.04	36.24	36.0322	36.22	83543.0
2020-03-06	AOM	ETF	39.59	39.7	39.388	39.63	177812.0
2020-03-06	AOR	ETF	45.55	45.92	45.44	45.81	151959.0
2020-03-06	ARGT	ETF	23.2	23.2	22.52	22.95	16200.0
2020-03-06	ARKF	ETF	23.94	24.12	23.54	24.04	62000.0

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

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