PREVIEW / etf_daily / 2010-03-26

all etf daily files

  file:    by_date/etf_daily/2010/2010-03-26.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-26	SPY	ETF	116.87	117.42	116.12	116.58	205808500.0
2010-03-26	QQQ	ETF	48.14	48.33	47.74	48.0	78067827.0
2010-03-26	IWM	ETF	68.12	68.57	67.56	67.81	58114700.0
2010-03-26	DIA	ETF	108.63	109.07	108.13	108.43	8859800.0
2010-03-26	GLD	ETF	107.16	108.7	106.82	108.59	17433600.0
2010-03-26	TLT	ETF	88.54	89.12	88.49	88.95	4110700.0
2010-03-26	AAXJ	ETF	56.47	56.47	55.64	55.94	90400.0
2010-03-26	ACWI	ETF	43.32	43.47	43.01	43.18	184100.0
2010-03-26	ACWX	ETF	41.11	41.36	40.99	41.19	85426.0
2010-03-26	ADRE	ETF	42.83	43.18	42.5	42.85	148070.0
2010-03-26	AFK	ETF	30.54	30.99	30.37	30.99	13029.0
2010-03-26	AGG	ETF	103.97	104.25	103.96	104.22	1251100.0
2010-03-26	AGQ	ETF	107.08	109.32	105.56	108.72	209900.0
2010-03-26	AGZ	ETF	108.138	108.175	107.995	108.14	13777.0
2010-03-26	AIA	ETF	39.9	39.92	39.35	39.74	19220.0
2010-03-26	AIQ	ETF	28.7	29.1495	28.7	29.0	12920.0
2010-03-26	AIS	ETF	1.47	1.48	1.41	1.44	293689.0
2010-03-26	AIVI	ETF	42.04	42.31	41.98	42.2	11100.0
2010-03-26	AMJ	ETF	29.79	29.98	29.64	29.75	475016.0
2010-03-26	AOA	ETF	31.39	31.41	31.17	31.22	10700.0
2010-03-26	AOK	ETF	27.83	27.8499	27.77	27.788	8043.0
2010-03-26	AOM	ETF	28.66	28.67	28.59	28.62	9675.0
2010-03-26	AOR	ETF	29.67	29.7	29.56	29.56	8018.0
2010-03-26	ARB	ETF	27.34	27.7	26.47	26.52	376384.0
2010-03-26	BAB	ETF	24.8	24.9	24.76	24.86	230298.0
2010-03-26	BAL	ETF	38.5	38.613	38.4144	38.5	2630.0
2010-03-26	BALT	ETF	13.45	13.5	13.3	13.48	232297.0
2010-03-26	BBH	ETF	34.5367	34.8067	34.22	34.45	114300.0
2010-03-26	BIL	ETF	91.7	91.72	91.7	91.72	127150.0
2010-03-26	BITS	ETF	32.56	32.84	31.84	32.36	2430.0
2010-03-26	BIV	ETF	79.97	80.2	79.83	80.17	209300.0
2010-03-26	BJK	ETF	25.6	25.8	25.38	25.44	7000.0
2010-03-26	BKF	ETF	45.29	45.42	44.8799	45.2	162804.0
2010-03-26	BLV	ETF	76.2	76.61	76.2	76.53	20000.0
2010-03-26	BMVP	ETF	13.13	13.17	13.05	13.08	13687.0
2010-03-26	BND	ETF	79.03	79.18	78.95	79.14	863200.0
2010-03-26	BNE	ETF	11.25	11.26	11.23	11.24	335006.0
2010-03-26	BRF	ETF	45.0	45.08	44.18	44.7	796352.0
2010-03-26	BSV	ETF	79.91	79.97	79.85	79.97	714600.0
2010-03-26	BTF	ETF	74.5	74.6005	74.0	74.59949999999999	1275.0
2010-03-26	BWX	ETF	27.805	27.805	27.67	27.72	244636.0
2010-03-26	BWZ	ETF	35.23	35.305	35.15	35.2999	10352.0
2010-03-26	BZQ	ETF	3907.2	4016.0	3865.6	3920.0	420.0
2010-03-26	CEF	ETF	13.55	13.79	13.55	13.79	883600.0
2010-03-26	CEW	ETF	21.97	21.98	21.88	21.96	39814.0
2010-03-26	CGO	ETF	14.9	14.97	14.85	14.95	38191.0
2010-03-26	CGW	ETF	18.25	18.25	18.07	18.12	76609.0
2010-03-26	CHI	ETF	12.66	12.68	12.39	12.55	242387.0
2010-03-26	CHIE	ETF	14.34	14.37	14.24	14.24	5600.0
2010-03-26	CHII	ETF	15.11	15.19	14.9899	15.0401	10172.0

> showing 50 of 738 rows — these rows as CSV

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