PREVIEW / etf_daily / 2009-07-30

all etf daily files

  file:    by_date/etf_daily/2009/2009-07-30.parquet
  size:    29 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-07-30	SPY	ETF	98.83	99.83	98.6	98.67	225575400.0
2009-07-30	QQQ	ETF	39.74	40.18	39.51	39.57	108969837.0
2009-07-30	IWM	ETF	55.61	56.44	55.38	55.8	67822300.0
2009-07-30	DIA	ETF	91.58	92.48	91.27	91.42	11659200.0
2009-07-30	GLD	ETF	91.55	92.0	91.44	91.62	6246700.0
2009-07-30	TLT	ETF	91.54	93.15	91.23	93.0	4040700.0
2009-07-30	AAXJ	ETF	49.81	50.35	49.68	49.71	396500.0
2009-07-30	ACWI	ETF	37.4	37.81	37.37	37.54	584500.0
2009-07-30	ACWX	ETF	36.25	36.61	36.11	36.38	42144.0
2009-07-30	ADRE	ETF	38.09	38.17	37.8	37.81	334513.0
2009-07-30	AFK	ETF	27.4	27.6599	27.388	27.6599	7280.0
2009-07-30	AGG	ETF	102.28	102.7	102.21	102.58	1108700.0
2009-07-30	AGQ	ETF	78.06	79.78	77.62	78.34	103850.0
2009-07-30	AGZ	ETF	107.42	107.735	107.02	107.3	42880.0
2009-07-30	AIA	ETF	36.27	36.84	36.27	36.4868	47544.0
2009-07-30	AIQ	ETF	30.3	30.45	24.75	24.95	766375.0
2009-07-30	AIS	ETF	0.9	0.95	0.88	0.9	671423.0
2009-07-30	AIVI	ETF	38.06	38.54	37.97	38.27	28300.0
2009-07-30	AMJ	ETF	24.53	24.77	24.44	24.7	107002.0
2009-07-30	AOA	ETF	27.0	27.33	26.84	26.9	10000.0
2009-07-30	AOK	ETF	26.44	26.44	26.23	26.31	6014.0
2009-07-30	AOM	ETF	26.83	26.88	26.53	26.54	9008.0
2009-07-30	AOR	ETF	26.8274	26.93	26.72	26.72	9511.0
2009-07-30	ARB	ETF	16.73	16.99	16.47	16.6	127498.0
2009-07-30	BAL	ETF	30.97	31.46	30.97	31.022	3731.0
2009-07-30	BBH	ETF	34.8833	34.9567	34.4167	34.48	435000.0
2009-07-30	BIL	ETF	91.7	91.76	91.7	91.74	220100.0
2009-07-30	BITS	ETF	22.88	22.96	21.64	22.2	2292.0
2009-07-30	BIV	ETF	77.7	78.25	77.63	78.13	96500.0
2009-07-30	BJK	ETF	21.83	22.93	21.83	22.91	20400.0
2009-07-30	BKF	ETF	38.4	38.75	38.0	38.41	416145.0
2009-07-30	BLV	ETF	74.74	75.51	74.38	75.49	24200.0
2009-07-30	BMVP	ETF	11.547	11.677	11.53	11.578	22560.0
2009-07-30	BND	ETF	77.69	78.1	77.65	78.1	415200.0
2009-07-30	BNE	ETF	7.93	8.57	7.93	8.57	116444.0
2009-07-30	BOSS	ETF	17.16	17.21	16.14	17.16	1100.0
2009-07-30	BRF	ETF	32.95	33.57	32.95	33.319	341212.0
2009-07-30	BSV	ETF	79.3	79.48	79.14	79.48	315100.0
2009-07-30	BTF	ETF	53.449999999999996	54.199999999999996	53.4	53.64849999999999	5441.0
2009-07-30	BWX	ETF	27.685	27.685	27.57	27.595	331338.0
2009-07-30	BWZ	ETF	35.55	35.55	35.29	35.53	21719.0
2009-07-30	BZQ	ETF	7702.4	7702.4	7604.8	7635.2	10.75
2009-07-30	CBON	ETF	0.7295	0.7295	0.64	0.64	28338.0
2009-07-30	CEF	ETF	11.77	11.77	11.58	11.61	983400.0
2009-07-30	CEW	ETF	21.22	21.35	21.17	21.31	38945.0
2009-07-30	CGO	ETF	12.54	12.95	12.45	12.86	36301.0
2009-07-30	CGW	ETF	16.28	16.51	16.2	16.25	61876.0
2009-07-30	CHB	ETF	0.5	0.518	0.45	0.47	1291853.0
2009-07-30	CHI	ETF	10.8	10.8558	10.64	10.7226	189036.0
2009-07-30	CHIC	ETF	14.4	14.99	14.18	14.68	201318.0

> showing 50 of 667 rows — these rows as CSV

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