PREVIEW / etf_daily / 2019-09-03

all etf daily files

  file:    by_date/etf_daily/2019/2019-09-03.parquet
  size:    71 KB
  rows:    1,842

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-09-03	SPY	ETF	290.57	291.58	289.27	290.74	69101400.0
2019-09-03	QQQ	ETF	186.26	187.18	185.03	185.65	28026617.0
2019-09-03	IWM	ETF	147.45	148.32	146.0	146.66	20688000.0
2019-09-03	DIA	ETF	262.07	262.2	260.03	261.42	3082900.0
2019-09-03	GLD	ETF	144.96	146.13	144.74	145.75	15615200.0
2019-09-03	TLT	ETF	147.09	148.67	146.57	147.21	15660800.0
2019-09-03	AAAU	ETF	15.35	15.47	15.34	15.43	98900.0
2019-09-03	AADR	ETF	49.2	49.42	48.99	49.07	3400.0
2019-09-03	AAXJ	ETF	64.52	64.88	64.52	64.72	1461000.0
2019-09-03	ACES	ETF	30.44	30.55	30.23	30.265	10700.0
2019-09-03	ACIO	ETF	24.34	24.38	24.34	24.358	7900.0
2019-09-03	ACSI	ETF	33.1	33.1516	33.03	33.1516	1238.0
2019-09-03	ACTX	ETF	20.4466	23.0102	20.2431	23.0102	192.0
2019-09-03	ACWF	ETF	28.16	28.26	28.116	28.1911	3159.0
2019-09-03	ACWI	ETF	71.65	71.86	71.44	71.74	2548800.0
2019-09-03	ACWV	ETF	93.18	93.71	92.92	93.64	325700.0
2019-09-03	ACWX	ETF	44.53	44.7	44.495	44.7	800561.0
2019-09-03	ADRE	ETF	37.75	37.75	37.5201	37.575	2994.0
2019-09-03	AFIF	ETF	9.67	9.6899	9.67	9.6743	2383.0
2019-09-03	AFK	ETF	19.97	20.1743	19.97	20.135	2838.0
2019-09-03	AFTY	ETF	16.657	16.721	16.657	16.721	1100.0
2019-09-03	AGG	ETF	113.86	114.12	113.69	113.84	6197400.0
2019-09-03	AGGY	ETF	52.73	52.88	52.665	52.77	474100.0
2019-09-03	AGNG	ETF	21.21	21.51	21.21	21.29	16000.0
2019-09-03	AGQ	ETF	36.51	37.92	36.26	37.8	1052300.0
2019-09-03	AGZ	ETF	117.08	117.3129	117.005	117.23	41507.0
2019-09-03	AGZD	ETF	23.85	23.85	23.8	23.8	7800.0
2019-09-03	AIA	ETF	56.2	56.38	56.13	56.32	34239.0
2019-09-03	AIEQ	ETF	25.97	26.114	25.858	25.955	25500.0
2019-09-03	AIQ	ETF	16.03	16.03	15.844	15.9021	4999.0
2019-09-03	AIRR	ETF	24.959	24.959	24.53	24.67	2800.0
2019-09-03	AIVI	ETF	39.46	39.75	39.46	39.75	78300.0
2019-09-03	ALTY	ETF	14.67	14.672	14.579	14.59	5000.0
2019-09-03	AMJ	ETF	22.98	23.02	22.79	22.99	751514.0
2019-09-03	AMLP	ETF	45.0	45.2	44.8	45.15	1839100.0
2019-09-03	AMOM	ETF	26.45	26.468	26.45	26.468	500.0
2019-09-03	AMUB	ETF	14.4589	14.4589	14.4589	14.4589	0.0
2019-09-03	AMZA	ETF	48.0	48.3	47.53	48.0	61790.0
2019-09-03	ANGL	ETF	29.26	29.31	29.08	29.12	264800.0
2019-09-03	AOA	ETF	53.68	53.79	53.59	53.77	139900.0
2019-09-03	AOK	ETF	35.55	35.6	35.49	35.5789	85780.0
2019-09-03	AOM	ETF	38.93	39.0	38.8957	38.94	113628.0
2019-09-03	AOR	ETF	45.26	45.39	45.26	45.39	388073.0
2019-09-03	ARCM	ETF	100.0	100.0	99.99	99.99	800.0
2019-09-03	ARGT	ETF	22.6	22.6	21.78	21.88	102600.0
2019-09-03	ARKF	ETF	21.58	21.69	21.454	21.517	7700.0
2019-09-03	ARKG	ETF	31.15	31.38	30.28	30.42	99500.0
2019-09-03	ARKK	ETF	43.95	44.46	43.08	43.27	308800.0
2019-09-03	ARKQ	ETF	31.0	31.14	30.82	30.89	12000.0
2019-09-03	ARKW	ETF	49.47	50.108	49.12	49.29	199000.0

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

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