PREVIEW / etf_daily / 2009-12-21

all etf daily files

  file:    by_date/etf_daily/2009/2009-12-21.parquet
  size:    31 KB
  rows:    708

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-21	SPY	ETF	110.76	111.7	110.76	111.33	118039600.0
2009-12-21	QQQ	ETF	44.67	45.13	44.67	44.96	82381391.0
2009-12-21	IWM	ETF	61.63	62.11	61.62	61.99	47658100.0
2009-12-21	DIA	ETF	103.56	104.39	103.52	103.88	5968000.0
2009-12-21	GLD	ETF	109.17	109.3	106.82	106.95	23314200.0
2009-12-21	TLT	ETF	92.06	92.2	91.14	91.14	3524000.0
2009-12-21	AAXJ	ETF	54.61	54.8	54.32	54.41	798500.0
2009-12-21	ACWI	ETF	42.1	42.23	41.9	42.1	120900.0
2009-12-21	ACWX	ETF	40.58	40.67	40.34	40.44	38062.0
2009-12-21	ADRE	ETF	43.0	43.1	42.59	42.66	140405.0
2009-12-21	AFK	ETF	27.87	28.15	27.82	27.98	12025.0
2009-12-21	AGG	ETF	104.67	104.7	104.29	104.31	628500.0
2009-12-21	AGQ	ETF	119.52	119.64	114.0	114.56	141400.0
2009-12-21	AGZ	ETF	108.5	108.5	108.02	108.12	15961.0
2009-12-21	AIA	ETF	38.68	38.76	38.4	38.57	20848.0
2009-12-21	AIQ	ETF	27.55	27.975	27.25	27.35	77671.0
2009-12-21	AIS	ETF	1.08	1.11	1.06	1.08	330383.0
2009-12-21	AIVI	ETF	42.98	43.32	42.98	43.19	25200.0
2009-12-21	AMJ	ETF	28.12	28.44	27.61	28.075	459261.0
2009-12-21	AOA	ETF	29.91	30.0	29.91	29.97	5000.0
2009-12-21	AOK	ETF	27.52	27.53	27.4	27.5	6072.0
2009-12-21	AOM	ETF	28.36	28.39	28.29	28.321	7343.0
2009-12-21	AOR	ETF	29.0	29.09	28.9901	29.05	16335.0
2009-12-21	ARB	ETF	23.07	23.98	22.82	23.83	233996.0
2009-12-21	BAB	ETF	24.56	24.59	24.33	24.41	69641.0
2009-12-21	BAL	ETF	37.12	37.16	36.9	36.9	2504.0
2009-12-21	BBH	ETF	31.6867	32.3533	31.6867	32.19	190200.0
2009-12-21	BIL	ETF	91.72	91.72	91.7	91.7	95500.0
2009-12-21	BITS	ETF	30.08	30.6	29.48	29.8	1350.0
2009-12-21	BIV	ETF	80.33	80.4	79.86	80.0	138000.0
2009-12-21	BJK	ETF	24.04	24.04	23.72	23.72	11900.0
2009-12-21	BKF	ETF	44.43	44.96	44.27	44.56	188698.0
2009-12-21	BLV	ETF	77.3	77.36	76.66	76.7	33600.0
2009-12-21	BMVP	ETF	12.51	12.66	12.51	12.61	93150.0
2009-12-21	BND	ETF	79.38	79.41	79.16	79.16	654800.0
2009-12-21	BNE	ETF	7.03	7.24	6.95	7.09	189030.0
2009-12-21	BOSS	ETF	19.7	19.74	19.62	19.74	100.0
2009-12-21	BRF	ETF	46.91	47.32	46.52	46.75	341049.0
2009-12-21	BSV	ETF	80.18	80.22	80.05	80.11	374500.0
2009-12-21	BTF	ETF	63.49999999999999	63.65	63.15	63.2	3413.8
2009-12-21	BWX	ETF	28.75	28.8149	28.465	28.61	938308.0
2009-12-21	BWZ	ETF	36.7	36.7	36.47	36.47	22499.0
2009-12-21	BZQ	ETF	3992.0	4139.2	3947.2	4107.2	293.0
2009-12-21	CEF	ETF	13.8	13.88	13.45	13.51	1066500.0
2009-12-21	CEW	ETF	21.93	21.93	21.65	21.7	200796.0
2009-12-21	CGO	ETF	14.38	14.38	14.3304	14.36	15066.0
2009-12-21	CGW	ETF	18.52	18.64	18.31	18.52	137823.0
2009-12-21	CHI	ETF	12.37	12.451	12.3	12.42	185206.0
2009-12-21	CHIE	ETF	15.24	15.24	14.43	14.54	17550.0
2009-12-21	CHII	ETF	15.26	15.26	15.11	15.1851	10576.0

> showing 50 of 708 rows — these rows as CSV

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