PREVIEW / etf_daily / 2010-08-04

all etf daily files

  file:    by_date/etf_daily/2010/2010-08-04.parquet
  size:    33 KB
  rows:    765

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-08-04	SPY	ETF	112.53	113.11	112.16	112.97	158171700.0
2010-08-04	QQQ	ETF	46.69	46.99	46.5	46.938	43817790.0
2010-08-04	IWM	ETF	65.98	66.48	65.71	66.31	40817400.0
2010-08-04	DIA	ETF	106.65	107.15	106.38	106.96	7289900.0
2010-08-04	GLD	ETF	117.41	117.65	116.65	116.72	10323200.0
2010-08-04	TLT	ETF	99.5	99.51	98.56	98.56	3820400.0
2010-08-04	AADR	ETF	25.86	25.86	25.86	25.86	500.0
2010-08-04	AAXJ	ETF	57.12	57.4	56.97	57.18	863900.0
2010-08-04	ACWI	ETF	42.12	42.25	41.88	42.24	117100.0
2010-08-04	ACWX	ETF	39.92	40.12	39.76	40.1	64905.0
2010-08-04	ADRE	ETF	43.53	43.7	43.23	43.57	207996.0
2010-08-04	AFK	ETF	31.43	31.44	31.18	31.24	11105.0
2010-08-04	AGG	ETF	107.48	107.58	107.15	107.29	981700.0
2010-08-04	AGQ	ETF	124.12	124.84	118.72	119.76	158550.0
2010-08-04	AGZ	ETF	110.7	110.7	110.49	110.5	7925.0
2010-08-04	AIA	ETF	40.8	40.8	40.54	40.69	16356.0
2010-08-04	AIQ	ETF	22.7	23.35	22.4	23.0	40537.0
2010-08-04	AIS	ETF	1.59	1.64	1.59	1.63	569805.0
2010-08-04	AIVI	ETF	41.59	41.89	41.59	41.88	7700.0
2010-08-04	AMJ	ETF	33.56	33.758	33.38	33.64	1821489.0
2010-08-04	AOA	ETF	30.65	30.76	30.64	30.69	7600.0
2010-08-04	AOK	ETF	28.048	28.05	27.98	28.04	18492.0
2010-08-04	AOM	ETF	28.71	28.7499	28.652	28.704	9004.0
2010-08-04	AOR	ETF	29.41	29.49	29.41	29.489	4730.0
2010-08-04	ARB	ETF	29.24	29.46	28.88	29.29	130645.0
2010-08-04	BAB	ETF	26.1	26.1	25.97	26.0	305968.0
2010-08-04	BAL	ETF	38.69	38.93	38.52	38.52	4146.0
2010-08-04	BALT	ETF	11.33	11.38	11.2	11.3	58290.0
2010-08-04	BBH	ETF	31.58	31.9933	31.5567	31.9267	322800.0
2010-08-04	BIB	ETF	5.975	6.0025	5.975	6.0025	1600.0
2010-08-04	BICK	ETF	29.82	29.99	29.45	29.85	100807.0
2010-08-04	BIL	ETF	91.68	91.7	91.68	91.68	977200.0
2010-08-04	BIS	ETF	10699.2	10699.2	10648.0	10648.0	2.5
2010-08-04	BITS	ETF	28.36	28.4	27.72	27.88	400.0
2010-08-04	BIV	ETF	84.7	84.7	84.24	84.24	374800.0
2010-08-04	BJK	ETF	25.99	26.06	25.85	26.0	37500.0
2010-08-04	BKF	ETF	45.95	46.07	45.58	46.01	86301.0
2010-08-04	BLV	ETF	82.62	82.84	82.06	82.06	75600.0
2010-08-04	BMVP	ETF	12.66	12.78	12.66	12.78	9348.0
2010-08-04	BND	ETF	81.77	81.79	81.62	81.66	1559400.0
2010-08-04	BNE	ETF	11.26	11.3	11.25	11.28	277846.0
2010-08-04	BNO	ETF	27.845	27.845	27.685	27.795	6000.0
2010-08-04	BRF	ETF	49.94	50.5	49.621	50.24	233303.0
2010-08-04	BSCE	ETF	20.77	20.77	20.77	20.77	682.0
2010-08-04	BSV	ETF	81.34	81.34	81.25	81.28	555500.0
2010-08-04	BTF	ETF	71.1	71.1	70.6	70.7	2575.0
2010-08-04	BWX	ETF	29.07	29.08	28.8472	29.035	357728.0
2010-08-04	BWZ	ETF	35.79	35.85	35.56	35.7236	10392.0
2010-08-04	BZQ	ETF	3244.8	3328.0	3216.0	3236.8	1732.5
2010-08-04	CEF	ETF	14.72	14.82	14.61	14.7	826900.0

> showing 50 of 765 rows — these rows as CSV

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