PREVIEW / etf_daily / 2009-08-25

all etf daily files

  file:    by_date/etf_daily/2009/2009-08-25.parquet
  size:    30 KB
  rows:    672

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-08-25	SPY	ETF	103.37	104.26	102.94	103.16	215310600.0
2009-08-25	QQQ	ETF	40.34	40.76	40.25	40.37	92900338.0
2009-08-25	IWM	ETF	58.4	59.07	58.2	58.38	30197300.0
2009-08-25	DIA	ETF	95.45	96.82	95.28	95.48	14622300.0
2009-08-25	GLD	ETF	93.4	93.46	92.49	92.76	8280500.0
2009-08-25	TLT	ETF	95.37	96.09	94.91	96.01	3359700.0
2009-08-25	AAXJ	ETF	49.8	49.92	49.35	49.6	99900.0
2009-08-25	ACWI	ETF	39.5	39.66	39.24	39.31	137000.0
2009-08-25	ACWX	ETF	38.41	38.63	38.2348	38.26	40894.0
2009-08-25	ADRE	ETF	39.13	39.388	38.67	38.72	96904.0
2009-08-25	AFK	ETF	28.14	28.17	28.0201	28.0215	8650.0
2009-08-25	AGG	ETF	103.22	103.7	103.22	103.59	477400.0
2009-08-25	AGQ	ETF	87.02	88.18	85.66	86.48	85150.0
2009-08-25	AGZ	ETF	107.85	107.85	107.3401	107.68	10903.0
2009-08-25	AIA	ETF	36.44	36.44	35.98	36.05	127820.0
2009-08-25	AIQ	ETF	26.15	27.1	25.95	27.0	149571.0
2009-08-25	AIS	ETF	0.989	1.0	0.95	0.969	308097.0
2009-08-25	AIVI	ETF	40.94	41.3	40.88	41.01	38900.0
2009-08-25	AMJ	ETF	24.69	24.7	24.42	24.45	176488.0
2009-08-25	AOA	ETF	28.37	28.37	28.02	28.02	13700.0
2009-08-25	AOK	ETF	26.86	26.86	26.52	26.75	14153.0
2009-08-25	AOM	ETF	27.2126	27.34	27.2126	27.334	2320.0
2009-08-25	AOR	ETF	27.7594	27.76	27.636	27.69	12718.0
2009-08-25	ARB	ETF	17.67	18.24	17.55	18.1	510907.0
2009-08-25	BAL	ETF	30.6846	30.6846	30.06	30.06	1400.0
2009-08-25	BBH	ETF	33.5033	34.01	33.4867	33.6133	357000.0
2009-08-25	BIL	ETF	91.7	91.72	91.7	91.7	398550.0
2009-08-25	BITS	ETF	21.04	21.56	20.68	21.32	789.0
2009-08-25	BIV	ETF	79.02	79.25	78.82	79.2	158300.0
2009-08-25	BJK	ETF	23.96	23.96	23.12	23.87	39500.0
2009-08-25	BKF	ETF	39.23	39.42	38.72	38.81	177791.0
2009-08-25	BLV	ETF	77.49	78.04	77.29	78.02	14100.0
2009-08-25	BMVP	ETF	11.84	11.93	11.84	11.85	9484.0
2009-08-25	BND	ETF	78.6	78.71	78.38	78.7	554900.0
2009-08-25	BNE	ETF	6.2	6.29	6.06	6.19	199209.0
2009-08-25	BOSS	ETF	19.81	20.01	19.81	20.01	100.0
2009-08-25	BRF	ETF	37.46	37.576	36.54	36.608	147856.0
2009-08-25	BSV	ETF	79.39	79.81	79.39	79.69	483700.0
2009-08-25	BTF	ETF	58.2	58.8	57.4	58.4	6949.200000000001
2009-08-25	BWX	ETF	28.435	28.435	28.225	28.275	349446.0
2009-08-25	BWZ	ETF	36.2196	36.28	36.2196	36.28	14282.0
2009-08-25	BZQ	ETF	6702.4	6846.4	6702.4	6840.0	5.0
2009-08-25	CEF	ETF	12.1	12.15	11.97	12.02	696300.0
2009-08-25	CEW	ETF	21.4	21.46	21.31	21.34	26893.0
2009-08-25	CGO	ETF	13.31	13.5	13.31	13.408	25436.0
2009-08-25	CGW	ETF	17.34	17.34	17.0	17.077	138671.0
2009-08-25	CHB	ETF	0.51	0.51	0.48	0.49	1341845.0
2009-08-25	CHI	ETF	11.31	11.4815	11.18	11.43	248302.0
2009-08-25	CHIC	ETF	17.37	17.39	17.36	17.37	5888881.0
2009-08-25	CHW	ETF	7.31	7.42	7.28	7.3101	177821.0

> showing 50 of 672 rows — these rows as CSV

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