PREVIEW / etf_daily / 2020-01-30

all etf daily files

  file:    by_date/etf_daily/2020/2020-01-30.parquet
  size:    75 KB
  rows:    1,948

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-01-30	SPY	ETF	324.36	327.91	323.54	327.68	75491800.0
2020-01-30	QQQ	ETF	220.37	222.7	219.6891	222.6	39568093.0
2020-01-30	IWM	ETF	162.84	164.14	161.93	163.93	21889700.0
2020-01-30	DIA	ETF	285.67	288.77	284.85	288.54	3433200.0
2020-01-30	GLD	ETF	148.69	149.31	148.01	148.47	9119500.0
2020-01-30	TLT	ETF	144.9	145.67	144.29	144.58	14711800.0
2020-01-30	AAAU	ETF	15.76	15.81	15.7	15.74	87200.0
2020-01-30	AADR	ETF	54.41	54.52	53.94	54.22	54900.0
2020-01-30	AAXJ	ETF	69.88	70.45	69.52	70.37	1646200.0
2020-01-30	ABEQ	ETF	24.57	24.741	24.57	24.741	2900.0
2020-01-30	ACES	ETF	36.658	36.91	36.62	36.91	18300.0
2020-01-30	ACIO	ETF	25.223	25.223	25.223	25.223	100.0
2020-01-30	ACSI	ETF	35.897	36.1973	35.897	36.1973	772.0
2020-01-30	ACTX	ETF	10.6201	10.6201	9.1923	9.1923	21.0
2020-01-30	ACWF	ETF	30.76	31.0738	30.76	31.0738	6050.0
2020-01-30	ACWI	ETF	78.9	79.61	78.64	79.51	4115400.0
2020-01-30	ACWV	ETF	97.25	98.14	97.02	98.1	209400.0
2020-01-30	ACWX	ETF	47.89	48.25	47.731	48.23	1485501.0
2020-01-30	ADME	ETF	30.69	30.97	30.69	30.97	7900.0
2020-01-30	ADRE	ETF	42.31	42.4551	42.0001	42.455	10861.0
2020-01-30	AESR	ETF	10.16	10.259	10.16	10.259	310900.0
2020-01-30	AFIF	ETF	9.7497	9.7497	9.745	9.745	1403.0
2020-01-30	AFK	ETF	19.56	19.6799	19.56	19.62	9891.0
2020-01-30	AFLG	ETF	20.65	20.747	20.6	20.747	1100.0
2020-01-30	AFSM	ETF	20.204	20.204	20.204	20.204	100.0
2020-01-30	AFTY	ETF	15.5	15.7	15.5	15.67	16900.0
2020-01-30	AGG	ETF	114.28	114.54	114.24	114.31	6885600.0
2020-01-30	AGGY	ETF	53.2	53.21	53.064	53.11	192000.0
2020-01-30	AGNG	ETF	23.79	23.86	23.621	23.636	3600.0
2020-01-30	AGQ	ETF	31.53	31.99	31.08	31.4	544200.0
2020-01-30	AGZ	ETF	117.32	117.32	117.14	117.14	20193.0
2020-01-30	AGZD	ETF	23.855	23.995	23.855	23.995	24000.0
2020-01-30	AIA	ETF	63.42	63.97	63.0501	63.89	64531.0
2020-01-30	AIEQ	ETF	28.92	29.12	28.76	29.11	29200.0
2020-01-30	AIQ	ETF	18.66	18.72	18.48	18.72	38633.0
2020-01-30	AIRR	ETF	28.1	28.499	28.1	28.499	13800.0
2020-01-30	AIVI	ETF	41.62	41.87	41.54	41.87	4400.0
2020-01-30	ALTY	ETF	14.925	14.933	14.88	14.915	8100.0
2020-01-30	AMJ	ETF	20.9	20.945	20.62	20.89	3615247.0
2020-01-30	AMLP	ETF	40.75	40.8	40.2	40.6	4795900.0
2020-01-30	AMOM	ETF	26.881	26.881	26.881	26.881	100.0
2020-01-30	AMUB	ETF	13.0599	13.143	13.0	13.143	640.0
2020-01-30	AMZA	ETF	41.1	41.2	40.3	40.8	129770.0
2020-01-30	ANGL	ETF	29.89	30.11	29.84	30.06	371800.0
2020-01-30	AOA	ETF	57.7	58.21	57.65	58.12	36400.0
2020-01-30	AOK	ETF	36.62	36.65	36.52	36.64	66699.0
2020-01-30	AOM	ETF	40.41	40.5	40.3148	40.49	162617.0
2020-01-30	AOR	ETF	47.89	48.09	47.7719	48.08	210506.0
2020-01-30	ARGT	ETF	25.47	25.97	25.47	25.97	17500.0
2020-01-30	ARKF	ETF	25.35	25.657	25.261	25.657	25400.0

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

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