PREVIEW / etf_daily / 2010-03-25

all etf daily files

  file:    by_date/etf_daily/2010/2010-03-25.parquet
  size:    32 KB
  rows:    738

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-03-25	SPY	ETF	117.63	118.17	116.51	116.65	223396300.0
2010-03-25	QQQ	ETF	48.42	48.6	47.9	47.95	76350056.0
2010-03-25	IWM	ETF	68.87	69.36	67.79	67.84	66977000.0
2010-03-25	DIA	ETF	108.99	109.53	108.32	108.44	9526500.0
2010-03-25	GLD	ETF	107.0	107.25	106.48	106.78	16866700.0
2010-03-25	TLT	ETF	89.13	89.24	88.37	88.7	8268400.0
2010-03-25	AAXJ	ETF	56.33	56.33	55.49	55.6	64300.0
2010-03-25	ACWI	ETF	43.28	43.49	42.93	42.95	825200.0
2010-03-25	ACWX	ETF	41.31	41.3999	40.86	40.86	56589.0
2010-03-25	ADRE	ETF	43.32	43.39	42.59	42.59	84021.0
2010-03-25	AFK	ETF	30.79	30.8	30.25	30.25	11550.0
2010-03-25	AGG	ETF	104.23	104.24	103.86	104.05	1416700.0
2010-03-25	AGQ	ETF	106.58	107.34	104.3	104.78	195650.0
2010-03-25	AGZ	ETF	107.93	108.12	107.91	108.07	17821.0
2010-03-25	AIA	ETF	39.6	39.76	39.26	39.26	24409.0
2010-03-25	AIQ	ETF	28.75	29.1	28.4995	28.7	22895.0
2010-03-25	AIS	ETF	1.55	1.55	1.45	1.48	355969.0
2010-03-25	AIVI	ETF	42.31	42.37	41.79	41.79	23600.0
2010-03-25	AMJ	ETF	30.14	30.14	29.72	29.74	1407000.0
2010-03-25	AOA	ETF	31.49	31.65	31.25	31.25	15300.0
2010-03-25	AOK	ETF	27.79	27.849	27.73	27.79	11086.0
2010-03-25	AOM	ETF	28.8	28.8	28.65	28.65	26521.0
2010-03-25	AOR	ETF	29.86	29.885	29.61	29.65	14335.0
2010-03-25	ARB	ETF	26.48	27.95	26.22	27.2	501298.0
2010-03-25	BAB	ETF	24.95	24.96	24.77	24.8	250402.0
2010-03-25	BAL	ETF	39.28	39.35	38.51	38.51	3290.0
2010-03-25	BALT	ETF	13.51	13.74	13.4	13.5	394614.0
2010-03-25	BBH	ETF	35.0233	35.0833	34.4833	34.51	116700.0
2010-03-25	BIL	ETF	91.7	91.72	91.68	91.72	283300.0
2010-03-25	BITS	ETF	32.23	33.0	32.0	32.0	3436.0
2010-03-25	BIV	ETF	80.1	80.16	79.68	79.95	140100.0
2010-03-25	BJK	ETF	25.71	25.83	25.17	25.31	25400.0
2010-03-25	BKF	ETF	45.29	45.75	44.77	44.85	464505.0
2010-03-25	BLV	ETF	76.72	76.72	76.08	76.39	23200.0
2010-03-25	BMVP	ETF	13.26	13.31	13.15	13.15	18261.0
2010-03-25	BND	ETF	79.19	79.21	78.84	78.97	998900.0
2010-03-25	BNE	ETF	11.28	11.31	11.22	11.24	756560.0
2010-03-25	BRF	ETF	45.69	45.71	44.69	44.78	362146.0
2010-03-25	BSV	ETF	79.93	79.93	79.81	79.91	518600.0
2010-03-25	BTF	ETF	74.89999999999999	74.95	74.19999999999999	74.25	7548.6
2010-03-25	BWX	ETF	27.885	27.885	27.625	27.635	317022.0
2010-03-25	BWZ	ETF	35.12	35.215	35.08	35.08	14779.0
2010-03-25	BZQ	ETF	3740.8	3944.0	3729.6	3936.0	476.0
2010-03-25	CEF	ETF	13.6	13.65	13.51	13.52	541400.0
2010-03-25	CEW	ETF	21.97	21.99	21.89	21.91	155183.0
2010-03-25	CGO	ETF	14.85	15.07	14.82	14.93	45119.0
2010-03-25	CGW	ETF	18.34	18.37	18.07	18.09	164362.0
2010-03-25	CHI	ETF	12.72	12.74	12.61	12.66	307843.0
2010-03-25	CHIE	ETF	14.21	14.24	14.0	14.0	14000.0
2010-03-25	CHII	ETF	15.06	15.06	14.81	14.81	8794.0

> showing 50 of 738 rows — these rows as CSV

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