PREVIEW / etf_daily / 2020-06-11

all etf daily files

  file:    by_date/etf_daily/2020/2020-06-11.parquet
  size:    76 KB
  rows:    2,020

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-06-11	SPY	ETF	311.46	312.15	300.01	300.61	209243600.0
2020-06-11	QQQ	ETF	242.29	243.59	233.96	234.02	72919442.0
2020-06-11	IWM	ETF	140.15	141.03	134.77	135.03	72041500.0
2020-06-11	DIA	ETF	262.14	263.51	251.38	252.03	14257800.0
2020-06-11	GLD	ETF	163.35	164.06	161.97	162.39	11673900.0
2020-06-11	TLT	ETF	163.25	164.23	162.63	163.88	17086400.0
2020-06-11	AAAU	ETF	17.33	17.4	17.17	17.23	308800.0
2020-06-11	AADR	ETF	50.44	50.61	49.27	49.28	8600.0
2020-06-11	AAXJ	ETF	68.3	68.61	66.94	66.97	3092700.0
2020-06-11	ABEQ	ETF	22.14	22.14	21.89	22.0	3000.0
2020-06-11	ACES	ETF	37.82	37.87	36.35	36.4	44900.0
2020-06-11	ACIO	ETF	25.005	25.05	24.71	24.83	35900.0
2020-06-11	ACSI	ETF	33.54	33.54	32.5098	32.5098	825.0
2020-06-11	ACTX	ETF	4.7495	4.7495	4.248	4.248	288.0
2020-06-11	ACWF	ETF	28.04	28.04	27.1817	27.2723	16887.0
2020-06-11	ACWI	ETF	74.54	74.66	72.04	72.15	3414800.0
2020-06-11	ACWV	ETF	89.81	89.96	87.24	87.4	699800.0
2020-06-11	ACWX	ETF	43.67	43.85	42.51	42.57	1590494.0
2020-06-11	ADME	ETF	31.86	31.975	31.231	31.3	27900.0
2020-06-11	ADRE	ETF	39.31	39.4	38.58	38.58	8964.0
2020-06-11	AESR	ETF	9.584	9.584	9.584	9.584	100.0
2020-06-11	AFIF	ETF	9.78	9.8	9.78	9.8	1570.0
2020-06-11	AFK	ETF	16.14	16.3766	15.78	15.78	13863.0
2020-06-11	AFLG	ETF	18.91	18.91	18.3	18.32	11400.0
2020-06-11	AFMC	ETF	17.05	17.05	16.551	16.551	300.0
2020-06-11	AFSM	ETF	16.42	16.42	16.022	16.022	300.0
2020-06-11	AFTY	ETF	16.21	16.21	16.17	16.17	1200.0
2020-06-11	AGG	ETF	117.73	117.8	117.44	117.46	7438800.0
2020-06-11	AGGY	ETF	53.77	53.78	53.59	53.65	180900.0
2020-06-11	AGNG	ETF	24.35	24.35	23.5	23.5	6000.0
2020-06-11	AGQ	ETF	28.79	29.21	26.99	27.35	697300.0
2020-06-11	AGZ	ETF	120.68	120.93	120.64	120.7	99312.0
2020-06-11	AGZD	ETF	23.565	23.565	23.475	23.49	25000.0
2020-06-11	AIA	ETF	64.02	64.13	62.72	62.91	168309.0
2020-06-11	AIEQ	ETF	27.36	27.7	26.75	26.827	26800.0
2020-06-11	AIQ	ETF	20.15	20.22	19.51	19.55	30877.0
2020-06-11	AIRR	ETF	23.63	23.63	22.655	22.655	44000.0
2020-06-11	AIVI	ETF	36.09	36.1	34.94	35.0	6400.0
2020-06-11	ALTY	ETF	11.31	11.31	10.75	10.8	22800.0
2020-06-11	AMJ	ETF	14.49	14.92	14.17	14.39	2042989.0
2020-06-11	AMLP	ETF	27.66	27.75	26.42	26.46	5871100.0
2020-06-11	AMOM	ETF	27.776	27.776	27.776	27.776	100.0
2020-06-11	AMUB	ETF	9.295	9.295	9.0073	9.0073	8907.0
2020-06-11	AMZA	ETF	20.7	20.76	19.175	19.48	186300.0
2020-06-11	ANGL	ETF	28.53	28.59	28.04	28.18	1015200.0
2020-06-11	AOA	ETF	55.07	55.07	53.44	53.58	86700.0
2020-06-11	AOK	ETF	36.33	36.33	35.83	35.83	135155.0
2020-06-11	AOM	ETF	39.99	39.99	39.215	39.3	198617.0
2020-06-11	AOR	ETF	46.27	46.95	45.3419	45.48	223305.0
2020-06-11	APRT	ETF	25.03	25.03	24.6563	24.6563	1129.0

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

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