PREVIEW / etf_daily / 2010-12-02

all etf daily files

  file:    by_date/etf_daily/2010/2010-12-02.parquet
  size:    35 KB
  rows:    809

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-02	SPY	ETF	121.2	122.65	121.13	122.56	191213600.0
2010-12-02	QQQ	ETF	53.27	53.81	53.21	53.73	56883981.0
2010-12-02	IWM	ETF	74.47	75.29	74.36	75.13	42529200.0
2010-12-02	DIA	ETF	112.77	113.87	112.75	113.74	6146200.0
2010-12-02	GLD	ETF	135.62	136.59	135.15	135.2	17583800.0
2010-12-02	TLT	ETF	95.96	96.54	95.53	95.64	9318700.0
2010-12-02	AADR	ETF	28.78	29.24	28.78	29.2	25300.0
2010-12-02	AAXJ	ETF	62.8	63.75	62.75	63.75	532300.0
2010-12-02	ACWI	ETF	45.06	45.76	45.03	45.75	268400.0
2010-12-02	ACWX	ETF	42.46	43.24	42.37	43.24	185438.0
2010-12-02	ADRE	ETF	46.21	46.89	46.21	46.86	53680.0
2010-12-02	AFK	ETF	33.2	33.78	33.18	33.76	28579.0
2010-12-02	AGG	ETF	106.32	106.35	106.04	106.05	1124900.0
2010-12-02	AGQ	ETF	273.76	284.48	272.66	275.94	669150.0
2010-12-02	AGZ	ETF	110.32	110.39	110.226	110.238	8019.0
2010-12-02	AIA	ETF	45.36	45.86	45.32	45.83	19277.0
2010-12-02	AIQ	ETF	18.9	19.0	17.95	18.05	70894.0
2010-12-02	AIS	ETF	1.43	1.45	1.42	1.44	150289.0
2010-12-02	AIVI	ETF	42.09	43.07	41.96	43.06	68600.0
2010-12-02	AMJ	ETF	35.64	35.86	35.5	35.69	1890982.0
2010-12-02	AMLP	ETF	79.45	79.5	79.0	79.3	248180.0
2010-12-02	AOA	ETF	33.23	33.58	33.23	33.57	4700.0
2010-12-02	AOK	ETF	28.63	28.67	28.5787	28.61	12054.0
2010-12-02	AOM	ETF	29.55	29.74	29.55	29.74	27150.0
2010-12-02	AOR	ETF	30.85	31.09	30.8325	31.09	11841.0
2010-12-02	ARB	ETF	29.96	30.12	29.62	30.0	111129.0
2010-12-02	BAB	ETF	25.35	25.35	25.14	25.16	343232.0
2010-12-02	BAL	ETF	63.76	64.899	63.64	64.77	59740.0
2010-12-02	BALT	ETF	11.82	12.04	11.57	11.67	185038.0
2010-12-02	BBH	ETF	32.76	33.1233	32.6533	33.1133	54900.0
2010-12-02	BIB	ETF	6.7475	6.7625	6.7438	6.7625	14528.0
2010-12-02	BICK	ETF	32.5	32.79	32.5	32.756	125961.0
2010-12-02	BIL	ETF	91.7	91.72	91.7	91.7	188400.0
2010-12-02	BIS	ETF	9049.6	9049.6	9049.6	9049.6	1.875
2010-12-02	BITS	ETF	28.4	28.6	28.24	28.6	1886.0
2010-12-02	BIV	ETF	84.51	84.73	84.36	84.36	366600.0
2010-12-02	BJK	ETF	31.64	31.81	31.3	31.68	37900.0
2010-12-02	BKF	ETF	49.0	49.7599	49.0	49.67	169876.0
2010-12-02	BLV	ETF	80.34	80.89	80.21	80.3	67400.0
2010-12-02	BMVP	ETF	14.4	14.54	14.4	14.54	19532.0
2010-12-02	BND	ETF	81.15	81.32	81.1	81.12	720300.0
2010-12-02	BNO	ETF	29.945	30.17	29.945	30.17	4400.0
2010-12-02	BRF	ETF	60.24	60.75	60.12	60.75	318705.0
2010-12-02	BSCE	ETF	20.75	20.75	20.69	20.73	7893.0
2010-12-02	BSV	ETF	81.11	81.11	80.99	81.04	1043800.0
2010-12-02	BTF	ETF	77.94999999999999	78.94999999999999	77.75	78.75	2795.0
2010-12-02	BWX	ETF	28.59	28.865	28.583	28.835	282760.0
2010-12-02	BWZ	ETF	36.24	36.672	36.19	36.5	51481.0
2010-12-02	BZQ	ETF	2644.8	2648.0	2592.0	2603.2	880.0
2010-12-02	CEF	ETF	19.49	19.77	19.49	19.57	801200.0

> showing 50 of 809 rows — these rows as CSV

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