PREVIEW / etf_daily / 2010-03-04

all etf daily files

  file:    by_date/etf_daily/2010/2010-03-04.parquet
  size:    31 KB
  rows:    724

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-04	SPY	ETF	112.45	112.8	112.03	112.64	135770400.0
2010-03-04	QQQ	ETF	45.64	45.81	45.4	45.75	54470836.0
2010-03-04	IWM	ETF	65.14	65.37	64.87	65.29	47174200.0
2010-03-04	DIA	ETF	104.24	104.57	103.96	104.5	6168300.0
2010-03-04	GLD	ETF	111.25	111.37	110.22	110.83	12944800.0
2010-03-04	TLT	ETF	90.96	91.68	90.83	91.47	2374700.0
2010-03-04	AAXJ	ETF	53.95	53.95	53.41	53.73	126900.0
2010-03-04	ACWI	ETF	41.99	42.01	41.62	41.77	194200.0
2010-03-04	ACWX	ETF	40.25	40.25	39.82	40.02	98830.0
2010-03-04	ADRE	ETF	42.43	42.43	41.75	42.05	86614.0
2010-03-04	AFK	ETF	29.75	29.91	29.54	29.8099	11866.0
2010-03-04	AGG	ETF	104.34	104.63	104.34	104.59	782700.0
2010-03-04	AGQ	ETF	114.12	114.5	111.4	112.06	295800.0
2010-03-04	AGZ	ETF	108.36	108.67	108.36	108.65	34186.0
2010-03-04	AIA	ETF	38.69	38.69	38.35	38.57	23880.0
2010-03-04	AIQ	ETF	24.7	24.7	23.8	24.6	23761.0
2010-03-04	AIS	ETF	1.34	1.35	1.31	1.33	194983.0
2010-03-04	AIVI	ETF	41.3	41.3	40.9	41.1	14100.0
2010-03-04	AMJ	ETF	29.65	29.67	29.39	29.61	481616.0
2010-03-04	AOA	ETF	30.4	30.43	30.23	30.34	12400.0
2010-03-04	AOK	ETF	27.56	27.56	27.47	27.5399	5401.0
2010-03-04	AOM	ETF	28.29	28.29	28.2	28.28	9537.0
2010-03-04	AOR	ETF	29.0599	29.11	28.992	29.105	10021.0
2010-03-04	ARB	ETF	22.34	22.4	21.92	22.17	243013.0
2010-03-04	BAB	ETF	25.01	25.11	24.98	25.07	185587.0
2010-03-04	BAL	ETF	39.69	39.83	38.61	39.55	32060.0
2010-03-04	BBH	ETF	34.49	34.49	34.04	34.2133	37500.0
2010-03-04	BIL	ETF	91.7	91.7	91.68	91.68	137250.0
2010-03-04	BITS	ETF	31.874	32.76	31.874	32.76	372.0
2010-03-04	BIV	ETF	80.6	80.75	80.53	80.74	128200.0
2010-03-04	BJK	ETF	23.98	23.98	23.59	23.64	16200.0
2010-03-04	BKF	ETF	44.34	44.53	43.8	44.32	124729.0
2010-03-04	BLV	ETF	77.19	77.52	76.98	77.44	18800.0
2010-03-04	BMVP	ETF	12.7867	12.8167	12.74	12.8033	13612.0
2010-03-04	BND	ETF	79.51	79.61	79.44	79.59	461200.0
2010-03-04	BNE	ETF	11.21	11.24	11.2	11.21	1603791.0
2010-03-04	BOSS	ETF	20.32	20.64	20.32	20.64	300.0
2010-03-04	BRF	ETF	47.09	47.1999	46.2	46.67	325459.0
2010-03-04	BSV	ETF	80.27	80.28	80.2	80.27	586500.0
2010-03-04	BTF	ETF	70.25	70.39999999999999	69.8	70.14999999999999	10390.0
2010-03-04	BWX	ETF	28.05	28.155	27.94	27.95	279012.0
2010-03-04	BWZ	ETF	35.82	35.8999	35.65	35.67	20420.0
2010-03-04	BZQ	ETF	3891.2	4048.0	3868.8	3937.6	342.0
2010-03-04	CEF	ETF	13.94	13.96	13.76	13.92	732300.0
2010-03-04	CEW	ETF	22.0	22.0	21.937	21.98	103815.0
2010-03-04	CGO	ETF	14.25	14.464	14.12	14.23	29612.0
2010-03-04	CGW	ETF	18.1	18.11	17.9	17.93	169684.0
2010-03-04	CHI	ETF	12.68	12.73	12.59	12.72	132802.0
2010-03-04	CHIE	ETF	14.16	14.18	14.0604	14.07	900.0
2010-03-04	CHII	ETF	14.98	15.08	14.92	14.98	10443.0

> showing 50 of 724 rows — these rows as CSV

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