PREVIEW / etf_daily / 2009-10-16

all etf daily files

  file:    by_date/etf_daily/2009/2009-10-16.parquet
  size:    30 KB
  rows:    673

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
2009-10-16	SPY	ETF	108.8	109.27	108.23	108.89	192069400.0
2009-10-16	QQQ	ETF	42.92	42.99	42.48	42.78	111859601.0
2009-10-16	IWM	ETF	61.89	62.02	61.14	61.68	49031800.0
2009-10-16	DIA	ETF	99.74	100.21	99.37	99.99	13185400.0
2009-10-16	GLD	ETF	102.7	103.68	102.53	103.18	14320600.0
2009-10-16	TLT	ETF	95.19	95.53	94.73	95.45	3716800.0
2009-10-16	AAXJ	ETF	54.15	54.29	53.58	53.86	457000.0
2009-10-16	ACWI	ETF	41.93	42.1	41.7	42.03	80600.0
2009-10-16	ACWX	ETF	41.11	41.229	40.8	41.09	1660240.0
2009-10-16	ADRE	ETF	43.6	43.76	43.198	43.63	188529.0
2009-10-16	AFK	ETF	30.18	30.58	30.18	30.4	22119.0
2009-10-16	AGG	ETF	104.18	104.33	104.08	104.24	458700.0
2009-10-16	AGQ	ETF	123.38	126.4	122.82	125.12	147900.0
2009-10-16	AGZ	ETF	108.62	108.62	108.24	108.26	9273.0
2009-10-16	AIA	ETF	38.88	38.94	38.59	38.82	17038.0
2009-10-16	AIQ	ETF	30.95	31.3	30.5	31.05	35664.0
2009-10-16	AIS	ETF	1.17	1.31	1.13	1.24	4515327.0
2009-10-16	AIVI	ETF	43.54	43.76	43.25	43.61	17700.0
2009-10-16	AMJ	ETF	26.19	26.3	26.04	26.26	184910.0
2009-10-16	AOA	ETF	29.65	29.68	29.53	29.68	9000.0
2009-10-16	AOK	ETF	27.1901	27.28	27.1901	27.28	15044.0
2009-10-16	AOM	ETF	27.98	28.06	27.9764	28.06	1682.0
2009-10-16	AOR	ETF	28.83	28.83	28.6799	28.81	6731.0
2009-10-16	ARB	ETF	24.91	25.14	23.84	24.01	446699.0
2009-10-16	BAL	ETF	34.96	35.6599	34.96	35.55	33986.0
2009-10-16	BBH	ETF	34.3333	34.3333	33.7433	33.9667	201000.0
2009-10-16	BIL	ETF	91.7	91.74	91.7	91.74	88950.0
2009-10-16	BITS	ETF	26.08	26.4	25.72	25.72	3396.0
2009-10-16	BIV	ETF	79.59	79.97	79.59	79.83	85600.0
2009-10-16	BJK	ETF	26.49	26.49	25.36	26.26	16700.0
2009-10-16	BKF	ETF	45.45	45.61	44.76	45.38	281735.0
2009-10-16	BLV	ETF	77.73	77.85	77.37	77.85	121100.0
2009-10-16	BMVP	ETF	12.35	12.38	12.28	12.35	14588.0
2009-10-16	BND	ETF	79.07	79.1	78.9	79.05	858500.0
2009-10-16	BNE	ETF	8.1	8.1	7.89	7.95	150081.0
2009-10-16	BRF	ETF	45.5	45.92	45.2	45.64	636035.0
2009-10-16	BSV	ETF	79.86	79.91	79.72	79.87	268400.0
2009-10-16	BTF	ETF	61.39999999999999	61.5	61.1	61.3	3121.0
2009-10-16	BWX	ETF	29.42	29.445	29.275	29.34	379232.0
2009-10-16	BWZ	ETF	37.55	37.66	37.3718	37.6	62337.0
2009-10-16	BZQ	ETF	4283.2	4302.4	4187.2	4224.0	39.5
2009-10-16	CEF	ETF	13.4	13.71	13.4	13.69	860400.0
2009-10-16	CEW	ETF	22.11	22.55	22.06	22.14	104241.0
2009-10-16	CGO	ETF	14.17	14.42	14.15	14.26	34604.0
2009-10-16	CGW	ETF	17.94	17.9764	17.75	17.87	89600.0
2009-10-16	CHB	ETF	0.36	0.36	0.32	0.32	2052099.0
2009-10-16	CHI	ETF	11.73	11.91	11.69	11.85	209495.0
2009-10-16	CHW	ETF	7.82	7.91	7.79	7.91	152244.0
2009-10-16	CHY	ETF	11.58	11.6	11.501	11.54	243457.0
2009-10-16	CMF	ETF	53.43	53.64	52.83	52.83	20314.0

> showing 50 of 673 rows — these rows as CSV

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