PREVIEW / etf_daily / 2010-01-28

all etf daily files

  file:    by_date/etf_daily/2010/2010-01-28.parquet
  size:    31 KB
  rows:    717

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
2010-01-28	SPY	ETF	110.19	110.25	107.91	108.57	316104000.0
2010-01-28	QQQ	ETF	44.4	44.43	43.32	43.55	221439792.0
2010-01-28	IWM	ETF	61.96	61.99	60.22	60.78	93814200.0
2010-01-28	DIA	ETF	102.59	102.62	100.51	101.2	13409200.0
2010-01-28	GLD	ETF	107.18	107.23	105.18	106.48	16793900.0
2010-01-28	TLT	ETF	91.13	91.7	91.06	91.51	3058200.0
2010-01-28	AAXJ	ETF	53.46	53.46	52.07	52.49	205500.0
2010-01-28	ACWI	ETF	41.55	41.55	40.44	40.58	677300.0
2010-01-28	ACWX	ETF	39.81	39.81	38.86	38.99	192270.0
2010-01-28	ADRE	ETF	40.86	40.866	39.75	40.2	189031.0
2010-01-28	AFK	ETF	28.4799	28.4799	27.94	27.95	3175.0
2010-01-28	AGG	ETF	104.4	104.56	104.34	104.41	640300.0
2010-01-28	AGQ	ETF	108.74	108.94	100.12	102.86	302450.0
2010-01-28	AGZ	ETF	108.38	108.67	108.3566	108.67	10862.0
2010-01-28	AIA	ETF	38.26	38.43	37.54	37.73	36599.0
2010-01-28	AIQ	ETF	24.9	25.15	24.35	24.45	24011.0
2010-01-28	AIS	ETF	1.15	1.19	1.12	1.19	181479.0
2010-01-28	AIVI	ETF	42.18	42.18	40.91	41.38	28200.0
2010-01-28	AMJ	ETF	29.42	29.42	28.98	29.15	409809.0
2010-01-28	AOA	ETF	29.66	29.66	29.14	29.2	4200.0
2010-01-28	AOK	ETF	27.2263	27.3044	27.2207	27.2819	3753.0
2010-01-28	AOM	ETF	28.12	28.12	27.8545	27.91	9933.0
2010-01-28	AOR	ETF	28.86	28.86	28.3401	28.474	13759.0
2010-01-28	ARB	ETF	25.9	25.9	25.25	25.3	130239.0
2010-01-28	BAB	ETF	24.8	24.86	24.79	24.86	78711.0
2010-01-28	BAL	ETF	34.02	34.072	33.7	33.7	5424.0
2010-01-28	BBH	ETF	33.8767	34.0233	33.6333	33.88	199500.0
2010-01-28	BIL	ETF	91.7	91.74	91.7	91.72	117500.0
2010-01-28	BITS	ETF	32.4	32.712	32.0	32.6	3069.0
2010-01-28	BIV	ETF	80.38	80.45	80.22	80.36	78100.0
2010-01-28	BJK	ETF	24.28	24.43	23.82	23.92	17600.0
2010-01-28	BKF	ETF	42.21	42.56	41.13	41.66	385473.0
2010-01-28	BLV	ETF	77.58	77.58	76.89	77.08	35500.0
2010-01-28	BMVP	ETF	12.5333	12.5397	12.2667	12.3533	22648.0
2010-01-28	BND	ETF	79.31	79.55	79.31	79.5	696100.0
2010-01-28	BNE	ETF	6.58	6.58	6.03	6.11	254941.0
2010-01-28	BOSS	ETF	19.99	19.99	19.56	19.745	100.0
2010-01-28	BRF	ETF	43.65	43.65	42.0	42.42	555040.0
2010-01-28	BSV	ETF	80.19	80.25	80.11	80.25	480500.0
2010-01-28	BTF	ETF	66.05	66.39999999999999	65.6	66.25	9653.4
2010-01-28	BWX	ETF	28.355	28.355	28.15	28.23	312710.0
2010-01-28	BWZ	ETF	36.28	36.28	35.93	36.1	79443.0
2010-01-28	BZQ	ETF	4507.2	4784.0	4496.0	4641.6	518.0
2010-01-28	CEF	ETF	13.31	13.34	12.83	12.96	1998400.0
2010-01-28	CEW	ETF	21.764	21.764	21.67	21.75	62206.0
2010-01-28	CGO	ETF	14.34	14.63	13.8	13.85	51386.0
2010-01-28	CGW	ETF	17.9	17.97	17.55	17.63	230049.0
2010-01-28	CHI	ETF	12.6	12.6	12.25	12.36	137993.0
2010-01-28	CHIE	ETF	13.79	13.79	13.41	13.57	3800.0
2010-01-28	CHII	ETF	14.4	14.4	14.14	14.23	32096.0

> showing 50 of 717 rows — these rows as CSV

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