PREVIEW / etf_daily / 2010-07-19

all etf daily files

  file:    by_date/etf_daily/2010/2010-07-19.parquet
  size:    33 KB
  rows:    761

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-19	SPY	ETF	107.05	107.63	106.22	107.29	186709000.0
2010-07-19	QQQ	ETF	44.48	44.81	44.1	44.72	81800740.0
2010-07-19	IWM	ETF	61.27	61.48	60.15	61.33	63879600.0
2010-07-19	DIA	ETF	101.41	101.9	100.76	101.62	7289500.0
2010-07-19	GLD	ETF	115.57	115.8	115.11	115.73	15723900.0
2010-07-19	TLT	ETF	100.56	100.75	99.98	100.18	4305800.0
2010-07-19	AAXJ	ETF	53.68	53.98	53.39	53.89	562900.0
2010-07-19	ACWI	ETF	39.68	39.76	39.25	39.63	95100.0
2010-07-19	ACWX	ETF	37.42	37.44	36.964	37.24	60468.0
2010-07-19	ADRE	ETF	39.91	40.3176	39.86	40.24	94562.0
2010-07-19	AFK	ETF	28.715	28.826	28.6	28.64	15256.0
2010-07-19	AGG	ETF	107.38	107.47	107.26	107.33	425600.0
2010-07-19	AGQ	ETF	112.2	113.4	109.66	111.74	188550.0
2010-07-19	AGZ	ETF	110.4	110.45	110.2938	110.2938	13085.0
2010-07-19	AIA	ETF	37.84	38.1099	37.77	38.1099	18707.0
2010-07-19	AIQ	ETF	20.25	20.65	18.9	19.15	17471.0
2010-07-19	AIS	ETF	1.58	1.59	1.53	1.54	363471.0
2010-07-19	AIVI	ETF	38.98	39.16	38.71	39.05	11000.0
2010-07-19	AMJ	ETF	32.74	32.74	32.36	32.585	280956.0
2010-07-19	AOA	ETF	28.84	29.03	28.84	29.01	24000.0
2010-07-19	AOK	ETF	27.45	27.536	27.45	27.5275	2692.0
2010-07-19	AOM	ETF	27.8974	27.94	27.88	27.94	2172.0
2010-07-19	AOR	ETF	28.4	28.4	28.27	28.37	60931.0
2010-07-19	ARB	ETF	26.34	26.34	25.59	26.17	117534.0
2010-07-19	BAB	ETF	25.95	25.97	25.806	25.88	174061.0
2010-07-19	BAL	ETF	36.41	36.41	35.79	35.846	3346.0
2010-07-19	BALT	ETF	10.73	10.76	10.18	10.58	112192.0
2010-07-19	BBH	ETF	29.2233	29.7167	29.22	29.6967	52800.0
2010-07-19	BICK	ETF	27.13	27.26	27.11	27.26	800.0
2010-07-19	BIL	ETF	91.72	91.72	91.7	91.7	803350.0
2010-07-19	BIS	ETF	12708.8	12708.8	12708.8	12708.8	3.125
2010-07-19	BITS	ETF	27.32	28.0	26.4	26.8	4616.0
2010-07-19	BIV	ETF	84.2	84.2	83.93	84.0	229200.0
2010-07-19	BJK	ETF	23.66	23.68	23.44	23.61	4200.0
2010-07-19	BKF	ETF	42.19	42.524	41.92	42.43	71665.0
2010-07-19	BLV	ETF	82.49	82.49	81.89	82.01	83700.0
2010-07-19	BMVP	ETF	12.01	12.08	11.91	12.01	7380.0
2010-07-19	BND	ETF	81.58	81.61	81.44	81.45	455600.0
2010-07-19	BNE	ETF	11.28	11.28	11.26	11.28	377200.0
2010-07-19	BNO	ETF	25.975	25.975	25.615	25.615	5600.0
2010-07-19	BOSS	ETF	27.645	27.645	27.285	27.285	100.0
2010-07-19	BRF	ETF	45.97	46.2	45.61	45.94	162395.0
2010-07-19	BSCE	ETF	20.69	20.69	20.655	20.666	26918.0
2010-07-19	BSV	ETF	81.15	81.17	81.12	81.16	369700.0
2010-07-19	BTF	ETF	67.89999999999999	68.05	67.45	67.75	1510.0
2010-07-19	BWX	ETF	28.0	28.25	27.6625	28.075	173662.0
2010-07-19	BWZ	ETF	35.02	35.06	34.8101	34.832	12727.0
2010-07-19	BZQ	ETF	4020.8	4059.2	3940.8	3952.0	985.0
2010-07-19	CEF	ETF	14.42	14.49	14.26	14.36	1332900.0
2010-07-19	CEW	ETF	21.52	21.59	21.5	21.57	60552.0

> showing 50 of 761 rows — these rows as CSV

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