PREVIEW / etf_daily / 2010-04-12

all etf daily files

  file:    by_date/etf_daily/2010/2010-04-12.parquet
  size:    32 KB
  rows:    748

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-12	SPY	ETF	119.7	120.05	119.56	119.74	110279000.0
2010-04-12	QQQ	ETF	49.05	49.2	48.94	49.07	44280597.0
2010-04-12	IWM	ETF	70.28	70.68	70.12	70.54	49301000.0
2010-04-12	DIA	ETF	110.14	110.36	109.98	110.18	4366500.0
2010-04-12	GLD	ETF	113.64	114.13	112.98	113.01	11118900.0
2010-04-12	TLT	ETF	89.17	89.56	89.09	89.45	2939600.0
2010-04-12	AAXJ	ETF	58.52	58.61	58.37	58.39	125300.0
2010-04-12	ACWI	ETF	44.86	44.86	44.63	44.76	127100.0
2010-04-12	ACWX	ETF	42.8	42.92	42.75	42.81	167263.0
2010-04-12	ADRE	ETF	45.44	45.55	45.23	45.3	73092.0
2010-04-12	AFK	ETF	32.99	33.2	32.89	33.052	16879.0
2010-04-12	AGG	ETF	103.91	104.04	103.8	104.02	476500.0
2010-04-12	AGQ	ETF	128.08	129.26	124.36	124.6	168150.0
2010-04-12	AGZ	ETF	108.02	108.05	107.9	107.94	10527.0
2010-04-12	AIA	ETF	41.78	41.82	41.6601	41.73	16941.0
2010-04-12	AIQ	ETF	26.75	26.9	26.1	26.75	26472.0
2010-04-12	AIS	ETF	1.7	1.7	1.6	1.62	572011.0
2010-04-12	AIVI	ETF	43.72	43.97	43.72	43.89	32300.0
2010-04-12	AMJ	ETF	31.5	31.56	31.39	31.52	302325.0
2010-04-12	AOA	ETF	32.3	32.34	32.24	32.28	12800.0
2010-04-12	AOK	ETF	28.01	28.06	27.9601	28.04	18952.0
2010-04-12	AOM	ETF	29.07	29.08	29.01	29.06	19871.0
2010-04-12	AOR	ETF	30.29	30.29	30.17	30.24	15409.0
2010-04-12	ARB	ETF	26.89	27.37	26.68	27.0	245508.0
2010-04-12	BAB	ETF	25.01	25.09	24.96	25.07	112839.0
2010-04-12	BAL	ETF	38.01	38.0531	37.67	37.677	3230.0
2010-04-12	BALT	ETF	13.91	13.93	13.62	13.8	201228.0
2010-04-12	BBH	ETF	34.6567	34.7567	34.5567	34.5833	30900.0
2010-04-12	BIB	ETF	7.495	7.5175	7.4475	7.4475	19200.0
2010-04-12	BIL	ETF	91.68	91.7	91.68	91.68	102300.0
2010-04-12	BIS	ETF	9606.4	9680.0	9592.0	9625.6	23.1
2010-04-12	BITS	ETF	31.96	32.4	31.926	31.96	350.0
2010-04-12	BIV	ETF	80.13	80.13	79.9	80.06	129000.0
2010-04-12	BJK	ETF	27.34	27.42	27.21	27.33	15200.0
2010-04-12	BKF	ETF	48.45	48.45	47.86	48.02	207211.0
2010-04-12	BLV	ETF	76.51	77.04	76.51	76.83	56800.0
2010-04-12	BMVP	ETF	13.49	13.4919	13.4633	13.4733	11441.0
2010-04-12	BND	ETF	78.94	79.09	78.93	79.02	606500.0
2010-04-12	BNE	ETF	11.13	11.16	11.13	11.14	264004.0
2010-04-12	BRF	ETF	46.13	46.487	46.07	46.29	219968.0
2010-04-12	BSV	ETF	79.7	79.83	79.7	79.8	352600.0
2010-04-12	BTF	ETF	75.3	75.44349999999999	74.4	74.89999999999999	4286.0
2010-04-12	BWX	ETF	27.995	28.015	27.875	27.94	271696.0
2010-04-12	BWZ	ETF	35.65	35.76	35.65	35.724	16486.0
2010-04-12	BZQ	ETF	3382.4	3468.8	3371.2	3446.4	178.0
2010-04-12	CEF	ETF	14.69	14.78	14.55	14.6	1098200.0
2010-04-12	CEW	ETF	22.7	22.7	22.45	22.45	156027.0
2010-04-12	CGO	ETF	15.14	15.14	14.9	14.99	22298.0
2010-04-12	CGW	ETF	18.97	18.97	18.85	18.88	31404.0
2010-04-12	CHI	ETF	12.64	12.74	12.59	12.68	288244.0

> showing 50 of 748 rows — these rows as CSV

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