PREVIEW / etf_daily / 2020-01-29

all etf daily files

  file:    by_date/etf_daily/2020/2020-01-29.parquet
  size:    74 KB
  rows:    1,938

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-29	SPY	ETF	328.38	328.63	326.4	326.62	53888900.0
2020-01-29	QQQ	ETF	222.66	222.93	220.83	221.81	29063128.0
2020-01-29	IWM	ETF	165.1	165.56	163.9	163.93	14944400.0
2020-01-29	DIA	ETF	288.99	289.28	287.21	287.29	2126300.0
2020-01-29	GLD	ETF	147.7	148.56	147.61	148.46	5013100.0
2020-01-29	TLT	ETF	143.44	144.7	143.43	144.56	9566800.0
2020-01-29	AAAU	ETF	15.65	15.74	15.64	15.73	29700.0
2020-01-29	AADR	ETF	54.74	54.95	54.66	54.86	5500.0
2020-01-29	AAXJ	ETF	71.71	71.78	71.36	71.53	945600.0
2020-01-29	ABEQ	ETF	24.73	24.75	24.675	24.675	19800.0
2020-01-29	ACES	ETF	38.46	38.46	36.502	36.63	89700.0
2020-01-29	ACIO	ETF	25.39	25.39	25.315	25.315	18500.0
2020-01-29	ACSI	ETF	36.16	36.2607	36.1121	36.1121	3755.0
2020-01-29	ACTX	ETF	10.0301	10.9151	7.7704	9.1923	589.0
2020-01-29	ACWF	ETF	31.19	31.24	31.1262	31.1262	4826.0
2020-01-29	ACWI	ETF	79.83	79.94	79.47	79.51	1050700.0
2020-01-29	ACWV	ETF	98.05	98.08	97.7	97.85	136700.0
2020-01-29	ACWX	ETF	48.56	48.59	48.363	48.42	937049.0
2020-01-29	ADME	ETF	30.99	30.99	30.86	30.86	6300.0
2020-01-29	ADRE	ETF	43.33	43.33	43.055	43.17	2661.0
2020-01-29	AESR	ETF	10.28	10.32	10.28	10.3	15500.0
2020-01-29	AFIF	ETF	9.7433	9.7433	9.72	9.74	3675.0
2020-01-29	AFK	ETF	19.7	19.7	19.5701	19.62	3504.0
2020-01-29	AFTY	ETF	16.0	16.13	15.92	15.92	8200.0
2020-01-29	AGG	ETF	114.13	114.35	114.11	114.3	2890200.0
2020-01-29	AGGY	ETF	53.01	53.1	52.99	53.09	171200.0
2020-01-29	AGNG	ETF	23.85	24.084	23.85	24.08	3500.0
2020-01-29	AGQ	ETF	29.9	30.42	29.87	30.34	209000.0
2020-01-29	AGZ	ETF	116.99	117.18	116.9386	117.1	22013.0
2020-01-29	AGZD	ETF	24.0	24.055	24.0	24.03	11800.0
2020-01-29	AIA	ETF	65.31	65.39	65.0222	65.079	74410.0
2020-01-29	AIEQ	ETF	29.28	29.289	29.072	29.16	8600.0
2020-01-29	AIQ	ETF	18.91	18.92	18.73	18.83	31123.0
2020-01-29	AIRR	ETF	28.51	28.6	28.41	28.465	6400.0
2020-01-29	AIVI	ETF	41.9	42.0	41.89	41.91	3600.0
2020-01-29	ALTY	ETF	14.92	14.985	14.92	14.955	8300.0
2020-01-29	AMJ	ETF	21.13	21.28	20.985	21.01	3623859.0
2020-01-29	AMLP	ETF	41.2	41.5	40.9	40.95	3128940.0
2020-01-29	AMOM	ETF	26.652	26.652	26.652	26.652	100.0
2020-01-29	AMUB	ETF	13.2389	13.2389	13.2389	13.2389	156.0
2020-01-29	AMZA	ETF	41.6	42.08	41.25	41.3	68800.0
2020-01-29	ANGL	ETF	30.05	30.1	30.0	30.0	449400.0
2020-01-29	AOA	ETF	58.27	58.4	58.12	58.12	34200.0
2020-01-29	AOK	ETF	36.67	36.74	36.54	36.66	71465.0
2020-01-29	AOM	ETF	40.43	40.59	40.39	40.44	156594.0
2020-01-29	AOR	ETF	48.2	48.2499	48.09	48.12	242464.0
2020-01-29	ARGT	ETF	26.14	26.32	25.85	25.85	7700.0
2020-01-29	ARKF	ETF	25.73	25.795	25.559	25.681	27300.0
2020-01-29	ARKG	ETF	34.15	34.279	33.907	34.04	78600.0
2020-01-29	ARKK	ETF	53.04	53.26	52.68	52.85	210000.0

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

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