PREVIEW / etf_daily / 2019-03-04

all etf daily files

  file:    by_date/etf_daily/2019/2019-03-04.parquet
  size:    67 KB
  rows:    1,756

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
2019-03-04	SPY	ETF	281.6	281.87	276.84	279.4	106494600.0
2019-03-04	QQQ	ETF	175.37	175.79	172.47	174.42	38063458.0
2019-03-04	IWM	ETF	158.54	158.78	155.59	156.81	23301800.0
2019-03-04	DIA	ETF	261.5	261.68	256.2	258.28	4823900.0
2019-03-04	GLD	ETF	121.56	121.85	121.18	121.56	10272600.0
2019-03-04	TLT	ETF	119.29	119.77	119.06	119.59	9808500.0
2019-03-04	AAAU	ETF	12.84	12.88	12.83	12.86	36600.0
2019-03-04	AADR	ETF	46.16	46.16	45.4	45.69	13200.0
2019-03-04	AAXJ	ETF	69.89	69.96	69.07	69.64	1490900.0
2019-03-04	ACES	ETF	27.15	27.15	26.806	26.989	7400.0
2019-03-04	ACSI	ETF	32.67	32.67	32.33	32.4075	1597.0
2019-03-04	ACTX	ETF	72.2756	79.6507	59.0005	60.1805	2095.0
2019-03-04	ACWF	ETF	29.3473	29.3473	28.9021	29.06	19539.0
2019-03-04	ACWI	ETF	71.69	71.71	70.67	71.2	3677900.0
2019-03-04	ACWV	ETF	87.84	88.0	86.85	87.36	177900.0
2019-03-04	ACWX	ETF	46.21	46.21	45.745	45.98	1675375.0
2019-03-04	ADRE	ETF	40.73	40.73	40.4157	40.6208	6698.0
2019-03-04	AFIF	ETF	10.02	10.03	10.0	10.02	10147.0
2019-03-04	AFK	ETF	21.93	22.0	21.61	21.7	7313.0
2019-03-04	AFTY	ETF	17.0	17.01	16.743	16.824	50900.0
2019-03-04	AGG	ETF	106.74	106.84	106.69	106.76	3837200.0
2019-03-04	AGGY	ETF	48.81	48.83	48.75	48.82	55500.0
2019-03-04	AGNG	ETF	21.476	21.529	21.476	21.529	300.0
2019-03-04	AGQ	ETF	24.55	24.64	24.44	24.55	213600.0
2019-03-04	AGZ	ETF	111.83	111.89	111.74	111.84	31351.0
2019-03-04	AGZD	ETF	23.875	23.905	23.845	23.875	21400.0
2019-03-04	AIA	ETF	61.14	61.14	60.39	60.8	40191.0
2019-03-04	AIEQ	ETF	26.0	26.05	25.55	25.78	73700.0
2019-03-04	AIQ	ETF	15.6	15.6	15.14	15.33	10941.0
2019-03-04	AIRR	ETF	25.79	25.9	25.483	25.59	17500.0
2019-03-04	AIVI	ETF	40.85	40.85	40.59	40.64	114300.0
2019-03-04	ALTY	ETF	15.0	15.0	14.779	14.779	8600.0
2019-03-04	AMJ	ETF	24.9	24.97	24.61	24.87	2196247.0
2019-03-04	AMLP	ETF	48.95	49.1	48.35	48.85	3228880.0
2019-03-04	AMUB	ETF	15.6325	15.6325	15.6325	15.6325	4.0
2019-03-04	AMZA	ETF	58.7	59.1	58.07	58.8	65960.0
2019-03-04	ANGL	ETF	28.58	28.62	28.43	28.47	278200.0
2019-03-04	AOA	ETF	53.15	53.18	52.62	52.86	51400.0
2019-03-04	AOK	ETF	34.02	34.02	33.9	33.96	43991.0
2019-03-04	AOM	ETF	37.6	37.6	37.3901	37.45	93918.0
2019-03-04	AOR	ETF	44.32	44.33	43.95	44.13	123142.0
2019-03-04	ARCM	ETF	100.0	100.0	100.0	100.0	100.0
2019-03-04	ARGT	ETF	27.73	27.88	27.38	27.66	143600.0
2019-03-04	ARKF	ETF	21.32	21.34	20.75	20.947	21200.0
2019-03-04	ARKG	ETF	32.72	32.72	31.129	31.79	204200.0
2019-03-04	ARKK	ETF	47.19	47.24	45.5	46.23	326800.0
2019-03-04	ARKQ	ETF	35.1	35.1	34.12	34.526	10800.0
2019-03-04	ARKW	ETF	52.03	52.19	50.16	50.89	250500.0
2019-03-04	ASEA	ETF	15.92	15.92	15.7	15.91	6300.0
2019-03-04	ASET	ETF	28.27	28.27	28.19	28.19	572.0

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

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