PREVIEW / etf_daily / 2009-09-10

all etf daily files

  file:    by_date/etf_daily/2009/2009-09-10.parquet
  size:    30 KB
  rows:    671

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-09-10	SPY	ETF	103.8	104.86	103.22	104.79	162902400.0
2009-09-10	QQQ	ETF	41.11	41.53	41.0	41.48	99289067.0
2009-09-10	IWM	ETF	58.67	59.56	58.2	59.4	39171200.0
2009-09-10	DIA	ETF	95.57	96.46	95.19	96.34	12244800.0
2009-09-10	GLD	ETF	97.03	98.03	96.88	97.7	12249000.0
2009-09-10	TLT	ETF	94.93	96.71	94.91	96.17	4417300.0
2009-09-10	AAXJ	ETF	51.62	52.05	51.11	52.05	746100.0
2009-09-10	ACWI	ETF	39.97	40.38	39.78	40.38	440000.0
2009-09-10	ACWX	ETF	39.09	39.56	38.95	39.53	27808.0
2009-09-10	ADRE	ETF	39.8	40.24	39.5	40.215	137232.0
2009-09-10	AFK	ETF	28.12	28.39	28.062	28.39	7969.0
2009-09-10	AGG	ETF	103.87	104.34	103.72	104.25	567200.0
2009-09-10	AGQ	ETF	111.5	116.66	111.0	116.48	252400.0
2009-09-10	AGZ	ETF	108.03	108.642	108.03	108.562	11044.0
2009-09-10	AIA	ETF	37.7	37.862	37.35	37.86	50662.0
2009-09-10	AIQ	ETF	26.85	27.95	26.6	27.95	52502.0
2009-09-10	AIS	ETF	1.25	1.25	1.15	1.1814	1100922.0
2009-09-10	AIVI	ETF	42.0	42.69	41.95	42.68	26400.0
2009-09-10	AMJ	ETF	24.13	24.37	24.09	24.34	198937.0
2009-09-10	AOA	ETF	28.41	28.41	28.41	28.41	200.0
2009-09-10	AOK	ETF	26.8	26.97	26.7	26.9661	7945.0
2009-09-10	AOM	ETF	27.79	27.79	27.4494	27.66	21377.0
2009-09-10	AOR	ETF	28.2	28.2	27.78	28.18	4682.0
2009-09-10	ARB	ETF	17.7	18.25	17.49	18.17	294007.0
2009-09-10	BAL	ETF	31.32	31.714	31.21	31.714	3050.0
2009-09-10	BBH	ETF	34.11	34.52	33.46	33.5867	192000.0
2009-09-10	BIL	ETF	91.74	91.74	91.7	91.72	148450.0
2009-09-10	BITS	ETF	21.28	21.28	20.2504	21.28	1020.0
2009-09-10	BIV	ETF	79.46	79.95	79.3	79.75	188900.0
2009-09-10	BJK	ETF	25.08	25.75	25.07	25.73	10800.0
2009-09-10	BKF	ETF	40.11	40.479	39.65	40.45	201874.0
2009-09-10	BLV	ETF	77.73	78.7	77.5	78.52	51900.0
2009-09-10	BMVP	ETF	11.787	11.927	11.73	11.904	8652.0
2009-09-10	BND	ETF	78.94	79.23	78.84	79.14	490200.0
2009-09-10	BNE	ETF	6.89	7.3	6.74	7.26	209978.0
2009-09-10	BOSS	ETF	19.75	19.75	19.75	19.75	100.0
2009-09-10	BRF	ETF	38.02	38.65	37.67	38.5999	132699.0
2009-09-10	BSV	ETF	79.92	80.02	79.7	79.95	683000.0
2009-09-10	BTF	ETF	57.699999999999996	57.9	57.699999999999996	57.85	4301.2
2009-09-10	BWX	ETF	28.77	28.85	28.67	28.725	464752.0
2009-09-10	BWZ	ETF	36.89	36.99	36.89	36.95	41915.0
2009-09-10	BZQ	ETF	6512.0	6512.0	6222.4	6222.4	13.25
2009-09-10	CEF	ETF	12.98	13.19	12.92	13.17	718300.0
2009-09-10	CEW	ETF	21.4	21.5	21.336	21.41	28721.0
2009-09-10	CGO	ETF	13.59	13.7392	13.52	13.72	19175.0
2009-09-10	CGW	ETF	17.55	17.7299	17.382	17.7299	73760.0
2009-09-10	CHB	ETF	0.48	0.5	0.45	0.47	1028066.0
2009-09-10	CHI	ETF	11.43	11.5	11.27	11.45	231502.0
2009-09-10	CHIC	ETF	17.44	17.44	17.43	17.44	532656.0
2009-09-10	CHW	ETF	7.54	7.54	7.36	7.5	204701.0

> showing 50 of 671 rows — these rows as CSV

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