PREVIEW / etf_daily / 2009-10-15

all etf daily files

  file:    by_date/etf_daily/2009/2009-10-15.parquet
  size:    30 KB
  rows:    677

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-15	SPY	ETF	108.78	109.71	108.73	109.71	173873600.0
2009-10-15	QQQ	ETF	42.93	43.12	42.87	43.06	85772704.0
2009-10-15	IWM	ETF	61.99	62.45	61.83	62.3	28632600.0
2009-10-15	DIA	ETF	99.87	100.67	99.84	100.65	7667900.0
2009-10-15	GLD	ETF	103.27	103.95	102.6	102.86	15781300.0
2009-10-15	TLT	ETF	94.57	95.42	94.37	94.68	3736900.0
2009-10-15	AAXJ	ETF	54.55	54.89	54.27	54.89	522600.0
2009-10-15	ACWI	ETF	42.04	42.42	42.02	42.42	123600.0
2009-10-15	ACWX	ETF	41.39	41.73	41.39	41.73	31674.0
2009-10-15	ADRE	ETF	43.93	44.12	43.61	44.08	163058.0
2009-10-15	AFK	ETF	30.19	30.5	30.09	30.431	36940.0
2009-10-15	AGG	ETF	104.23	104.32	104.03	104.25	727700.0
2009-10-15	AGQ	ETF	126.38	129.14	123.04	123.56	298900.0
2009-10-15	AGZ	ETF	108.54	108.54	108.12	108.44	55164.0
2009-10-15	AIA	ETF	39.48	39.65	39.42	39.65	36809.0
2009-10-15	AIQ	ETF	30.9	31.3	30.7	31.0	86665.0
2009-10-15	AIS	ETF	1.1	1.14	1.09	1.14	439305.0
2009-10-15	AIVI	ETF	43.86	44.1	43.8	44.08	22600.0
2009-10-15	AMJ	ETF	26.14	26.16	26.0126	26.16	162514.0
2009-10-15	AOA	ETF	29.8	29.91	29.73	29.91	6300.0
2009-10-15	AOK	ETF	27.1	27.31	27.1	27.308	3732.0
2009-10-15	AOM	ETF	28.2	28.2	28.06	28.17	21504.0
2009-10-15	AOR	ETF	28.9	28.98	28.7916	28.98	18326.0
2009-10-15	ARB	ETF	23.39	25.36	23.32	25.0	841583.0
2009-10-15	BAL	ETF	35.12	36.0	34.75	34.88	45368.0
2009-10-15	BBH	ETF	33.7933	34.2467	33.79	34.2467	229500.0
2009-10-15	BIL	ETF	91.7	91.72	91.7	91.7	122150.0
2009-10-15	BITS	ETF	26.0	26.0	25.6	25.72	1061.0
2009-10-15	BIV	ETF	79.76	79.8	79.63	79.68	146700.0
2009-10-15	BJK	ETF	26.75	26.75	26.18	26.41	22800.0
2009-10-15	BKF	ETF	45.32	46.04	45.32	45.8	805858.0
2009-10-15	BLV	ETF	77.46	77.55	76.9	77.14	96600.0
2009-10-15	BMVP	ETF	12.357	12.427	12.316	12.427	47721.0
2009-10-15	BND	ETF	78.96	79.09	78.81	79.02	736700.0
2009-10-15	BNE	ETF	7.86	8.22	7.85	8.17	209042.0
2009-10-15	BOSS	ETF	22.4	22.48	22.39	22.4	100.0
2009-10-15	BRF	ETF	45.67	45.99	45.46	45.95	537079.0
2009-10-15	BSV	ETF	79.85	79.94	79.78	79.87	1443700.0
2009-10-15	BTF	ETF	60.99999999999999	61.5	60.99999999999999	61.449999999999996	2050.6
2009-10-15	BWX	ETF	29.505	29.56	29.366	29.45	307236.0
2009-10-15	BWZ	ETF	37.73	37.74	37.34	37.68	57591.0
2009-10-15	BZQ	ETF	4235.2	4235.2	4160.0	4164.8	17.5
2009-10-15	CEF	ETF	13.83	13.85	13.48	13.51	1279900.0
2009-10-15	CEW	ETF	22.2	22.27	22.156	22.22	187351.0
2009-10-15	CGO	ETF	14.47	14.47	14.19	14.2399	22745.0
2009-10-15	CGW	ETF	18.01	18.1	17.85	18.09	125851.0
2009-10-15	CHB	ETF	0.35	0.365	0.33	0.35	2483293.0
2009-10-15	CHI	ETF	11.66	11.77	11.62	11.76	139169.0
2009-10-15	CHW	ETF	7.89	7.93	7.81	7.83	142176.0
2009-10-15	CHY	ETF	11.75	11.75	11.47	11.57	222153.0

> showing 50 of 677 rows — these rows as CSV

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