PREVIEW / etf_daily / 2010-10-01

all etf daily files

  file:    by_date/etf_daily/2010/2010-10-01.parquet
  size:    34 KB
  rows:    789

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-10-01	SPY	ETF	114.99	115.12	113.93	114.61	174638700.0
2010-10-01	QQQ	ETF	49.46	49.53	48.781	49.01	77682344.0
2010-10-01	IWM	ETF	68.14	68.26	67.25	67.86	61763500.0
2010-10-01	DIA	ETF	108.55	108.73	107.84	108.32	5987600.0
2010-10-01	GLD	ETF	127.91	129.07	127.91	128.91	17211900.0
2010-10-01	TLT	ETF	104.23	105.14	103.98	104.61	9368400.0
2010-10-01	AADR	ETF	28.3	28.3	28.3	28.3	5000.0
2010-10-01	AAXJ	ETF	61.12	61.55	61.03	61.55	475600.0
2010-10-01	ACWI	ETF	43.55	43.64	43.29	43.6	154000.0
2010-10-01	ACWX	ETF	41.75	41.87	41.58	41.77	103247.0
2010-10-01	ADRE	ETF	45.45	45.85	45.35	45.69	240284.0
2010-10-01	AFK	ETF	32.53	32.63	32.47	32.6	19473.0
2010-10-01	AGG	ETF	108.26	108.37	108.14	108.26	1366700.0
2010-10-01	AGQ	ETF	170.08	172.28	169.52	171.64	221800.0
2010-10-01	AGZ	ETF	111.02	111.385	111.02	111.2192	12989.0
2010-10-01	AIA	ETF	42.83	42.83	42.61	42.83	10500.0
2010-10-01	AIQ	ETF	23.0	24.111	22.85	23.9	40377.0
2010-10-01	AIS	ETF	1.46	1.465	1.42	1.45	254957.0
2010-10-01	AIVI	ETF	43.48	43.61	43.29	43.52	8200.0
2010-10-01	AMJ	ETF	33.93	34.08	33.8	34.07	697614.0
2010-10-01	AMLP	ETF	77.55	77.7	77.25	77.65	112740.0
2010-10-01	AOA	ETF	31.8	31.8	31.56	31.72	8400.0
2010-10-01	AOK	ETF	28.39	28.45	28.39	28.4499	6673.0
2010-10-01	AOM	ETF	29.19	29.19	29.0601	29.16	21969.0
2010-10-01	AOR	ETF	30.09	30.21	29.93	30.0499	9762.0
2010-10-01	ARB	ETF	28.12	28.66	27.805	28.4	112727.0
2010-10-01	BAB	ETF	26.7	26.78	26.65	26.76	124678.0
2010-10-01	BAL	ETF	49.9	49.93	47.677	47.677	32963.0
2010-10-01	BALT	ETF	11.11	11.25	11.02	11.17	270411.0
2010-10-01	BBH	ETF	32.0833	32.21	31.89	32.11	25200.0
2010-10-01	BIB	ETF	6.3563	6.4025	6.3338	6.4	6120.0
2010-10-01	BICK	ETF	31.88	32.14	31.63	32.13	82132.0
2010-10-01	BIL	ETF	91.7	91.72	91.7	91.7	328150.0
2010-10-01	BITS	ETF	27.6	28.0	26.924	27.36	2475.0
2010-10-01	BIV	ETF	86.27	86.5	86.11	86.35	141500.0
2010-10-01	BJK	ETF	28.29	28.29	27.97	28.08	17300.0
2010-10-01	BKF	ETF	48.18	48.6	48.07	48.33	158088.0
2010-10-01	BLV	ETF	84.98	85.52	84.78	85.05	874300.0
2010-10-01	BMVP	ETF	13.19	13.19	13.07	13.16	25757.0
2010-10-01	BND	ETF	82.39	82.43	82.22	82.37	1249200.0
2010-10-01	BNE	ETF	11.35	11.37	11.3	11.36	1248760.0
2010-10-01	BNO	ETF	27.99	27.99	27.85	27.85	14400.0
2010-10-01	BRF	ETF	56.79	57.7	56.79	57.46	340625.0
2010-10-01	BSV	ETF	81.6	81.68	81.58	81.68	354400.0
2010-10-01	BTF	ETF	76.14999999999999	76.6	75.3	75.9025	4037.4
2010-10-01	BWX	ETF	30.125	30.255	30.0805	30.105	444160.0
2010-10-01	BWZ	ETF	37.1699	37.25	37.0301	37.207	44494.0
2010-10-01	BZQ	ETF	2659.2	2707.2	2628.8	2652.8	1172.0
2010-10-01	CEF	ETF	16.76	16.88	16.7	16.83	894300.0
2010-10-01	CEW	ETF	23.02	23.09	23.02	23.06	361813.0

> showing 50 of 789 rows — these rows as CSV

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