PREVIEW / etf_daily / 2009-10-27

all etf daily files

  file:    by_date/etf_daily/2009/2009-10-27.parquet
  size:    29 KB
  rows:    673

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-10-27	SPY	ETF	107.03	107.39	106.16	106.42	253266300.0
2009-10-27	QQQ	ETF	42.95	43.11	42.18	42.34	121438174.0
2009-10-27	IWM	ETF	59.57	59.89	58.69	58.79	71958600.0
2009-10-27	DIA	ETF	98.95	99.53	98.4	98.82	14503800.0
2009-10-27	GLD	ETF	101.89	102.06	101.22	101.85	18398400.0
2009-10-27	TLT	ETF	93.97	95.11	93.92	95.0	4476300.0
2009-10-27	AAXJ	ETF	54.1	54.1	53.27	53.48	100700.0
2009-10-27	ACWI	ETF	41.43	41.43	41.0	41.07	99300.0
2009-10-27	ACWX	ETF	40.59	40.59	40.0	40.07	16527.0
2009-10-27	ADRE	ETF	42.83	42.96	42.13	42.16	174753.0
2009-10-27	AFK	ETF	29.29	29.43	28.5	29.282	12380.0
2009-10-27	AGG	ETF	104.21	104.53	104.1	104.47	420100.0
2009-10-27	AGQ	ETF	117.5	118.04	111.22	113.06	503900.0
2009-10-27	AGZ	ETF	108.43	108.55	108.2216	108.502	32572.0
2009-10-27	AIA	ETF	39.09	39.23	38.7	38.81	62604.0
2009-10-27	AIQ	ETF	29.8	29.8	28.85	28.85	32493.0
2009-10-27	AIS	ETF	1.19	1.19	1.13	1.13	389232.0
2009-10-27	AIVI	ETF	43.06	43.06	42.26	42.4	15300.0
2009-10-27	AMJ	ETF	26.27	26.49	25.77	26.16	140980.0
2009-10-27	AOA	ETF	29.14	29.16	28.93	28.93	13300.0
2009-10-27	AOK	ETF	27.41	27.41	27.14	27.14	1116.0
2009-10-27	AOM	ETF	27.84	27.8497	27.76	27.76	5605.0
2009-10-27	AOR	ETF	28.4296	28.44	28.34	28.3899	20581.0
2009-10-27	ARB	ETF	23.01	23.21	22.5	22.96	418537.0
2009-10-27	BAL	ETF	34.87	34.87	34.43	34.58	7892.0
2009-10-27	BBH	ETF	31.09	31.6	31.0867	31.1167	219600.0
2009-10-27	BIL	ETF	91.72	91.74	91.7	91.7	111350.0
2009-10-27	BITS	ETF	25.32	25.32	25.12	25.16	125.0
2009-10-27	BIV	ETF	79.62	80.15	79.58	80.1	127700.0
2009-10-27	BJK	ETF	25.4	25.4	24.34	24.57	41000.0
2009-10-27	BKF	ETF	45.05	45.25	44.2	44.24	190534.0
2009-10-27	BLV	ETF	77.75	78.37	77.4	78.37	140600.0
2009-10-27	BMVP	ETF	12.083	12.087	11.888	12.027	13618.0
2009-10-27	BND	ETF	79.04	79.24	78.84	79.18	315300.0
2009-10-27	BNE	ETF	6.61	7.18	6.61	6.83	258346.0
2009-10-27	BOSS	ETF	22.15	22.15	22.05	22.15	200.0
2009-10-27	BRF	ETF	44.58	44.58	43.02	43.32	786995.0
2009-10-27	BSV	ETF	79.74	79.91	79.64	79.91	220900.0
2009-10-27	BTF	ETF	60.099999999999994	61.22	60.099999999999994	60.75	12263.6
2009-10-27	BWX	ETF	29.255	29.26	29.085	29.24	352774.0
2009-10-27	BWZ	ETF	37.45	37.45	37.348	37.45	32049.0
2009-10-27	BZQ	ETF	4457.6	4668.8	4419.2	4665.6	259.5
2009-10-27	CEF	ETF	13.25	13.48	13.24	13.38	1049200.0
2009-10-27	CEW	ETF	21.9	21.9	21.72	21.77	93226.0
2009-10-27	CGO	ETF	14.18	14.27	13.9	13.988	40077.0
2009-10-27	CGW	ETF	17.55	17.695	17.41	17.4918	56473.0
2009-10-27	CHB	ETF	0.33	0.33	0.2622	0.27	5425360.0
2009-10-27	CHI	ETF	11.96	12.02	11.7904	11.8	179894.0
2009-10-27	CHW	ETF	7.88	7.94	7.81	7.94	183811.0
2009-10-27	CHY	ETF	11.64	11.75	11.48	11.75	198192.0

> showing 50 of 673 rows — these rows as CSV

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