PREVIEW / etf_daily / 2009-11-20

all etf daily files

  file:    by_date/etf_daily/2009/2009-11-20.parquet
  size:    30 KB
  rows:    691

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-11-20	SPY	ETF	109.25	109.76	109.01	109.43	134196000.0
2009-11-20	QQQ	ETF	43.41	43.55	43.28	43.44	70912056.0
2009-11-20	IWM	ETF	58.22	58.8	58.09	58.59	39780100.0
2009-11-20	DIA	ETF	102.92	103.45	102.72	103.25	8680400.0
2009-11-20	GLD	ETF	111.74	112.94	111.54	112.94	17302500.0
2009-11-20	TLT	ETF	95.0	95.37	94.59	95.12	4136300.0
2009-11-20	AAXJ	ETF	54.51	55.3	54.51	55.2	215700.0
2009-11-20	ACWI	ETF	41.87	41.94	41.63	41.88	149200.0
2009-11-20	ACWX	ETF	40.47	40.72	40.27	40.69	120038.0
2009-11-20	ADRE	ETF	44.15	44.15	43.631	44.01	145135.0
2009-11-20	AFK	ETF	28.22	28.48	28.066	28.35	8455.0
2009-11-20	AGG	ETF	105.16	105.2	105.03	105.17	422500.0
2009-11-20	AGQ	ETF	134.14	138.3	133.7	138.22	236300.0
2009-11-20	AGZ	ETF	108.93	108.94	108.66	108.8106	12369.0
2009-11-20	AIA	ETF	39.41	39.59	39.3135	39.45	46581.0
2009-11-20	AIQ	ETF	27.9	28.1	27.45	27.85	17142.0
2009-11-20	AIS	ETF	1.1	1.15	1.09	1.1399	163796.0
2009-11-20	AIVI	ETF	43.59	43.83	43.33	43.83	29000.0
2009-11-20	AMJ	ETF	26.91	27.0	26.55	26.65	124695.0
2009-11-20	AOA	ETF	29.2	29.3	29.19	29.3	27500.0
2009-11-20	AOK	ETF	27.48	27.48	27.3782	27.42	5212.0
2009-11-20	AOM	ETF	28.13	28.14	28.0773	28.14	7999.0
2009-11-20	AOR	ETF	28.67	28.73	28.6	28.73	47315.0
2009-11-20	ARB	ETF	21.98	22.62	21.93	22.28	257805.0
2009-11-20	BAB	ETF	24.98	25.01	24.87	25.01	101560.0
2009-11-20	BAL	ETF	35.98	36.45	35.98	36.45	11346.0
2009-11-20	BBH	ETF	32.0433	32.21	31.8833	32.1367	570300.0
2009-11-20	BIL	ETF	91.7	91.72	91.68	91.7	205250.0
2009-11-20	BITS	ETF	27.12	27.2	26.96	27.0	4750.0
2009-11-20	BIV	ETF	80.9	80.91	80.67	80.86	131700.0
2009-11-20	BJK	ETF	25.0	25.0	24.6	24.77	8300.0
2009-11-20	BKF	ETF	46.4	46.4	45.7	46.18	145223.0
2009-11-20	BLV	ETF	78.12	78.18	77.73	78.07	71100.0
2009-11-20	BMVP	ETF	12.16	12.18	12.12	12.17	15236.0
2009-11-20	BND	ETF	79.77	79.82	79.69	79.73	476900.0
2009-11-20	BNE	ETF	5.99	6.15	5.9	6.11	150332.0
2009-11-20	BOSS	ETF	19.82	19.82	19.31	19.7	100.0
2009-11-20	BRF	ETF	46.2	46.3074	45.35	46.14	404331.0
2009-11-20	BSV	ETF	80.44	80.44	80.3	80.33	374700.0
2009-11-20	BTF	ETF	63.75149999999999	64.19999999999999	63.75	63.949999999999996	2053.2000000000003
2009-11-20	BWX	ETF	29.63	29.695	29.525	29.65	346140.0
2009-11-20	BWZ	ETF	37.64	37.72	37.4	37.6951	34867.0
2009-11-20	BZQ	ETF	3996.8	4081.6	3955.2	3990.4	154.5
2009-11-20	CEF	ETF	14.32	14.49	14.22	14.42	1338000.0
2009-11-20	CEW	ETF	22.14	22.14	22.06	22.07	112223.0
2009-11-20	CGO	ETF	13.75	13.77	13.6	13.75	21975.0
2009-11-20	CGW	ETF	17.83	18.0099	17.8	17.93	57377.0
2009-11-20	CHI	ETF	11.94	12.02	11.9025	11.96	149445.0
2009-11-20	CHW	ETF	7.64	7.77	7.58	7.74	331751.0
2009-11-20	CHY	ETF	11.36	11.42	11.22	11.27	212169.0

> showing 50 of 691 rows — these rows as CSV

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