PREVIEW / etf_daily / 2019-12-12

all etf daily files

  file:    by_date/etf_daily/2019/2019-12-12.parquet
  size:    73 KB
  rows:    1,923

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-12-12	SPY	ETF	314.43	317.99	314.17	317.13	96389600.0
2019-12-12	QQQ	ETF	204.77	207.32	204.491	206.51	32704625.0
2019-12-12	IWM	ETF	162.75	165.1	162.25	163.96	24857000.0
2019-12-12	DIA	ETF	279.52	282.95	279.24	281.95	3768600.0
2019-12-12	GLD	ETF	139.78	139.85	137.88	138.43	8815100.0
2019-12-12	TLT	ETF	139.19	139.28	136.61	137.45	14857000.0
2019-12-12	AAAU	ETF	14.81	14.81	14.61	14.66	150700.0
2019-12-12	AADR	ETF	52.6	52.68	52.24	52.48	7600.0
2019-12-12	AAXJ	ETF	71.22	72.46	71.22	72.4	1333500.0
2019-12-12	ACES	ETF	32.52	32.627	32.397	32.589	7500.0
2019-12-12	ACIO	ETF	25.558	25.567	25.54	25.554	8400.0
2019-12-12	ACSI	ETF	35.13	35.4451	35.13	35.4451	3604.0
2019-12-12	ACTX	ETF	6.4901	8.2601	6.4901	7.0801	338.0
2019-12-12	ACWF	ETF	30.8	31.09	30.74	31.0454	45335.0
2019-12-12	ACWI	ETF	77.97	78.81	77.94	78.63	3291200.0
2019-12-12	ACWV	ETF	95.87	96.23	95.75	95.98	201400.0
2019-12-12	ACWX	ETF	48.54	49.0	48.51	48.99	2829995.0
2019-12-12	ADME	ETF	30.09	30.485	30.09	30.485	6600.0
2019-12-12	ADRE	ETF	42.96	43.5585	42.89	43.485	6574.0
2019-12-12	AFIF	ETF	9.7303	9.7397	9.7301	9.7301	685.0
2019-12-12	AFK	ETF	20.33	20.51	20.28	20.51	35771.0
2019-12-12	AFMC	ETF	20.304	20.319	20.304	20.319	100.0
2019-12-12	AFSM	ETF	20.521	20.521	20.511	20.511	100.0
2019-12-12	AFTY	ETF	17.3	17.726	17.3	17.676	6500.0
2019-12-12	AGG	ETF	112.79	112.79	112.22	112.36	5080100.0
2019-12-12	AGGY	ETF	52.37	52.37	52.121	52.21	198800.0
2019-12-12	AGNG	ETF	23.49	23.557	23.304	23.535	1700.0
2019-12-12	AGQ	ETF	28.98	29.02	27.97	28.6	267700.0
2019-12-12	AGZ	ETF	116.01	116.03	115.63	115.7116	21273.0
2019-12-12	AGZD	ETF	24.01	24.085	24.0	24.045	21400.0
2019-12-12	AIA	ETF	63.67	65.0	63.66	64.81	56728.0
2019-12-12	AIEQ	ETF	27.75	27.92	27.7	27.9	19800.0
2019-12-12	AIQ	ETF	17.25	17.38	17.25	17.36	8339.0
2019-12-12	AIRR	ETF	28.92	29.236	28.92	29.175	22900.0
2019-12-12	AIVI	ETF	42.29	42.45	42.19	42.45	8400.0
2019-12-12	ALTY	ETF	14.66	14.798	14.66	14.721	5400.0
2019-12-12	AMJ	ETF	21.0	21.36	20.97	21.15	3984520.0
2019-12-12	AMLP	ETF	41.0	41.65	40.9	41.25	7389620.0
2019-12-12	AMOM	ETF	26.951	26.951	26.951	26.951	100.0
2019-12-12	AMUB	ETF	13.3174	13.3174	13.3174	13.3174	10.0
2019-12-12	AMZA	ETF	42.8	43.95	42.8	43.6	57480.0
2019-12-12	ANGL	ETF	29.5	29.56	29.42	29.52	356300.0
2019-12-12	AOA	ETF	57.24	57.68	57.24	57.56	88000.0
2019-12-12	AOK	ETF	36.12	36.18	36.03	36.1549	60185.0
2019-12-12	AOM	ETF	40.0	40.1193	39.9578	40.05	177142.0
2019-12-12	AOR	ETF	47.39	47.6469	47.3834	47.62	81470.0
2019-12-12	ARGT	ETF	24.2	24.61	24.12	24.56	42900.0
2019-12-12	ARKF	ETF	23.61	23.81	23.562	23.69	4400.0
2019-12-12	ARKG	ETF	34.35	34.843	34.09	34.51	202800.0
2019-12-12	ARKK	ETF	49.05	49.55	48.83	49.4	147900.0

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

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