PREVIEW / etf_daily / 2020-03-04

all etf daily files

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

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-04	SPY	ETF	306.12	313.1	303.33	312.86	176613400.0
2020-03-04	QQQ	ETF	213.32	218.33	211.37	218.22	73086209.0
2020-03-04	IWM	ETF	150.28	152.45	148.52	152.16	36195800.0
2020-03-04	DIA	ETF	265.45	271.11	262.96	270.89	5408100.0
2020-03-04	GLD	ETF	154.4	154.96	153.7	154.16	12315500.0
2020-03-04	TLT	ETF	156.41	157.35	154.19	154.67	23463700.0
2020-03-04	AAAU	ETF	16.37	16.41	16.3	16.34	293000.0
2020-03-04	AADR	ETF	51.63	52.35	51.34	52.11	23000.0
2020-03-04	AAXJ	ETF	69.89	70.16	69.58	70.07	868600.0
2020-03-04	ABEQ	ETF	23.404	23.742	23.404	23.742	14800.0
2020-03-04	ACES	ETF	39.62	39.71	39.0	39.69	44400.0
2020-03-04	ACIO	ETF	24.47	24.87	24.44	24.863	186500.0
2020-03-04	ACSI	ETF	33.81	34.6891	33.81	34.6891	785.0
2020-03-04	ACTX	ETF	6.4901	6.7851	6.4901	6.4901	119.0
2020-03-04	ACWF	ETF	29.0691	29.5145	28.96	29.5145	6722.0
2020-03-04	ACWI	ETF	74.52	75.86	73.98	75.86	3885200.0
2020-03-04	ACWV	ETF	93.92	95.39	93.48	95.25	375500.0
2020-03-04	ACWX	ETF	45.38	45.8	45.065	45.76	812260.0
2020-03-04	ADME	ETF	30.55	31.01	30.39	31.01	141700.0
2020-03-04	ADRE	ETF	40.81	41.1483	40.7569	41.105	5581.0
2020-03-04	AESR	ETF	9.61	9.832	9.61	9.832	1800.0
2020-03-04	AFIF	ETF	9.9798	9.99	9.93	9.935	8117.0
2020-03-04	AFK	ETF	17.5	17.75	17.5	17.74	8978.0
2020-03-04	AFTY	ETF	16.81	16.91	16.81	16.882	5900.0
2020-03-04	AGG	ETF	116.83	117.12	116.53	116.64	6285300.0
2020-03-04	AGGY	ETF	54.16	54.3	54.04	54.15	418500.0
2020-03-04	AGNG	ETF	23.2	23.65	23.04	23.65	2900.0
2020-03-04	AGQ	ETF	28.39	28.7	28.13	28.67	95100.0
2020-03-04	AGZ	ETF	119.64	119.8718	119.51	119.56	82619.0
2020-03-04	AGZD	ETF	23.73	23.875	23.73	23.81	10800.0
2020-03-04	AIA	ETF	63.14	63.59	62.9	63.44	38380.0
2020-03-04	AIEQ	ETF	27.21	27.77	27.02	27.66	16800.0
2020-03-04	AIQ	ETF	17.93	18.12	17.738	18.12	14196.0
2020-03-04	AIRR	ETF	26.02	26.461	25.91	26.461	21300.0
2020-03-04	AIVI	ETF	38.45	39.09	38.36	39.09	8000.0
2020-03-04	ALTY	ETF	13.6	14.03	13.6	13.98	13500.0
2020-03-04	AMJ	ETF	17.56	17.67	17.172	17.31	6547173.0
2020-03-04	AMLP	ETF	34.15	34.25	33.3	33.5	7723260.0
2020-03-04	AMOM	ETF	25.66	26.238	25.66	26.238	300.0
2020-03-04	AMUB	ETF	10.975	10.975	10.8381	10.9089	6192.0
2020-03-04	AMZA	ETF	32.3	32.5	31.0	31.4	100840.0
2020-03-04	ANGL	ETF	29.86	30.05	29.75	30.02	1748800.0
2020-03-04	AOA	ETF	55.31	56.0	55.04	56.0	58700.0
2020-03-04	AOK	ETF	36.34	36.485	36.239	36.45	81700.0
2020-03-04	AOM	ETF	39.94	40.11	39.8116	40.06	151216.0
2020-03-04	AOR	ETF	46.6	47.09	46.405	47.06	148804.0
2020-03-04	ARCM	ETF	100.095	100.095	100.095	100.095	100.0
2020-03-04	ARGT	ETF	24.0	24.33	23.86	24.16	15600.0
2020-03-04	ARKF	ETF	24.84	25.277	24.67	25.23	65000.0
2020-03-04	ARKG	ETF	36.26	37.06	35.91	37.02	356500.0

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

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