PREVIEW / etf_daily / 2020-07-27

all etf daily files

  file:    by_date/etf_daily/2020/2020-07-27.parquet
  size:    77 KB
  rows:    2,042

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-07-27	SPY	ETF	321.63	323.41	320.77	323.22	48293000.0
2020-07-27	QQQ	ETF	257.36	260.52	256.445	260.12	36445741.0
2020-07-27	IWM	ETF	146.19	147.69	145.39	147.6	13370700.0
2020-07-27	DIA	ETF	264.77	266.31	264.35	265.95	2637900.0
2020-07-27	GLD	ETF	181.85	182.83	181.53	182.23	21115600.0
2020-07-27	TLT	ETF	170.25	170.3	168.99	169.11	6146400.0
2020-07-27	AAAU	ETF	19.32	19.4	19.26	19.34	1107300.0
2020-07-27	AADR	ETF	57.37	58.2	57.37	58.2	2400.0
2020-07-27	AAXJ	ETF	74.54	75.23	74.41	75.17	2255700.0
2020-07-27	ABEQ	ETF	23.18	23.235	23.18	23.235	2900.0
2020-07-27	ACES	ETF	45.28	46.163	45.25	46.16	23000.0
2020-07-27	ACIO	ETF	25.8	25.907	25.784	25.902	5700.0
2020-07-27	ACSI	ETF	34.9607	34.9607	34.9607	34.9607	102.0
2020-07-27	ACTX	ETF	2.7966	2.95	2.242	2.6137	921.0
2020-07-27	ACWF	ETF	29.215	29.42	29.215	29.4052	13468.0
2020-07-27	ACWI	ETF	77.57	78.05	77.42	78.02	1298500.0
2020-07-27	ACWV	ETF	91.2	91.51	91.17	91.39	146900.0
2020-07-27	ACWX	ETF	45.78	46.07	45.74	46.07	1213047.0
2020-07-27	ADME	ETF	33.22	33.327	33.22	33.3	6500.0
2020-07-27	ADRE	ETF	45.67	46.2999	45.57	46.2419	13205.0
2020-07-27	AESR	ETF	10.374	10.396	10.374	10.396	200.0
2020-07-27	AFIF	ETF	9.83	9.8341	9.82	9.8341	5859.0
2020-07-27	AFK	ETF	17.89	17.89	17.481	17.59	14507.0
2020-07-27	AFLG	ETF	19.68	19.68	19.68	19.68	200.0
2020-07-27	AFMC	ETF	17.7	17.824	17.66	17.824	4400.0
2020-07-27	AFSM	ETF	17.542	17.542	17.542	17.542	100.0
2020-07-27	AFTY	ETF	18.33	18.347	18.3	18.335	5300.0
2020-07-27	AGG	ETF	119.4	119.42	119.15	119.2	5606100.0
2020-07-27	AGGY	ETF	54.54	54.54	54.41	54.44	148100.0
2020-07-27	AGQ	ETF	49.52	50.68	49.06	50.64	3709700.0
2020-07-27	AGZ	ETF	121.83	121.83	121.6	121.64	29372.0
2020-07-27	AGZD	ETF	23.65	23.685	23.5	23.59	156600.0
2020-07-27	AIA	ETF	69.85	70.49	69.68	70.49	43779.0
2020-07-27	AIEQ	ETF	29.68	30.0	29.64	30.0	13500.0
2020-07-27	AIQ	ETF	21.58	21.765	21.56	21.765	14645.0
2020-07-27	AIRR	ETF	24.45	24.567	24.45	24.567	500.0
2020-07-27	AIVI	ETF	36.96	37.15	36.96	37.12	12400.0
2020-07-27	ALTL	ETF	24.81	24.9595	24.7443	24.9489	12665.0
2020-07-27	ALTY	ETF	10.72	10.72	10.63	10.64	6800.0
2020-07-27	AMJ	ETF	13.13	13.13	12.77	12.84	1047207.0
2020-07-27	AMLP	ETF	24.01	24.14	23.7	23.77	1876800.0
2020-07-27	AMNA	ETF	23.4	23.46	23.39	23.4459	3000.0
2020-07-27	AMND	ETF	24.66	24.6884	24.66	24.6884	200.0
2020-07-27	AMOM	ETF	32.28	32.7	32.03	32.6	3300.0
2020-07-27	AMUB	ETF	7.77	8.0582	7.77	8.0582	1976.0
2020-07-27	AMZA	ETF	17.02	17.071	16.627	16.82	129600.0
2020-07-27	ANGL	ETF	30.04	30.16	29.99	30.15	377900.0
2020-07-27	AOA	ETF	56.87	57.06	56.69	57.02	37100.0
2020-07-27	AOK	ETF	37.07	37.17	37.06	37.17	184202.0
2020-07-27	AOM	ETF	40.72	40.87	40.6453	40.77	115752.0

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

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