PREVIEW / etf_daily / 2018-10-19

all etf daily files

  file:    by_date/etf_daily/2018/2018-10-19.parquet
  size:    63 KB
  rows:    1,622

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
2018-10-19	SPY	ETF	277.13	279.3	275.47	276.25	139901600.0
2018-10-19	QQQ	ETF	174.39	176.07	172.39	173.02	82923733.0
2018-10-19	IWM	ETF	155.47	156.36	152.74	153.36	34214200.0
2018-10-19	DIA	ETF	254.23	255.98	253.34	254.32	6618300.0
2018-10-19	GLD	ETF	116.23	116.24	115.96	116.01	7453900.0
2018-10-19	TLT	ETF	113.85	113.95	113.41	113.71	10892400.0
2018-10-19	AAAU	ETF	12.27	12.28	12.26	12.26	3800.0
2018-10-19	AADR	ETF	49.23	49.5	48.79	48.89	33400.0
2018-10-19	AAXJ	ETF	64.32	64.63	63.8	63.96	840500.0
2018-10-19	ACES	ETF	24.311	24.311	24.311	24.311	200.0
2018-10-19	ACSI	ETF	32.9764	32.9764	32.9764	32.9764	652.0
2018-10-19	ACTX	ETF	141.8963	144.5513	129.8012	131.5712	3288.0
2018-10-19	ACWF	ETF	28.7601	28.7601	28.54	28.54	24204.0
2018-10-19	ACWI	ETF	70.24	70.71	69.91	70.07	3358200.0
2018-10-19	ACWV	ETF	85.12	85.53	85.03	85.1	55900.0
2018-10-19	ACWX	ETF	44.7	44.93	44.59	44.63	757133.0
2018-10-19	ADRE	ETF	38.42	38.5181	37.85	37.85	5421.0
2018-10-19	AFIF	ETF	10.0644	10.07	10.02	10.02	12296.0
2018-10-19	AFK	ETF	20.5073	20.705	20.5073	20.617	3428.0
2018-10-19	AFTY	ETF	14.39	14.39	14.29	14.33	11200.0
2018-10-19	AGG	ETF	104.47	104.55	104.34	104.37	2985800.0
2018-10-19	AGGY	ETF	47.75	47.75	47.65	47.7	43100.0
2018-10-19	AGNG	ETF	21.09	21.09	20.651	20.738	700.0
2018-10-19	AGQ	ETF	24.2	24.27	23.93	23.97	128700.0
2018-10-19	AGZ	ETF	110.19	110.2499	110.0945	110.0945	8545.0
2018-10-19	AGZD	ETF	23.89	23.97	23.89	23.945	8600.0
2018-10-19	AIA	ETF	57.0	57.2799	56.59	56.81	147134.0
2018-10-19	AIEQ	ETF	27.72	27.81	27.25	27.36	197800.0
2018-10-19	AIQ	ETF	14.49	14.5175	14.2552	14.31	3566.0
2018-10-19	AIRR	ETF	25.62	25.81	25.308	25.33	49900.0
2018-10-19	AIVI	ETF	40.5	40.69	40.5	40.63	4100.0
2018-10-19	ALTY	ETF	14.57	14.685	14.57	14.66	3100.0
2018-10-19	AMJ	ETF	27.02	27.42	26.99	27.15	1306065.0
2018-10-19	AMLP	ETF	52.95	53.35	52.5	52.5	3445260.0
2018-10-19	AMZA	ETF	73.1	73.44	72.2	72.5	84520.0
2018-10-19	ANGL	ETF	28.63	28.64	28.54	28.58	169400.0
2018-10-19	AOA	ETF	51.97	52.22	51.8	51.87	34100.0
2018-10-19	AOK	ETF	33.3	33.3892	33.2339	33.25	43985.0
2018-10-19	AOM	ETF	36.67	36.7599	36.55	36.64	66688.0
2018-10-19	AOR	ETF	43.22	43.45	43.15	43.16	133706.0
2018-10-19	ARGT	ETF	24.84	25.06	24.83	24.88	25100.0
2018-10-19	ARKG	ETF	29.49	29.9	28.6	28.64	111100.0
2018-10-19	ARKK	ETF	42.31	42.82	41.219	41.32	251400.0
2018-10-19	ARKQ	ETF	32.55	32.624	31.806	31.82	19600.0
2018-10-19	ARKW	ETF	52.34	52.88	50.922	51.0	71500.0
2018-10-19	ARVR	ETF	19.0	19.0	19.0	19.0	310.0
2018-10-19	ASEA	ETF	15.3	15.54	15.02	15.24	782700.0
2018-10-19	ASET	ETF	27.1	27.1	26.97	27.0485	1255.0
2018-10-19	ASHR	ETF	22.84	23.02	22.75	22.86	3531500.0
2018-10-19	ASHS	ETF	21.74	21.83	21.68	21.7	14900.0

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

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