PREVIEW / etf_daily / 2020-01-03

all etf daily files

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

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-03	SPY	ETF	321.16	323.64	321.1	322.41	77709700.0
2020-01-03	QQQ	ETF	213.29	215.47	213.28	214.18	27532657.0
2020-01-03	IWM	ETF	163.74	165.41	163.7	165.13	19295600.0
2020-01-03	DIA	ETF	285.34	287.11	285.18	286.32	3296700.0
2020-01-03	GLD	ETF	145.75	146.32	145.4	145.86	12272800.0
2020-01-03	TLT	ETF	138.27	139.16	137.88	139.12	12366000.0
2020-01-03	AAAU	ETF	15.45	15.49	15.42	15.45	53400.0
2020-01-03	AADR	ETF	54.36	54.78	54.31	54.57	10600.0
2020-01-03	AAXJ	ETF	73.81	74.16	73.62	73.72	947100.0
2020-01-03	ACES	ETF	34.2	34.42	34.15	34.291	12500.0
2020-01-03	ACIO	ETF	25.62	25.66	25.59	25.614	14800.0
2020-01-03	ACSI	ETF	35.265	35.44	35.265	35.3714	3047.0
2020-01-03	ACTX	ETF	13.5701	13.5701	13.5701	13.5701	37.0
2020-01-03	ACWF	ETF	31.1631	31.23	31.138	31.1734	4242.0
2020-01-03	ACWI	ETF	79.13	79.69	79.04	79.38	1686700.0
2020-01-03	ACWV	ETF	95.36	96.1	95.36	95.84	261800.0
2020-01-03	ACWX	ETF	49.05	49.3279	49.05	49.08	1486892.0
2020-01-03	ADME	ETF	30.5	30.56	30.5	30.535	5300.0
2020-01-03	ADRE	ETF	45.0	45.2	45.0	45.03	6601.0
2020-01-03	AESR	ETF	10.11	10.122	10.09	10.122	2700.0
2020-01-03	AFIF	ETF	9.77	9.78	9.75	9.765	12175.0
2020-01-03	AFK	ETF	20.4	20.4795	20.31	20.31	8868.0
2020-01-03	AFLG	ETF	20.46	20.46	20.46	20.46	100.0
2020-01-03	AFMC	ETF	20.335	20.335	20.335	20.335	100.0
2020-01-03	AFSM	ETF	20.419	20.419	20.419	20.419	100.0
2020-01-03	AFTY	ETF	17.54	17.54	17.509	17.509	1200.0
2020-01-03	AGG	ETF	112.89	113.05	112.78	113.01	3664300.0
2020-01-03	AGGY	ETF	52.44	52.55	52.4	52.55	229500.0
2020-01-03	AGNG	ETF	23.41	23.62	23.18	23.555	23700.0
2020-01-03	AGQ	ETF	32.55	32.67	32.11	32.2	528300.0
2020-01-03	AGZ	ETF	115.99	116.1	115.8935	116.05	18634.0
2020-01-03	AGZD	ETF	24.05	24.095	24.015	24.065	11200.0
2020-01-03	AIA	ETF	66.25	66.57	66.0906	66.21	631896.0
2020-01-03	AIEQ	ETF	28.44	28.68	28.31	28.56	38000.0
2020-01-03	AIQ	ETF	18.05	18.2476	18.05	18.19	9434.0
2020-01-03	AIRR	ETF	28.8	29.115	28.8	29.115	44500.0
2020-01-03	AIVI	ETF	42.63	42.74	42.53	42.53	5100.0
2020-01-03	ALTY	ETF	14.795	14.859	14.795	14.83	8100.0
2020-01-03	AMJ	ETF	22.27	22.28	21.76	22.23	1915688.0
2020-01-03	AMLP	ETF	43.5	43.5	42.85	43.5	6483520.0
2020-01-03	AMOM	ETF	26.0	26.021	26.0	26.021	1100.0
2020-01-03	AMUB	ETF	14.0136	14.0136	14.0136	14.0136	0.0
2020-01-03	AMZA	ETF	46.2	46.2	45.25	46.0	97250.0
2020-01-03	ANGL	ETF	29.91	29.98	29.88	29.97	633200.0
2020-01-03	AOA	ETF	57.92	58.26	57.89	58.11	105400.0
2020-01-03	AOK	ETF	36.31	36.4	36.14	36.38	69805.0
2020-01-03	AOM	ETF	40.17	40.28	40.13	40.26	150344.0
2020-01-03	AOR	ETF	47.82	48.01	47.82	47.94	137413.0
2020-01-03	ARGT	ETF	26.28	26.48	26.02	26.37	43000.0
2020-01-03	ARKF	ETF	24.21	24.419	24.15	24.3	21900.0

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

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