PREVIEW / etf_daily / 2009-09-04

all etf daily files

  file:    by_date/etf_daily/2009/2009-09-04.parquet
  size:    29 KB
  rows:    669

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-04	SPY	ETF	100.85	102.09	100.55	102.06	142687900.0
2009-09-04	QQQ	ETF	39.58	40.38	39.52	40.36	74866546.0
2009-09-04	IWM	ETF	56.19	57.11	55.87	57.05	37229900.0
2009-09-04	DIA	ETF	93.57	94.57	93.3	94.45	8118600.0
2009-09-04	GLD	ETF	97.14	97.83	96.0	97.53	14911000.0
2009-09-04	TLT	ETF	96.44	96.6	95.06	95.21	3643000.0
2009-09-04	AAXJ	ETF	49.79	50.11	49.41	50.11	44400.0
2009-09-04	ACWI	ETF	38.56	38.99	38.39	38.92	29700.0
2009-09-04	ACWX	ETF	37.61	38.07	37.328	37.986	34161.0
2009-09-04	ADRE	ETF	38.2	38.778	38.03	38.74	167550.0
2009-09-04	AFK	ETF	27.6	27.7399	27.504	27.7399	6360.0
2009-09-04	AGG	ETF	103.85	103.96	103.59	103.67	542300.0
2009-09-04	AGQ	ETF	107.64	112.44	105.44	110.9	359700.0
2009-09-04	AGZ	ETF	107.965	108.15	107.705	107.99	12098.0
2009-09-04	AIA	ETF	36.39	36.74	36.27	36.74	7661.0
2009-09-04	AIQ	ETF	25.95	26.55	25.75	26.25	98996.0
2009-09-04	AIS	ETF	0.99	1.14	0.99	1.05	5148888.0
2009-09-04	AIVI	ETF	39.75	40.39	39.6	40.24	19500.0
2009-09-04	AMJ	ETF	23.59	23.81	23.4374	23.81	352799.0
2009-09-04	AOA	ETF	27.6	27.84	27.6	27.84	900.0
2009-09-04	AOK	ETF	26.79	26.79	26.42	26.63	12644.0
2009-09-04	AOM	ETF	27.05	27.14	26.98	27.0128	18907.0
2009-09-04	AOR	ETF	27.3894	27.54	27.3894	27.5394	10994.0
2009-09-04	ARB	ETF	17.71	17.71	17.0001	17.52	207928.0
2009-09-04	BAL	ETF	30.64	31.15	30.4701	31.15	4552.0
2009-09-04	BBH	ETF	33.1	33.6233	33.1	33.5967	245400.0
2009-09-04	BIL	ETF	91.72	91.76	91.72	91.76	78850.0
2009-09-04	BITS	ETF	19.8	21.2	19.72	21.08	2095.0
2009-09-04	BIV	ETF	79.61	79.79	79.38	79.38	158700.0
2009-09-04	BJK	ETF	23.72	24.46	23.68	24.33	13700.0
2009-09-04	BKF	ETF	37.74	38.49	37.59	38.48	199935.0
2009-09-04	BLV	ETF	77.97	77.97	77.24	77.33	40900.0
2009-09-04	BMVP	ETF	11.5233	11.6427	11.4936	11.63	13393.0
2009-09-04	BND	ETF	78.97	78.98	78.65	78.75	423200.0
2009-09-04	BNE	ETF	6.73	6.86	6.31	6.74	244386.0
2009-09-04	BOSS	ETF	18.95	19.9	18.95	19.9	200.0
2009-09-04	BRF	ETF	36.0	36.889	35.864	36.83	88797.0
2009-09-04	BSV	ETF	79.87	79.93	79.85	79.87	312900.0
2009-09-04	BTF	ETF	56.5	57.24999999999999	56.199999999999996	57.0	2653.2000000000003
2009-09-04	BWX	ETF	28.325	28.47	28.175	28.47	308504.0
2009-09-04	BWZ	ETF	36.09	36.3	36.0405	36.3	13740.0
2009-09-04	BZQ	ETF	7188.8	7217.6	6860.8	6900.8	24.5
2009-09-04	CEF	ETF	12.76	12.94	12.68	12.93	942100.0
2009-09-04	CEW	ETF	21.42	21.44	21.24	21.44	21920.0
2009-09-04	CGO	ETF	13.18	13.35	13.15	13.35	14645.0
2009-09-04	CGW	ETF	16.81	16.99	16.67	16.91	34038.0
2009-09-04	CHB	ETF	0.52	0.55	0.5106	0.52	1841179.0
2009-09-04	CHI	ETF	11.12	11.4188	11.12	11.4	107866.0
2009-09-04	CHIC	ETF	17.41	17.44	17.41	17.42	350591.0
2009-09-04	CHW	ETF	7.24	7.48	7.24	7.46	134666.0

> showing 50 of 669 rows — these rows as CSV

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