PREVIEW / etf_daily / 2010-04-26

all etf daily files

  file:    by_date/etf_daily/2010/2010-04-26.parquet
  size:    33 KB
  rows:    753

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-04-26	SPY	ETF	121.85	122.12	121.23	121.35	143457300.0
2010-04-26	QQQ	ETF	50.53	50.65	50.3	50.41	67360933.0
2010-04-26	IWM	ETF	74.17	74.66	73.83	73.85	62710000.0
2010-04-26	DIA	ETF	112.11	112.58	112.02	112.08	8015700.0
2010-04-26	GLD	ETF	112.88	113.2	112.63	112.75	8335400.0
2010-04-26	TLT	ETF	90.51	90.65	89.94	90.21	4753900.0
2010-04-26	AAXJ	ETF	58.7	58.74	58.35	58.44	113600.0
2010-04-26	ACWI	ETF	45.0	45.0	44.66	44.68	178800.0
2010-04-26	ACWX	ETF	42.43	42.49	42.2319	42.25	32655.0
2010-04-26	ADRE	ETF	45.25	45.25	44.94	44.98	51377.0
2010-04-26	AFK	ETF	32.45	32.55	32.08	32.18	14363.0
2010-04-26	AGG	ETF	104.3	104.38	104.2	104.23	587100.0
2010-04-26	AGQ	ETF	125.5	127.16	125.04	125.62	99950.0
2010-04-26	AGZ	ETF	107.98	108.1299	107.9445	108.04	14234.0
2010-04-26	AIA	ETF	41.98	42.0	41.64	41.79	21411.0
2010-04-26	AIQ	ETF	28.7	28.7	27.95	28.0	10229.0
2010-04-26	AIS	ETF	1.54	1.6	1.54	1.57	380550.0
2010-04-26	AIVI	ETF	43.88	43.88	43.53	43.62	18800.0
2010-04-26	AMJ	ETF	31.74	31.9	31.69	31.82	301177.0
2010-04-26	AOA	ETF	32.74	33.09	32.65	32.68	29500.0
2010-04-26	AOK	ETF	28.26	28.26	28.15	28.15	12417.0
2010-04-26	AOM	ETF	29.26	29.26	29.14	29.2	11090.0
2010-04-26	AOR	ETF	30.49	30.87	30.49	30.51	32273.0
2010-04-26	ARB	ETF	31.8	32.35	31.65	31.91	233489.0
2010-04-26	BAB	ETF	25.41	25.41	25.23	25.25	74399.0
2010-04-26	BAL	ETF	41.15	41.29	40.52	40.58	15228.0
2010-04-26	BALT	ETF	14.25	14.25	13.9	13.95	275429.0
2010-04-26	BBH	ETF	33.1033	33.13	32.6467	32.6533	223800.0
2010-04-26	BIB	ETF	7.33	7.34	7.1988	7.1988	6400.0
2010-04-26	BICK	ETF	30.19	30.38	29.52	30.25	19546.0
2010-04-26	BIL	ETF	91.68	91.7	91.68	91.7	222300.0
2010-04-26	BIS	ETF	9774.4	9936.0	9774.4	9936.0	21.6
2010-04-26	BITS	ETF	31.4	31.84	31.4	31.84	725.0
2010-04-26	BIV	ETF	80.5	80.53	80.3	80.37	70100.0
2010-04-26	BJK	ETF	27.34	27.7	27.34	27.66	12700.0
2010-04-26	BKF	ETF	47.2	47.3	46.8501	46.95	1142344.0
2010-04-26	BLV	ETF	77.67	77.88	77.36	77.48	28000.0
2010-04-26	BMVP	ETF	13.8767	13.9647	13.87	13.8767	22148.0
2010-04-26	BND	ETF	79.45	79.45	79.28	79.3	447200.0
2010-04-26	BNE	ETF	11.21	11.25	11.2	11.25	742951.0
2010-04-26	BOSS	ETF	25.94	26.75	25.94	26.75	600.0
2010-04-26	BRF	ETF	46.66	46.85	46.29	46.61	231612.0
2010-04-26	BSV	ETF	79.96	79.99	79.89	79.94	273900.0
2010-04-26	BTF	ETF	74.55	75.1	74.4	74.4	8650.4
2010-04-26	BWX	ETF	27.58	27.665	27.545	27.665	331700.0
2010-04-26	BWZ	ETF	35.36	35.399	35.21	35.25	19696.0
2010-04-26	BZQ	ETF	3529.6	3576.0	3505.6	3576.0	283.0
2010-04-26	CEF	ETF	14.61	14.71	14.55	14.58	1001000.0
2010-04-26	CEW	ETF	22.41	22.489	22.41	22.48	194780.0
2010-04-26	CGO	ETF	15.12	15.12	15.01	15.02	57408.0

> showing 50 of 753 rows — these rows as CSV

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