PREVIEW / etf_daily / 2020-10-09

all etf daily files

  file:    by_date/etf_daily/2020/2020-10-09.parquet
  size:    80 KB
  rows:    2,116

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-10-09	SPY	ETF	345.56	347.35	344.89	346.85	59528600.0
2020-10-09	QQQ	ETF	283.09	285.79	282.71	285.71	30201144.0
2020-10-09	IWM	ETF	163.35	163.71	161.81	162.7	25038100.0
2020-10-09	DIA	ETF	285.61	286.81	284.41	285.93	2549100.0
2020-10-09	GLD	ETF	180.13	181.17	179.93	181.08	15979800.0
2020-10-09	TLT	ETF	159.52	160.27	158.81	160.09	8441500.0
2020-10-09	AAA	ETF	24.88	24.91	24.88	24.895	16339.0
2020-10-09	AAAU	ETF	19.12	19.22	19.1	19.22	420400.0
2020-10-09	AADR	ETF	57.5	58.0	57.5	57.99	4000.0
2020-10-09	AAXJ	ETF	79.73	80.3	79.61	80.12	755900.0
2020-10-09	ABEQ	ETF	23.78	24.1	23.78	23.956	9100.0
2020-10-09	ACES	ETF	60.7	61.566	60.7	61.44	54200.0
2020-10-09	ACIO	ETF	26.98	27.12	26.98	27.12	18000.0
2020-10-09	ACSI	ETF	39.0595	39.0704	39.0595	39.0704	384.0
2020-10-09	ACTX	ETF	2.0	2.0	2.0	2.0	1600.0
2020-10-09	ACWF	ETF	30.8055	30.965	30.8055	30.8979	3761.0
2020-10-09	ACWI	ETF	82.54	82.89	82.41	82.82	1629200.0
2020-10-09	ACWV	ETF	93.76	94.28	93.74	94.08	299100.0
2020-10-09	ACWX	ETF	47.47	47.63	47.37	47.59	955035.0
2020-10-09	ADME	ETF	34.23	34.43	34.23	34.43	8400.0
2020-10-09	ADRE	ETF	49.24	49.485	49.1877	49.415	5299.0
2020-10-09	AESR	ETF	11.212	11.239	11.212	11.239	400.0
2020-10-09	AFIF	ETF	9.77	9.82	9.77	9.8002	2899.0
2020-10-09	AFK	ETF	17.85	18.01	17.85	17.92	4110.0
2020-10-09	AFLG	ETF	20.9	20.96	20.9	20.902	400.0
2020-10-09	AFTY	ETF	19.95	20.0	19.94	19.977	9900.0
2020-10-09	AGG	ETF	117.65	117.74	117.5	117.72	2909300.0
2020-10-09	AGGY	ETF	53.62	53.67	53.56	53.66	67100.0
2020-10-09	AGNG	ETF	26.538	26.59	26.49	26.59	2800.0
2020-10-09	AGQ	ETF	46.4	48.72	46.3	48.7	2410400.0
2020-10-09	AGZ	ETF	120.88	120.89	120.7727	120.87	45146.0
2020-10-09	AGZD	ETF	23.43	23.48	23.42	23.42	5400.0
2020-10-09	AIA	ETF	74.44	74.88	74.23	74.84	184635.0
2020-10-09	AIEQ	ETF	32.0	32.24	32.0	32.18	10800.0
2020-10-09	AIQ	ETF	24.52	24.65	24.52	24.58	16153.0
2020-10-09	AIRR	ETF	28.14	28.173	27.905	27.955	6700.0
2020-10-09	AIVI	ETF	36.88	36.98	36.88	36.97	5400.0
2020-10-09	ALTL	ETF	25.6399	25.8195	25.6399	25.7309	2028.0
2020-10-09	ALTY	ETF	10.86	10.877	10.77	10.824	19100.0
2020-10-09	AMJ	ETF	11.84	11.95	11.62	11.65	842928.0
2020-10-09	AMLP	ETF	21.97	22.17	21.53	21.81	1693000.0
2020-10-09	AMNA	ETF	22.5	22.5	22.32	22.3291	1500.0
2020-10-09	AMND	ETF	23.68	23.68	23.4957	23.4957	403.0
2020-10-09	AMOM	ETF	36.67	36.86	36.66	36.86	1300.0
2020-10-09	AMUB	ETF	7.49	7.5	7.32	7.4111	27926.0
2020-10-09	AMZA	ETF	15.22	15.265	14.8	15.04	75300.0
2020-10-09	ANGL	ETF	30.14	30.19	30.08	30.15	1119100.0
2020-10-09	AOA	ETF	59.36	59.6	59.32	59.58	46000.0
2020-10-09	AOK	ETF	37.56	37.59	37.49	37.57	122479.0
2020-10-09	AOM	ETF	41.42	41.6	41.41	41.6	181509.0

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

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