PREVIEW / etf_daily / 2010-09-01

all etf daily files

  file:    by_date/etf_daily/2010/2010-09-01.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-09-01	SPY	ETF	106.73	108.61	106.66	108.46	256828100.0
2010-09-01	QQQ	ETF	44.1	44.91	44.07	44.76	83523097.0
2010-09-01	IWM	ETF	61.23	62.55	61.02	62.51	62585200.0
2010-09-01	DIA	ETF	101.36	102.9	101.33	102.8	8511100.0
2010-09-01	GLD	ETF	122.15	122.21	121.43	121.69	11873500.0
2010-09-01	TLT	ETF	107.02	107.05	105.09	106.0	12480700.0
2010-09-01	AADR	ETF	25.67	25.95	25.67	25.95	1500.0
2010-09-01	AAXJ	ETF	55.23	56.0	55.23	55.95	582600.0
2010-09-01	ACWI	ETF	40.1	40.61	40.05	40.56	158800.0
2010-09-01	ACWX	ETF	38.46	38.91	38.41	38.89	63005.0
2010-09-01	ADRE	ETF	41.42	42.21	41.42	42.17	350708.0
2010-09-01	AFK	ETF	30.47	30.47	30.14	30.27	41740.0
2010-09-01	AGG	ETF	108.42	108.55	108.07	108.41	976100.0
2010-09-01	AGQ	ETF	132.84	132.98	131.64	132.8	136150.0
2010-09-01	AGZ	ETF	111.18	111.18	110.9028	111.03	11879.0
2010-09-01	AIA	ETF	39.03	39.55	39.03	39.55	115192.0
2010-09-01	AIQ	ETF	21.25	21.95	21.2	21.95	16108.0
2010-09-01	AIS	ETF	1.46	1.54	1.45	1.54	506113.0
2010-09-01	AIVI	ETF	40.19	40.73	40.19	40.58	7400.0
2010-09-01	AMJ	ETF	32.38	32.45	32.1	32.335	440686.0
2010-09-01	AMLP	ETF	75.45	75.5	75.05	75.35	99380.0
2010-09-01	AOA	ETF	29.34	29.75	29.34	29.74	29400.0
2010-09-01	AOK	ETF	27.89	27.93	27.845	27.908	8340.0
2010-09-01	AOM	ETF	28.28	28.436	28.28	28.436	8564.0
2010-09-01	AOR	ETF	28.7	28.92	28.67	28.863	7597.0
2010-09-01	ARB	ETF	25.73	26.53	25.57	26.48	136478.0
2010-09-01	BAB	ETF	26.88	26.88	26.626	26.785	257130.0
2010-09-01	BAL	ETF	42.55	43.04	42.52	43.03	18241.0
2010-09-01	BALT	ETF	11.35	11.43	11.23	11.34	149941.0
2010-09-01	BBH	ETF	30.1333	30.6367	30.0933	30.6367	109500.0
2010-09-01	BICK	ETF	28.7	29.18	28.69	29.17	13941.0
2010-09-01	BIL	ETF	91.7	91.72	91.7	91.7	599600.0
2010-09-01	BIS	ETF	11305.6	11305.6	11305.6	11305.6	1.54
2010-09-01	BITS	ETF	24.32	25.572	24.044	24.32	1752.0
2010-09-01	BIV	ETF	86.14	86.14	85.59	85.8	231400.0
2010-09-01	BJK	ETF	25.6	26.14	25.6	26.12	23200.0
2010-09-01	BKF	ETF	43.72	44.62	43.72	44.46	173017.0
2010-09-01	BLV	ETF	86.22	86.55	85.36	85.92	61600.0
2010-09-01	BMVP	ETF	12.09	12.3	12.09	12.3	19080.0
2010-09-01	BND	ETF	82.58	82.6	82.24	82.4	547900.0
2010-09-01	BNE	ETF	11.11	11.11	10.93	10.96	1004608.0
2010-09-01	BNO	ETF	25.76	25.79	25.635	25.75	109600.0
2010-09-01	BRF	ETF	52.04	52.89	52.04	52.5	479744.0
2010-09-01	BSCE	ETF	20.85	20.86	20.84	20.85	10157.0
2010-09-01	BSV	ETF	81.57	81.57	81.38	81.38	620800.0
2010-09-01	BTF	ETF	69.85	70.5	69.6	70.5	6866.200000000001
2010-09-01	BWX	ETF	29.185	29.24	28.815	28.915	788496.0
2010-09-01	BWZ	ETF	35.32	35.41	35.28	35.3	89712.0
2010-09-01	BZQ	ETF	3430.4	3432.0	3244.8	3265.6	1476.0
2010-09-01	CEF	ETF	15.61	15.74	15.5	15.57	899900.0

> showing 50 of 764 rows — these rows as CSV

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