PREVIEW / etf_daily / 2010-12-23

all etf daily files

  file:    by_date/etf_daily/2010/2010-12-23.parquet
  size:    35 KB
  rows:    816

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-23	SPY	ETF	125.64	125.78	125.29	125.6	70053700.0
2010-12-23	QQQ	ETF	54.78	54.87	54.61	54.742	21668244.0
2010-12-23	IWM	ETF	78.96	79.12	78.61	78.72	25239600.0
2010-12-23	DIA	ETF	115.51	115.79	115.4	115.73	3578800.0
2010-12-23	GLD	ETF	134.26	134.9	133.93	134.66	8700800.0
2010-12-23	TLT	ETF	93.18	93.23	92.53	92.93	7091800.0
2010-12-23	AADR	ETF	29.58	29.68	29.42	29.55	3200.0
2010-12-23	AAXJ	ETF	62.67	62.7	62.42	62.63	257000.0
2010-12-23	ACWI	ETF	46.4	46.49	46.19	46.37	1932800.0
2010-12-23	ACWX	ETF	43.42	43.6	43.38	43.56	133152.0
2010-12-23	ADRE	ETF	46.97	47.06	46.87	47.01	32790.0
2010-12-23	AFK	ETF	34.11	34.53	34.11	34.488	15654.0
2010-12-23	AGG	ETF	105.41	105.44	105.25	105.32	1285800.0
2010-12-23	AGQ	ETF	281.82	288.2	278.94	285.66	266000.0
2010-12-23	AGZ	ETF	109.52	109.53	109.39	109.45	19695.0
2010-12-23	AIA	ETF	46.01	46.01	45.79	45.87	40242.0
2010-12-23	AIQ	ETF	20.25	20.8	20.1	20.6	29023.0
2010-12-23	AIS	ETF	1.75	1.75	1.62	1.64	624406.0
2010-12-23	AIVI	ETF	43.49	43.76	43.49	43.65	18200.0
2010-12-23	AMJ	ETF	35.79	35.9	35.75	35.81	561755.0
2010-12-23	AMLP	ETF	79.45	79.55	79.3	79.35	102380.0
2010-12-23	AOA	ETF	34.45	34.49	34.38	34.42	9400.0
2010-12-23	AOK	ETF	28.7201	28.7599	28.72	28.7499	10064.0
2010-12-23	AOM	ETF	29.9525	30.01	29.9301	30.0	36746.0
2010-12-23	AOR	ETF	31.62	31.63	31.5505	31.61	48887.0
2010-12-23	ARB	ETF	42.17	42.25	41.42	41.49	245902.0
2010-12-23	BAB	ETF	24.93	24.93	24.83	24.92	129441.0
2010-12-23	BAL	ETF	76.42	78.87	75.0201	75.16	48760.0
2010-12-23	BALT	ETF	10.64	10.74	10.6244	10.65	166363.0
2010-12-23	BBH	ETF	33.6667	33.6667	33.49	33.59	11400.0
2010-12-23	BIB	ETF	7.8587	7.8587	7.5	7.679	14400.0
2010-12-23	BICK	ETF	32.42	32.42	31.88	32.069	21423.0
2010-12-23	BIL	ETF	91.7	91.72	91.7	91.7	88000.0
2010-12-23	BITS	ETF	28.8	28.8	28.36	28.8	1368.0
2010-12-23	BIV	ETF	82.85	82.86	82.53	82.59	171700.0
2010-12-23	BJK	ETF	31.07	31.19	30.92	30.99	154100.0
2010-12-23	BKF	ETF	48.26	48.5	48.15	48.4981	149493.0
2010-12-23	BLV	ETF	79.24	79.29	78.8	79.25	375000.0
2010-12-23	BMVP	ETF	14.7133	14.7231	14.6667	14.68	10583.0
2010-12-23	BND	ETF	80.43	80.43	80.32	80.4	477000.0
2010-12-23	BNO	ETF	31.4	31.41	31.365	31.41	5400.0
2010-12-23	BRF	ETF	54.23	54.81	53.68	54.7	413572.0
2010-12-23	BSCE	ETF	20.65	20.69	20.581	20.6471	13151.0
2010-12-23	BSV	ETF	80.67	80.73	80.62	80.69	534800.0
2010-12-23	BTF	ETF	77.35	78.2505	76.8505	77.85	4345.0
2010-12-23	BWX	ETF	28.615	28.78	28.615	28.77	244954.0
2010-12-23	BWZ	ETF	36.0	36.37	36.0	36.225	18055.0
2010-12-23	BZQ	ETF	2657.6	2660.8	2614.4	2622.4	202.5
2010-12-23	CEF	ETF	19.74	19.84	19.69	19.82	763700.0
2010-12-23	CEW	ETF	22.15	22.23	22.15	22.23	45307.0

> showing 50 of 816 rows — these rows as CSV

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