PREVIEW / etf_daily / 2010-06-14

all etf daily files

  file:    by_date/etf_daily/2010/2010-06-14.parquet
  size:    33 KB
  rows:    756

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-06-14	SPY	ETF	110.52	111.12	109.4	109.51	207196100.0
2010-06-14	QQQ	ETF	45.91	46.24	45.41	45.49	68084958.0
2010-06-14	IWM	ETF	65.8	66.5	65.16	65.35	70543000.0
2010-06-14	DIA	ETF	102.99	103.49	102.04	102.14	8995700.0
2010-06-14	GLD	ETF	119.63	120.26	118.96	119.6	11002800.0
2010-06-14	TLT	ETF	96.32	97.04	96.22	96.91	5310400.0
2010-06-14	AAXJ	ETF	53.29	53.88	53.05	53.09	406200.0
2010-06-14	ACWI	ETF	40.23	40.36	39.76	39.76	194400.0
2010-06-14	ACWX	ETF	37.5	37.55	36.96	36.96	69343.0
2010-06-14	ADRE	ETF	41.19	41.5	40.7	40.7	96849.0
2010-06-14	AFK	ETF	28.9	28.93	28.5	28.5	6197.0
2010-06-14	AGG	ETF	105.64	105.81	105.46	105.81	600200.0
2010-06-14	AGQ	ETF	124.16	125.7	121.24	121.4	99900.0
2010-06-14	AGZ	ETF	109.28	109.533	109.137	109.37	12103.0
2010-06-14	AIA	ETF	37.64	38.2	37.64	37.67	14090.0
2010-06-14	AIQ	ETF	26.7	26.95	25.5	25.7	20185.0
2010-06-14	AIS	ETF	1.76	1.88	1.74	1.81	1973155.0
2010-06-14	AIVI	ETF	38.83	39.13	38.58	38.58	18500.0
2010-06-14	AMJ	ETF	30.2	30.318	30.05	30.14	562654.0
2010-06-14	AOA	ETF	29.76	29.76	29.54	29.63	2000.0
2010-06-14	AOK	ETF	27.5805	27.63	27.5805	27.6	23329.0
2010-06-14	AOM	ETF	28.1099	28.1799	28.07	28.07	23373.0
2010-06-14	AOR	ETF	28.78	28.832	28.67	28.67	3541.0
2010-06-14	ARB	ETF	29.2	29.35	28.15	28.23	247911.0
2010-06-14	BAB	ETF	25.87	26.01	25.83	25.99	309435.0
2010-06-14	BAL	ETF	38.865	38.9	38.865	38.9	1115.0
2010-06-14	BALT	ETF	12.17	12.45	12.1	12.32	150045.0
2010-06-14	BBH	ETF	29.4333	29.8967	29.4333	29.5233	103800.0
2010-06-14	BICK	ETF	27.7	27.755	27.62	27.73	1402.0
2010-06-14	BIL	ETF	91.74	91.74	91.7	91.7	236650.0
2010-06-14	BITS	ETF	27.4	28.52	27.4	27.4	400.0
2010-06-14	BIV	ETF	81.74	81.99	81.6	81.97	112200.0
2010-06-14	BJK	ETF	24.69	24.95	24.46	24.55	6700.0
2010-06-14	BKF	ETF	42.71	42.87	42.06	42.06	81990.0
2010-06-14	BLV	ETF	79.25	79.66	79.11	79.66	72800.0
2010-06-14	BMVP	ETF	12.4733	12.5881	12.41	12.41	9444.0
2010-06-14	BND	ETF	80.3	80.4	80.2	80.38	539600.0
2010-06-14	BNE	ETF	11.16	11.19	11.15	11.17	920520.0
2010-06-14	BNO	ETF	25.985	25.99	25.64	25.64	21200.0
2010-06-14	BOSS	ETF	28.785	29.2	28.785	29.2	300.0
2010-06-14	BRF	ETF	44.46	44.54	43.65	43.69	212340.0
2010-06-14	BSV	ETF	80.42	80.46	80.34	80.46	333400.0
2010-06-14	BTF	ETF	65.0	66.35	65.0	65.39999999999999	5467.200000000001
2010-06-14	BWX	ETF	26.17	26.665	26.17	26.508	144150.0
2010-06-14	BWZ	ETF	32.66	33.455	32.66	33.29	65756.0
2010-06-14	BZQ	ETF	3950.4	4124.8	3934.4	4120.0	662.5
2010-06-14	CEF	ETF	14.96	15.03	14.93	15.01	1202500.0
2010-06-14	CEW	ETF	21.48	21.49	21.34	21.4	397420.0
2010-06-14	CGO	ETF	13.14	13.14	13.02	13.04	32780.0
2010-06-14	CGW	ETF	17.06	17.2499	16.95	16.99	51825.0

> showing 50 of 756 rows — these rows as CSV

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