PREVIEW / etf_daily / 2010-07-22

all etf daily files

  file:    by_date/etf_daily/2010/2010-07-22.parquet
  size:    33 KB
  rows:    764

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-07-22	SPY	ETF	108.34	109.94	108.33	109.46	274781300.0
2010-07-22	QQQ	ETF	45.26	45.98	45.24	45.77	82890241.0
2010-07-22	IWM	ETF	62.18	63.66	62.17	63.42	81000700.0
2010-07-22	DIA	ETF	102.25	103.71	102.22	103.25	10386600.0
2010-07-22	GLD	ETF	115.95	117.5	115.91	116.86	8161000.0
2010-07-22	TLT	ETF	101.51	101.52	100.82	100.85	5759700.0
2010-07-22	AADR	ETF	25.42	25.42	25.13	25.26	17500.0
2010-07-22	AAXJ	ETF	55.02	55.59	54.82	55.41	967400.0
2010-07-22	ACWI	ETF	40.18	40.61	40.0	40.49	681500.0
2010-07-22	ACWX	ETF	38.28	38.4	38.1601	38.27	43162.0
2010-07-22	ADRE	ETF	41.57	42.25	41.57	42.14	67330.0
2010-07-22	AFK	ETF	29.57	29.9899	29.57	29.72	1071.0
2010-07-22	AGG	ETF	107.63	107.63	107.49	107.62	920000.0
2010-07-22	AGQ	ETF	113.7	118.72	113.7	117.52	198050.0
2010-07-22	AGZ	ETF	110.43	110.67	110.4	110.64	19089.0
2010-07-22	AIA	ETF	39.01	39.23	38.86	39.0778	43485.0
2010-07-22	AIQ	ETF	19.05	19.45	18.9	19.25	25077.0
2010-07-22	AIS	ETF	1.52	1.55	1.48	1.51	292608.0
2010-07-22	AIVI	ETF	39.34	39.88	39.34	39.8	39100.0
2010-07-22	AMJ	ETF	33.5	33.51	33.04	33.18	686948.0
2010-07-22	AOA	ETF	29.74	29.84	29.7	29.76	9100.0
2010-07-22	AOK	ETF	27.737	27.77	27.7	27.72	17680.0
2010-07-22	AOM	ETF	28.2199	28.29	28.19	28.26	7409.0
2010-07-22	AOR	ETF	28.64	28.87	28.64	28.8	5668.0
2010-07-22	ARB	ETF	27.57	29.73	27.54	29.55	345606.0
2010-07-22	BAB	ETF	25.95	26.05	25.9	25.97	201201.0
2010-07-22	BAL	ETF	36.06	36.51	35.85	36.51	2613.0
2010-07-22	BALT	ETF	11.02	11.44	11.02	11.41	177020.0
2010-07-22	BBH	ETF	29.6367	30.3867	29.6367	30.2433	745800.0
2010-07-22	BIB	ETF	5.3662	5.4088	5.34	5.3712	25600.0
2010-07-22	BICK	ETF	28.51	28.59	28.291	28.56	3927.0
2010-07-22	BIL	ETF	91.7	91.72	91.7	91.7	319650.0
2010-07-22	BIS	ETF	12171.2	12172.8	12166.4	12166.4	4.375
2010-07-22	BITS	ETF	26.84	26.92	26.0	26.56	2450.0
2010-07-22	BIV	ETF	84.43	84.43	84.12	84.21	144700.0
2010-07-22	BJK	ETF	24.37	24.54	24.31	24.44	21200.0
2010-07-22	BKF	ETF	43.94	44.41	43.94	44.24	117493.0
2010-07-22	BLV	ETF	82.93	82.98	82.37	82.51	63500.0
2010-07-22	BMVP	ETF	12.22	12.38	12.22	12.31	10410.0
2010-07-22	BND	ETF	81.72	81.72	81.59	81.64	473900.0
2010-07-22	BNE	ETF	11.34	11.37	11.32	11.34	664972.0
2010-07-22	BNO	ETF	25.985	26.33	25.965	26.305	142000.0
2010-07-22	BRF	ETF	47.29	48.5	47.29	48.31	285897.0
2010-07-22	BSCE	ETF	20.67	20.7	20.67	20.67	15561.0
2010-07-22	BSV	ETF	81.19	81.25	81.14	81.21	621300.0
2010-07-22	BTF	ETF	68.25	69.4	68.25	69.14999999999999	3849.0
2010-07-22	BWX	ETF	27.965	28.2	27.93	27.93	120460.0
2010-07-22	BWZ	ETF	34.71	34.94	34.71	34.81	14035.0
2010-07-22	BZQ	ETF	3614.4	3614.4	3441.6	3507.2	1432.5
2010-07-22	CEF	ETF	14.43	14.6	14.33	14.55	600200.0

> showing 50 of 764 rows — these rows as CSV

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