PREVIEW / etf_daily / 2009-12-04

all etf daily files

  file:    by_date/etf_daily/2009/2009-12-04.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-04	SPY	ETF	111.84	112.38	110.04	111.01	274907800.0
2009-12-04	QQQ	ETF	44.45	44.73	43.66	44.12	125062510.0
2009-12-04	IWM	ETF	60.2	60.87	59.28	60.42	100434300.0
2009-12-04	DIA	ETF	104.96	105.27	103.2	103.99	16602800.0
2009-12-04	GLD	ETF	117.15	117.26	112.41	113.75	79182600.0
2009-12-04	TLT	ETF	93.29	93.65	92.91	93.34	6108100.0
2009-12-04	AAXJ	ETF	57.03	57.06	55.94	56.52	155300.0
2009-12-04	ACWI	ETF	43.24	43.25	42.35	42.73	53800.0
2009-12-04	ACWX	ETF	42.04	42.28	41.3	41.59	661798.0
2009-12-04	ADRE	ETF	45.86	45.92	44.5	45.04	347648.0
2009-12-04	AFK	ETF	28.76	29.03	28.29	28.3	2086.0
2009-12-04	AGG	ETF	104.67	104.9	104.47	104.82	1243100.0
2009-12-04	AGQ	ETF	141.12	141.44	133.5	136.86	490400.0
2009-12-04	AGZ	ETF	108.31	108.558	108.246	108.32	14331.0
2009-12-04	AIA	ETF	40.39	40.53	39.74	40.1	50420.0
2009-12-04	AIQ	ETF	29.25	29.95	29.2	29.9	27663.0
2009-12-04	AIS	ETF	1.21	1.21	1.114	1.16	317496.0
2009-12-04	AIVI	ETF	45.03	45.17	44.33	44.56	42400.0
2009-12-04	AMJ	ETF	26.89	26.9	26.53	26.74	219604.0
2009-12-04	AOA	ETF	29.85	29.85	29.67	29.81	2200.0
2009-12-04	AOK	ETF	27.62	27.62	27.5192	27.52	2480.0
2009-12-04	AOM	ETF	28.52	28.52	28.2506	28.36	12469.0
2009-12-04	AOR	ETF	29.2	29.32	28.97	29.08	17371.0
2009-12-04	ARB	ETF	21.79	22.28	21.7	21.9	430125.0
2009-12-04	BAB	ETF	24.82	24.82	24.5	24.68	93886.0
2009-12-04	BAL	ETF	35.0	36.62	35.0	36.29	12943.0
2009-12-04	BBH	ETF	32.67	33.0067	32.55	32.71	140400.0
2009-12-04	BIL	ETF	91.7	91.74	91.7	91.74	75150.0
2009-12-04	BITS	ETF	27.4	27.4	26.2004	26.88	1470.0
2009-12-04	BIV	ETF	80.98	80.98	80.03	80.3	130600.0
2009-12-04	BJK	ETF	24.95	25.28	24.64	24.82	17700.0
2009-12-04	BKF	ETF	47.68	47.88	46.33	46.99	214751.0
2009-12-04	BLV	ETF	77.94	78.03	77.5	77.5	24200.0
2009-12-04	BMVP	ETF	12.327	12.457	12.214	12.323	27815.0
2009-12-04	BND	ETF	79.36	79.46	79.26	79.37	618000.0
2009-12-04	BNE	ETF	6.19	6.44	6.09	6.38	162358.0
2009-12-04	BOSS	ETF	19.0	19.0	19.0	19.0	100.0
2009-12-04	BRF	ETF	50.38	50.48	48.5	49.1	521799.0
2009-12-04	BSV	ETF	80.21	80.21	79.98	80.13	478300.0
2009-12-04	BTF	ETF	64.19999999999999	64.19999999999999	62.5	63.3	5786.8
2009-12-04	BWX	ETF	29.85	29.855	29.545	29.64	498134.0
2009-12-04	BWZ	ETF	37.99	37.99	37.35	37.479	77838.0
2009-12-04	BZQ	ETF	3452.8	3734.4	3416.0	3670.4	621.0
2009-12-04	CEF	ETF	14.95	14.98	14.41	14.62	2735400.0
2009-12-04	CEW	ETF	22.44	22.46	22.27	22.34	98937.0
2009-12-04	CGO	ETF	14.06	14.3	13.87	14.13	22022.0
2009-12-04	CGW	ETF	18.67	18.8	18.39	18.54	99088.0
2009-12-04	CHI	ETF	12.23	12.23	12.05	12.09	208198.0
2009-12-04	CHII	ETF	16.64	16.75	16.4	16.57	114724.0
2009-12-04	CHIQ	ETF	16.7	16.75	16.4	16.57	39416.0

> showing 50 of 699 rows — these rows as CSV

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