PREVIEW / etf_daily / 2009-11-16

all etf daily files

  file:    by_date/etf_daily/2009/2009-11-16.parquet
  size:    30 KB
  rows:    680

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-16	SPY	ETF	110.38	111.69	110.32	111.21	210922200.0
2009-11-16	QQQ	ETF	44.19	44.65	44.12	44.46	87776089.0
2009-11-16	IWM	ETF	59.12	60.68	59.12	60.28	66099700.0
2009-11-16	DIA	ETF	103.4	104.57	103.35	104.26	10497400.0
2009-11-16	GLD	ETF	110.7	112.16	110.65	111.63	25002300.0
2009-11-16	TLT	ETF	94.65	95.45	94.52	95.02	5175700.0
2009-11-16	AAXJ	ETF	56.33	56.89	56.0	56.81	347300.0
2009-11-16	ACWI	ETF	42.78	43.2	42.68	43.0	122200.0
2009-11-16	ACWX	ETF	41.9	42.22	41.7	41.99	66105.0
2009-11-16	ADRE	ETF	44.66	45.2481	44.55	45.0	246000.0
2009-11-16	AFK	ETF	28.99	29.5	28.84	29.35	11778.0
2009-11-16	AGG	ETF	104.82	105.29	104.82	105.15	479900.0
2009-11-16	AGQ	ETF	128.42	137.04	128.34	135.42	445600.0
2009-11-16	AGZ	ETF	108.61	108.86	108.526	108.8	18260.0
2009-11-16	AIA	ETF	40.06	40.66	40.06	40.58	55751.0
2009-11-16	AIQ	ETF	26.35	26.85	26.15	26.5	82919.0
2009-11-16	AIS	ETF	1.1	1.14	1.08	1.12	294788.0
2009-11-16	AIVI	ETF	44.66	45.23	44.64	44.94	37700.0
2009-11-16	AMJ	ETF	26.94	27.795	26.79	26.85	199107.0
2009-11-16	AOA	ETF	29.92	30.08	29.92	30.03	9700.0
2009-11-16	AOK	ETF	27.5833	27.64	27.5455	27.64	2485.0
2009-11-16	AOM	ETF	28.23	28.51	28.23	28.4376	27745.0
2009-11-16	AOR	ETF	29.13	29.31	29.12	29.21	10119.0
2009-11-16	ARB	ETF	21.76	22.76	21.7	22.5	261455.0
2009-11-16	BAL	ETF	35.09	35.74	34.89	35.6	28225.0
2009-11-16	BBH	ETF	32.5067	32.6633	32.3267	32.5667	177900.0
2009-11-16	BIL	ETF	91.74	91.74	91.7	91.7	199650.0
2009-11-16	BITS	ETF	27.74	27.76	26.64	27.56	3425.0
2009-11-16	BIV	ETF	80.75	80.98	80.53	80.89	161800.0
2009-11-16	BJK	ETF	25.75	25.99	25.57	25.87	6300.0
2009-11-16	BKF	ETF	46.72	47.69	46.72	47.49	222474.0
2009-11-16	BLV	ETF	77.78	78.15	77.52	78.0	109700.0
2009-11-16	BMVP	ETF	12.36	12.55	12.36	12.51	19535.0
2009-11-16	BND	ETF	79.63	79.77	79.56	79.71	488700.0
2009-11-16	BNE	ETF	6.46	6.61	6.4	6.55	253139.0
2009-11-16	BOSS	ETF	19.6	19.98	19.6	19.6	200.0
2009-11-16	BRF	ETF	47.4	47.67	46.88	47.32	479478.0
2009-11-16	BSV	ETF	80.21	80.26	80.1	80.25	314800.0
2009-11-16	BTF	ETF	63.099999999999994	64.35	63.099999999999994	64.056	5535.400000000001
2009-11-16	BWX	ETF	29.87	29.87	29.665	29.86	379988.0
2009-11-16	BWZ	ETF	37.67	37.94	37.64	37.87	111961.0
2009-11-16	BZQ	ETF	3932.8	3947.2	3804.8	3830.4	871.0
2009-11-16	CEF	ETF	14.09	14.25	13.94	14.08	2114300.0
2009-11-16	CEW	ETF	22.26	22.42	22.25	22.4	121537.0
2009-11-16	CGO	ETF	13.99	13.99	13.8	13.85	114282.0
2009-11-16	CGW	ETF	18.25	18.5	18.16	18.42	100483.0
2009-11-16	CHI	ETF	12.18	12.25	11.91	11.97	232885.0
2009-11-16	CHW	ETF	7.7	7.75	7.55	7.55	296594.0
2009-11-16	CHY	ETF	11.74	11.75	11.46	11.52	177228.0
2009-11-16	CMF	ETF	52.41	52.7	52.33	52.33	8732.0

> showing 50 of 680 rows — these rows as CSV

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