PREVIEW / etf_daily / 2009-12-01

all etf daily files

  file:    by_date/etf_daily/2009/2009-12-01.parquet
  size:    30 KB
  rows:    699

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
2009-12-01	SPY	ETF	110.92	111.66	110.73	111.3	159613700.0
2009-12-01	QQQ	ETF	43.88	44.3	43.88	44.01	81817784.0
2009-12-01	IWM	ETF	58.64	59.23	58.46	58.99	63141300.0
2009-12-01	DIA	ETF	104.28	105.13	104.27	104.73	10101300.0
2009-12-01	GLD	ETF	117.3	117.93	116.78	117.38	27721300.0
2009-12-01	TLT	ETF	95.76	95.93	95.19	95.25	3979100.0
2009-12-01	AAXJ	ETF	55.72	56.02	55.41	55.83	1318500.0
2009-12-01	ACWI	ETF	42.36	42.82	42.36	42.69	136100.0
2009-12-01	ACWX	ETF	41.46	41.87	41.37	41.76	172587.0
2009-12-01	ADRE	ETF	45.0	45.41	44.65	45.17	153741.0
2009-12-01	AFK	ETF	28.2101	28.901	28.2101	28.8999	3850.0
2009-12-01	AGG	ETF	105.35	105.42	105.17	105.22	788800.0
2009-12-01	AGQ	ETF	141.86	148.46	140.62	146.0	463100.0
2009-12-01	AGZ	ETF	109.2	109.2	108.88	109.01	13375.0
2009-12-01	AIA	ETF	39.36	39.82	39.36	39.59	53487.0
2009-12-01	AIQ	ETF	29.85	30.15	29.35	29.9	38354.0
2009-12-01	AIS	ETF	1.12	1.14	1.1	1.13	266853.0
2009-12-01	AIVI	ETF	44.29	44.82	44.29	44.7	18800.0
2009-12-01	AMJ	ETF	26.96	27.0	26.75	26.83	205875.0
2009-12-01	AOA	ETF	29.4	29.87	29.4	29.8	9000.0
2009-12-01	AOK	ETF	27.68	27.68	27.4	27.6199	10427.0
2009-12-01	AOM	ETF	28.5	28.5	28.35	28.5	24596.0
2009-12-01	AOR	ETF	29.36	29.36	28.998	29.1	46834.0
2009-12-01	ARB	ETF	21.73	21.97	21.43	21.73	244935.0
2009-12-01	BAB	ETF	25.05	25.05	24.86	24.95	193941.0
2009-12-01	BAL	ETF	36.61	36.64	36.0	36.02	9977.0
2009-12-01	BBH	ETF	32.2967	32.8467	32.2967	32.7433	110700.0
2009-12-01	BIL	ETF	91.74	91.74	91.7	91.72	124650.0
2009-12-01	BITS	ETF	27.4	27.8	26.204	27.6	1907.0
2009-12-01	BIV	ETF	81.37	81.37	81.02	81.13	101300.0
2009-12-01	BJK	ETF	24.76	25.3	24.76	25.19	9200.0
2009-12-01	BKF	ETF	46.61	47.24	46.38	47.06	233769.0
2009-12-01	BLV	ETF	78.55	78.77	78.36	78.58	111300.0
2009-12-01	BMVP	ETF	12.227	12.346	12.227	12.3	12112.0
2009-12-01	BND	ETF	80.06	80.1	79.89	79.89	535900.0
2009-12-01	BNE	ETF	6.09	6.36	6.09	6.2	110940.0
2009-12-01	BOSS	ETF	19.1	19.38	19.1	19.38	100.0
2009-12-01	BRF	ETF	48.37	49.19	48.37	48.9	302608.0
2009-12-01	BSV	ETF	80.55	80.55	80.41	80.44	658300.0
2009-12-01	BTF	ETF	63.25	63.65	62.85	63.25	8605.0
2009-12-01	BWX	ETF	30.26	30.365	30.235	30.305	397720.0
2009-12-01	BWZ	ETF	38.25	38.35	38.16	38.28	37538.0
2009-12-01	BZQ	ETF	3680.0	3696.0	3539.2	3585.6	552.0
2009-12-01	CEF	ETF	15.13	15.15	14.98	15.13	2264400.0
2009-12-01	CEW	ETF	22.78	22.78	22.2508	22.38	233360.0
2009-12-01	CGO	ETF	14.0	14.12	13.9	14.0	31191.0
2009-12-01	CGW	ETF	18.19	18.57	18.19	18.47	1074795.0
2009-12-01	CHI	ETF	12.09	12.3	11.96	12.23	197757.0
2009-12-01	CHII	ETF	16.32	16.32	16.0	16.07	41370.0
2009-12-01	CHIQ	ETF	16.37	16.4	16.15	16.34	52673.0

> showing 50 of 699 rows — these rows as CSV

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