PREVIEW / etf_daily / 2009-08-06

all etf daily files

  file:    by_date/etf_daily/2009/2009-08-06.parquet
  size:    30 KB
  rows:    667

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-08-06	SPY	ETF	100.87	101.02	99.42	99.89	193203800.0
2009-08-06	QQQ	ETF	39.79	39.93	39.24	39.38	116937411.0
2009-08-06	IWM	ETF	56.78	56.96	55.61	55.75	52403600.0
2009-08-06	DIA	ETF	93.24	93.35	92.19	92.63	10482300.0
2009-08-06	GLD	ETF	95.01	95.19	93.76	94.6	13661000.0
2009-08-06	TLT	ETF	90.9	91.89	90.42	91.25	3228500.0
2009-08-06	AAXJ	ETF	50.61	50.61	49.5	49.98	557400.0
2009-08-06	ACWI	ETF	38.62	38.62	37.91	38.18	120200.0
2009-08-06	ACWX	ETF	37.67	37.67	36.87	37.11	45956.0
2009-08-06	ADRE	ETF	39.3	39.52	38.5	38.9	118730.0
2009-08-06	AFK	ETF	28.06	28.154	27.75	27.95	58350.0
2009-08-06	AGG	ETF	102.2	102.35	102.03	102.2	564300.0
2009-08-06	AGQ	ETF	96.0	96.54	89.44	91.54	180650.0
2009-08-06	AGZ	ETF	107.13	107.2	106.781	107.2	4522.0
2009-08-06	AIA	ETF	36.12	36.568	35.66	35.968	73381.0
2009-08-06	AIQ	ETF	26.5	26.5	25.65	26.05	159993.0
2009-08-06	AIS	ETF	0.94	0.97	0.93	0.96	262395.0
2009-08-06	AIVI	ETF	39.52	39.52	38.69	38.93	27800.0
2009-08-06	AMJ	ETF	24.98	25.0	24.25	24.579	245202.0
2009-08-06	AOA	ETF	27.42	27.5	27.13	27.24	9400.0
2009-08-06	AOK	ETF	26.3001	26.36	26.3001	26.319	1644.0
2009-08-06	AOM	ETF	27.29	27.46	26.6436	26.74	12443.0
2009-08-06	AOR	ETF	27.06	27.0876	27.0	27.014	6009.0
2009-08-06	ARB	ETF	16.12	16.21	15.45	15.65	333220.0
2009-08-06	BAL	ETF	32.5145	32.5145	31.31	31.638	4725.0
2009-08-06	BBH	ETF	33.5067	33.5067	32.7033	32.73	521400.0
2009-08-06	BIL	ETF	91.7	91.72	91.7	91.7	85550.0
2009-08-06	BITS	ETF	22.12	22.76	21.56	22.12	11504.0
2009-08-06	BIV	ETF	77.84	78.0	77.67	77.77	90100.0
2009-08-06	BJK	ETF	23.24	23.81	23.12	23.15	7700.0
2009-08-06	BKF	ETF	39.95	40.47	38.9	39.38	206100.0
2009-08-06	BLV	ETF	75.1	75.51	74.82	75.29	18900.0
2009-08-06	BMVP	ETF	11.6433	11.645	11.47	11.5067	8645.0
2009-08-06	BND	ETF	77.74	77.81	77.62	77.73	331800.0
2009-08-06	BNE	ETF	6.77	6.77	5.81	5.96	709033.0
2009-08-06	BOSS	ETF	17.68	19.05	17.68	19.05	100.0
2009-08-06	BRF	ETF	36.17	37.64	34.83	35.15	243571.0
2009-08-06	BSV	ETF	79.2	79.48	79.04	79.1	274100.0
2009-08-06	BTF	ETF	59.800000000000004	60.3	59.0	59.599999999999994	19156.8
2009-08-06	BWX	ETF	28.185	28.225	28.005	28.1	528424.0
2009-08-06	BWZ	ETF	35.97	36.02	35.93	36.0	5403.0
2009-08-06	BZQ	ETF	6793.6	6995.2	6793.6	6948.8	14.5
2009-08-06	CBON	ETF	0.92	1.5	0.7	0.72	244843.0
2009-08-06	CEF	ETF	12.19	12.2	11.91	12.1	2850100.0
2009-08-06	CEW	ETF	21.3	21.36	21.2415	21.25	14000.0
2009-08-06	CGO	ETF	12.97	12.99	12.75	12.87	32850.0
2009-08-06	CGW	ETF	16.43	16.43	16.1525	16.239	37105.0
2009-08-06	CHB	ETF	0.5104	0.5104	0.47	0.5	691513.0
2009-08-06	CHI	ETF	11.2	11.25	11.09	11.1	146576.0
2009-08-06	CHIC	ETF	15.33	15.7225	15.09	15.41	203921.0

> showing 50 of 667 rows — these rows as CSV

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