PREVIEW / etf_daily / 2010-10-05

all etf daily files

  file:    by_date/etf_daily/2010/2010-10-05.parquet
  size:    34 KB
  rows:    793

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-05	SPY	ETF	114.8	116.32	114.67	116.04	229634100.0
2010-10-05	QQQ	ETF	49.03	49.76	49.0	49.66	99301267.0
2010-10-05	IWM	ETF	67.68	69.01	67.25	68.84	77655500.0
2010-10-05	DIA	ETF	108.41	109.68	108.27	109.4	6493200.0
2010-10-05	GLD	ETF	130.11	131.12	129.87	130.99	17489600.0
2010-10-05	TLT	ETF	104.73	104.81	103.93	104.25	8491800.0
2010-10-05	AADR	ETF	28.33	28.66	28.33	28.65	69700.0
2010-10-05	AAXJ	ETF	61.94	62.62	61.92	62.47	1318400.0
2010-10-05	ACWI	ETF	43.52	44.19	43.52	44.19	538500.0
2010-10-05	ACWX	ETF	41.91	42.4597	41.892	42.37	54425.0
2010-10-05	ADRE	ETF	46.01	46.7499	45.95	46.6	98358.0
2010-10-05	AFK	ETF	33.28	33.65	33.03	33.65	55144.0
2010-10-05	AGG	ETF	108.61	108.61	108.38	108.44	758500.0
2010-10-05	AGQ	ETF	175.06	184.0	174.4	182.72	317400.0
2010-10-05	AGZ	ETF	111.39	111.46	111.2601	111.2601	11150.0
2010-10-05	AIA	ETF	43.11	43.49	43.04	43.44	61966.0
2010-10-05	AIQ	ETF	23.65	24.3195	23.5	24.3	17854.0
2010-10-05	AIS	ETF	1.45	1.5	1.43	1.49	519645.0
2010-10-05	AIVI	ETF	43.58	44.39	43.58	44.3	39100.0
2010-10-05	AMJ	ETF	34.46	34.46	34.1201	34.24	1036912.0
2010-10-05	AMLP	ETF	78.15	78.15	77.75	77.9	149540.0
2010-10-05	AOA	ETF	31.73	32.12	31.73	32.12	5500.0
2010-10-05	AOK	ETF	28.42	28.57	28.42	28.56	9152.0
2010-10-05	AOM	ETF	29.2399	29.38	29.2399	29.38	10714.0
2010-10-05	AOR	ETF	30.18	30.33	30.18	30.3	7777.0
2010-10-05	ARB	ETF	27.9	28.47	27.51	28.45	127182.0
2010-10-05	BAB	ETF	26.8	26.8	26.66	26.715	318182.0
2010-10-05	BAL	ETF	48.44	49.0	48.17	48.709	14195.0
2010-10-05	BALT	ETF	11.04	11.15	10.9	11.02	313998.0
2010-10-05	BBH	ETF	32.0033	32.49	31.9033	32.4467	42300.0
2010-10-05	BIB	ETF	6.4825	6.4825	6.4825	6.4825	1600.0
2010-10-05	BICK	ETF	32.35	32.64	32.325	32.6	152459.0
2010-10-05	BIL	ETF	91.7	91.72	91.7	91.7	420300.0
2010-10-05	BIS	ETF	9638.4	9638.4	9430.4	9430.4	3.875
2010-10-05	BITS	ETF	27.2	28.0	27.12	27.44	1553.0
2010-10-05	BIV	ETF	86.69	86.89	86.67	86.81	94200.0
2010-10-05	BJK	ETF	28.8	29.15	28.68	29.1	9000.0
2010-10-05	BKF	ETF	48.93	49.57	48.66	49.4	153772.0
2010-10-05	BLV	ETF	85.63	85.63	85.05	85.26	59100.0
2010-10-05	BMVP	ETF	13.0967	13.31	13.0967	13.2834	8629.0
2010-10-05	BND	ETF	82.55	82.64	82.51	82.6	758800.0
2010-10-05	BNE	ETF	11.36	11.36	11.35	11.36	332726.0
2010-10-05	BRF	ETF	57.75	59.09	57.598	59.07	551204.0
2010-10-05	BSCE	ETF	20.98	20.98	20.977	20.98	3801.0
2010-10-05	BSV	ETF	81.74	81.78	81.7	81.73	350700.0
2010-10-05	BTF	ETF	75.6	76.85	75.6	76.55	2930.4
2010-10-05	BWX	ETF	30.295	30.55	30.2015	30.42	399178.0
2010-10-05	BWZ	ETF	37.17	37.471	37.17	37.28	52309.0
2010-10-05	BZQ	ETF	2606.4	2628.8	2520.0	2540.8	1406.0
2010-10-05	CEF	ETF	16.95	17.23	16.94	17.2	1524900.0

> showing 50 of 793 rows — these rows as CSV

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