PREVIEW / etf_daily / 2009-11-04

all etf daily files

  file:    by_date/etf_daily/2009/2009-11-04.parquet
  size:    30 KB
  rows:    683

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-04	SPY	ETF	105.51	106.33	104.65	104.92	247996700.0
2009-11-04	QQQ	ETF	41.51	41.87	41.28	41.33	107970596.0
2009-11-04	IWM	ETF	57.46	57.68	56.25	56.25	92803000.0
2009-11-04	DIA	ETF	98.38	99.38	97.94	98.17	14714300.0
2009-11-04	GLD	ETF	107.11	107.68	106.43	107.1	27197500.0
2009-11-04	TLT	ETF	93.61	94.07	92.8	93.24	5349500.0
2009-11-04	AAXJ	ETF	52.74	53.08	52.21	52.42	112200.0
2009-11-04	ACWI	ETF	40.43	40.94	40.43	40.57	936700.0
2009-11-04	ACWX	ETF	39.62	39.9481	39.448	39.48	1131902.0
2009-11-04	ADRE	ETF	42.01	42.57	41.91	42.04	174425.0
2009-11-04	AFK	ETF	28.31	28.47	27.5	27.64	87296.0
2009-11-04	AGG	ETF	104.24	104.41	104.01	104.01	490700.0
2009-11-04	AGQ	ETF	123.68	125.98	121.72	123.04	407450.0
2009-11-04	AGZ	ETF	108.15	108.3181	108.01	108.195	8484.0
2009-11-04	AIA	ETF	38.11	38.49	37.9	37.95	81131.0
2009-11-04	AIQ	ETF	26.85	27.15	26.25	26.4	29324.0
2009-11-04	AIS	ETF	1.13	1.14	1.07	1.1	293739.0
2009-11-04	AIVI	ETF	42.05	42.44	41.94	41.96	31000.0
2009-11-04	AMJ	ETF	26.0	26.5188	25.74	26.04	265008.0
2009-11-04	AOA	ETF	28.62	28.77	28.62	28.63	9700.0
2009-11-04	AOK	ETF	27.0325	27.25	27.01	27.01	4720.0
2009-11-04	AOM	ETF	27.66	27.73	27.57	27.62	38691.0
2009-11-04	AOR	ETF	28.14	28.23	28.01	28.01	13184.0
2009-11-04	ARB	ETF	21.63	21.75	21.29	21.56	360670.0
2009-11-04	BAL	ETF	35.3855	35.64	35.2099	35.37	7812.0
2009-11-04	BBH	ETF	30.6367	30.6867	30.35	30.39	346200.0
2009-11-04	BIL	ETF	91.74	91.78	91.72	91.74	638050.0
2009-11-04	BITS	ETF	27.2	27.72	26.0	27.72	6513.0
2009-11-04	BIV	ETF	79.77	80.02	79.56	79.93	83800.0
2009-11-04	BJK	ETF	24.2	24.54	24.08	24.5	8700.0
2009-11-04	BKF	ETF	44.09	44.57	43.84	44.06	303899.0
2009-11-04	BLV	ETF	77.88	77.88	75.81	77.1	88700.0
2009-11-04	BMVP	ETF	11.8633	11.98	11.8011	11.8067	27828.0
2009-11-04	BND	ETF	79.01	79.11	78.85	78.99	446700.0
2009-11-04	BNE	ETF	6.59	6.61	6.18	6.3	190632.0
2009-11-04	BOSS	ETF	18.44	18.44	17.76	18.44	800.0
2009-11-04	BRF	ETF	43.62	45.5	43.14	43.93	500337.0
2009-11-04	BSV	ETF	79.89	80.03	79.77	79.85	580100.0
2009-11-04	BTF	ETF	61.199999999999996	61.5	60.9	61.15	25518.4
2009-11-04	BWX	ETF	29.28	29.4	29.1825	29.245	289658.0
2009-11-04	BWZ	ETF	37.185	37.31	37.185	37.26	13635.0
2009-11-04	BZQ	ETF	4347.2	4395.2	4216.0	4364.8	418.0
2009-11-04	CEF	ETF	14.18	14.35	14.01	14.01	2482000.0
2009-11-04	CEW	ETF	21.75	21.93	21.75	21.9	117698.0
2009-11-04	CGO	ETF	13.1	13.4	13.02	13.2901	35889.0
2009-11-04	CGW	ETF	17.47	17.69	17.332	17.377	94452.0
2009-11-04	CHB	ETF	0.216	0.23	0.21	0.21	1692453.0
2009-11-04	CHI	ETF	11.76	11.9788	11.73	11.88	164450.0
2009-11-04	CHW	ETF	7.44	7.53	7.4	7.43	183212.0
2009-11-04	CHY	ETF	11.35	11.55	11.35	11.49	162841.0

> showing 50 of 683 rows — these rows as CSV

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