PREVIEW / etf_daily / 2010-12-22

all etf daily files

  file:    by_date/etf_daily/2010/2010-12-22.parquet
  size:    35 KB
  rows:    822

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-12-22	SPY	ETF	125.48	125.82	125.41	125.78	78878100.0
2010-12-22	QQQ	ETF	54.86	54.96	54.79	54.885	35766427.0
2010-12-22	IWM	ETF	79.03	79.18	78.72	78.82	29812300.0
2010-12-22	DIA	ETF	115.35	115.66	115.25	115.58	3487300.0
2010-12-22	GLD	ETF	135.6	135.7	134.97	135.05	7300600.0
2010-12-22	TLT	ETF	93.47	93.55	92.93	93.12	6440900.0
2010-12-22	AADR	ETF	29.55	29.55	29.46	29.52	5400.0
2010-12-22	AAXJ	ETF	62.85	62.92	62.74	62.88	205300.0
2010-12-22	ACWI	ETF	46.37	46.42	46.24	46.39	1908100.0
2010-12-22	ACWX	ETF	43.44	43.54	43.39	43.52	39807.0
2010-12-22	ADRE	ETF	46.81	47.16	46.74	47.16	45575.0
2010-12-22	AFK	ETF	34.79	34.79	34.48	34.69	23033.0
2010-12-22	AGG	ETF	105.71	105.71	105.4	105.52	669500.0
2010-12-22	AGQ	ETF	287.58	288.6	285.0	285.56	189650.0
2010-12-22	AGZ	ETF	109.7	109.7	109.44	109.55	10670.0
2010-12-22	AIA	ETF	46.03	46.16	46.03	46.15	16612.0
2010-12-22	AIQ	ETF	18.75	20.25	18.65	20.25	52018.0
2010-12-22	AIS	ETF	1.71	1.79	1.66	1.7	1361755.0
2010-12-22	AIVI	ETF	43.73	43.74	43.57	43.69	70700.0
2010-12-22	AMJ	ETF	35.46	35.77	35.38	35.74	1769417.0
2010-12-22	AMLP	ETF	79.0	79.35	78.95	79.3	105620.0
2010-12-22	AOA	ETF	34.44	34.51	34.4	34.45	18900.0
2010-12-22	AOK	ETF	28.84	28.84	28.73	28.79	10640.0
2010-12-22	AOM	ETF	30.01	32.65	29.95	30.02	23124.0
2010-12-22	AOR	ETF	31.56	31.65	31.56	31.6	13025.0
2010-12-22	ARB	ETF	42.05	42.55	41.95	42.25	329746.0
2010-12-22	BAB	ETF	24.96	24.97	24.8	24.88	227271.0
2010-12-22	BAL	ETF	77.0	77.04	75.3	76.25	98274.0
2010-12-22	BALT	ETF	10.8	10.83	10.56	10.65	228860.0
2010-12-22	BBH	ETF	33.83	33.83	33.67	33.7233	53100.0
2010-12-22	BIB	ETF	7.6975	7.6975	7.6588	7.6722	51880.0
2010-12-22	BICK	ETF	32.27	32.27	32.0	32.25	23361.0
2010-12-22	BIL	ETF	91.72	91.72	91.7	91.7	97250.0
2010-12-22	BIS	ETF	7942.4	7942.4	7942.4	7942.4	3.125
2010-12-22	BITS	ETF	28.8	28.8	28.12	28.8	2775.0
2010-12-22	BIV	ETF	83.18	83.18	82.76	82.89	140200.0
2010-12-22	BJK	ETF	32.05	32.06	31.7	31.87	14200.0
2010-12-22	BKF	ETF	48.21	48.65	48.21	48.59	217898.0
2010-12-22	BLV	ETF	79.23	79.41	78.97	79.26	115800.0
2010-12-22	BMVP	ETF	14.73	14.75	14.7	14.73	11691.0
2010-12-22	BND	ETF	80.58	80.62	80.43	80.49	546700.0
2010-12-22	BNO	ETF	31.175	31.235	31.155	31.155	4000.0
2010-12-22	BRF	ETF	57.86	58.107	57.36	57.6	390201.0
2010-12-22	BSCE	ETF	20.68	20.71	20.668	20.668	7496.0
2010-12-22	BSV	ETF	80.77	80.82	80.69	80.74	354400.0
2010-12-22	BTF	ETF	76.8	77.69999999999999	76.8	77.53999999999999	2228.0
2010-12-22	BWX	ETF	28.635	28.695	28.575	28.665	233234.0
2010-12-22	BWZ	ETF	36.1	36.22	36.0201	36.2	33575.0
2010-12-22	BZQ	ETF	2688.0	2710.4	2624.0	2624.0	417.5
2010-12-22	CEF	ETF	20.05	20.06	19.83	19.87	767000.0

> showing 50 of 822 rows — these rows as CSV

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