PREVIEW / etf_daily / 2018-10-17

all etf daily files

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

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-17	SPY	ETF	280.44	281.15	277.56	280.45	110626000.0
2018-10-17	QQQ	ETF	178.14	178.2585	175.47	177.29	66987639.0
2018-10-17	IWM	ETF	158.18	158.22	155.89	157.96	24140100.0
2018-10-17	DIA	ETF	256.92	258.02	254.67	256.97	6822400.0
2018-10-17	GLD	ETF	115.89	116.33	115.68	115.79	7078600.0
2018-10-17	TLT	ETF	114.66	114.79	113.98	114.0	5880700.0
2018-10-17	AAAU	ETF	12.26	12.28	12.22	12.22	7500.0
2018-10-17	AADR	ETF	50.01	50.06	49.53	49.91	13900.0
2018-10-17	AAXJ	ETF	65.15	65.15	64.44	64.71	604200.0
2018-10-17	ACES	ETF	24.61	24.61	24.61	24.61	400.0
2018-10-17	ACSI	ETF	33.009	33.1899	32.8972	33.1853	3329.0
2018-10-17	ACTX	ETF	149.2713	156.9414	118.5911	135.7012	5290.0
2018-10-17	ACWF	ETF	29.04	29.2075	28.88	29.078	37224.0
2018-10-17	ACWI	ETF	71.15	71.26	70.5	71.07	4446300.0
2018-10-17	ACWV	ETF	85.31	85.49	84.84	85.29	255000.0
2018-10-17	ACWX	ETF	45.29	45.35	44.97	45.19	2187821.0
2018-10-17	ADRE	ETF	39.39	39.39	38.8265	38.895	3444.0
2018-10-17	AFIF	ETF	10.0456	10.1	10.03	10.04	386940.0
2018-10-17	AFK	ETF	21.32	21.32	20.9	20.99	1980.0
2018-10-17	AFTY	ETF	14.26	14.31	14.12	14.17	8000.0
2018-10-17	AGG	ETF	104.71	104.77	104.52	104.53	2844200.0
2018-10-17	AGGY	ETF	47.89	47.899	47.788	47.8	27100.0
2018-10-17	AGNG	ETF	21.17	21.17	21.0	21.0	1900.0
2018-10-17	AGQ	ETF	24.12	24.34	23.92	23.97	52300.0
2018-10-17	AGZ	ETF	110.331	110.3593	110.21	110.2893	9147.0
2018-10-17	AGZD	ETF	23.915	23.98	23.905	23.925	7000.0
2018-10-17	AIA	ETF	57.56	57.64	56.935	57.26	51029.0
2018-10-17	AIEQ	ETF	28.2	28.2	27.75	28.08	82400.0
2018-10-17	AIQ	ETF	14.96	14.96	14.74	14.86	54825.0
2018-10-17	AIRR	ETF	26.05	26.131	25.82	26.07	13200.0
2018-10-17	AIVI	ETF	40.81	40.86	40.6	40.69	3700.0
2018-10-17	ALTY	ETF	14.77	14.82	14.65	14.65	3700.0
2018-10-17	AMJ	ETF	27.6	27.6	27.16	27.19	2500045.0
2018-10-17	AMLP	ETF	53.5	53.75	52.75	52.75	3201720.0
2018-10-17	AMZA	ETF	74.6	74.6	73.2	73.3	69140.0
2018-10-17	ANGL	ETF	28.73	28.77	28.64	28.64	152000.0
2018-10-17	AOA	ETF	52.54	52.65	52.24	52.41	162600.0
2018-10-17	AOK	ETF	33.46	33.5299	33.4	33.44	58551.0
2018-10-17	AOM	ETF	36.88	36.93	36.78	36.83	109311.0
2018-10-17	AOR	ETF	43.69	43.79	43.4206	43.6	98467.0
2018-10-17	ARGT	ETF	25.35	25.4	25.11	25.37	12500.0
2018-10-17	ARKG	ETF	30.17	30.36	29.506	30.14	68600.0
2018-10-17	ARKK	ETF	43.89	44.0	42.7	43.37	296500.0
2018-10-17	ARKQ	ETF	33.43	33.43	32.885	33.19	40700.0
2018-10-17	ARKW	ETF	54.41	54.41	52.78	53.36	76200.0
2018-10-17	ARVR	ETF	20.38	20.38	20.38	20.38	168.0
2018-10-17	ASEA	ETF	15.62	15.63	15.56	15.58	10800.0
2018-10-17	ASET	ETF	26.9801	27.0361	26.98	26.98	1743.0
2018-10-17	ASHR	ETF	22.91	22.91	22.65	22.69	2391700.0
2018-10-17	ASHS	ETF	22.01	22.01	21.76	21.78	7900.0

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

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