PREVIEW / etf_daily / 2010-10-28

all etf daily files

  file:    by_date/etf_daily/2010/2010-10-28.parquet
  size:    34 KB
  rows:    793

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-10-28	SPY	ETF	119.06	119.11	117.83	118.4	168576000.0
2010-10-28	QQQ	ETF	52.42	52.45	51.84	52.3	61219996.0
2010-10-28	IWM	ETF	71.06	71.12	69.75	70.08	48482400.0
2010-10-28	DIA	ETF	111.77	111.86	110.58	111.1	5657500.0
2010-10-28	GLD	ETF	130.36	131.5	129.84	131.24	15889600.0
2010-10-28	TLT	ETF	99.58	99.83	99.16	99.49	8052600.0
2010-10-28	AADR	ETF	28.77	28.77	28.77	28.77	200.0
2010-10-28	AAXJ	ETF	62.12	62.27	61.9	62.13	335300.0
2010-10-28	ACWI	ETF	45.0	45.0	44.61	44.83	167600.0
2010-10-28	ACWX	ETF	42.85	42.88	42.5481	42.77	37614.0
2010-10-28	ADRE	ETF	46.19	46.19	45.7401	46.0	56327.0
2010-10-28	AFK	ETF	33.2	33.27	33.1	33.27	12018.0
2010-10-28	AGG	ETF	108.15	108.35	108.15	108.32	505300.0
2010-10-28	AGQ	ETF	195.62	199.86	192.44	198.72	269750.0
2010-10-28	AGZ	ETF	111.48	111.49	111.332	111.38	10500.0
2010-10-28	AIA	ETF	43.95	43.98	43.6909	43.87	15516.0
2010-10-28	AIQ	ETF	20.35	20.35	18.6	18.95	86286.0
2010-10-28	AIS	ETF	1.39	1.5	1.39	1.41	515354.0
2010-10-28	AIVI	ETF	45.39	45.39	45.1	45.27	5600.0
2010-10-28	AMJ	ETF	35.33	35.33	35.05	35.22	480200.0
2010-10-28	AMLP	ETF	79.65	79.65	79.0	79.25	127280.0
2010-10-28	AOA	ETF	32.74	32.75	32.42	32.62	3800.0
2010-10-28	AOK	ETF	28.76	28.76	28.67	28.73	13833.0
2010-10-28	AOM	ETF	29.59	29.6	29.5195	29.5764	1803.0
2010-10-28	AOR	ETF	30.76	30.76	30.574	30.68	12174.0
2010-10-28	ARB	ETF	26.53	26.61	25.55	25.96	364644.0
2010-10-28	BAB	ETF	26.1	26.1	26.0	26.06	118021.0
2010-10-28	BAL	ETF	60.54	60.79	59.63	59.89	40445.0
2010-10-28	BALT	ETF	11.29	11.38	11.05	11.22	153678.0
2010-10-28	BBH	ETF	33.8667	34.1933	33.8667	34.0533	156900.0
2010-10-28	BIB	ETF	6.87	6.9025	6.8625	6.9025	18800.0
2010-10-28	BICK	ETF	32.72	32.72	32.45	32.59	104004.0
2010-10-28	BIL	ETF	91.72	91.72	91.7	91.7	86600.0
2010-10-28	BIS	ETF	8931.2	9000.0	8929.6	8984.0	58.5
2010-10-28	BITS	ETF	28.0	28.2	27.44	28.1196	3388.0
2010-10-28	BIV	ETF	86.37	86.67	86.27	86.62	107200.0
2010-10-28	BJK	ETF	30.77	31.0	30.69	30.87	47200.0
2010-10-28	BKF	ETF	49.2	49.28	48.8	49.02	112331.0
2010-10-28	BLV	ETF	83.07	83.4	83.0	83.13	87100.0
2010-10-28	BMVP	ETF	13.74	13.78	13.65	13.73	11711.0
2010-10-28	BND	ETF	82.42	82.55	82.37	82.55	700500.0
2010-10-28	BNE	ETF	11.35	11.37	11.34	11.35	220310.0
2010-10-28	BNO	ETF	27.94	27.94	27.94	27.94	2800.0
2010-10-28	BRF	ETF	59.31	59.31	58.56	59.07	418520.0
2010-10-28	BSCE	ETF	20.99	21.01	20.9761	20.99	12634.0
2010-10-28	BSV	ETF	81.84	81.9	81.8	81.9	428500.0
2010-10-28	BTF	ETF	78.25	78.49999999999999	77.35	77.69999999999999	3708.6000000000004
2010-10-28	BWX	ETF	30.345	30.535	30.235	30.445	1581936.0
2010-10-28	BWZ	ETF	37.39	37.67	37.39	37.64	287762.0
2010-10-28	BZQ	ETF	2688.0	2758.4	2665.6	2713.6	435.0

> showing 50 of 793 rows — these rows as CSV

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