PREVIEW / etf_daily / 2009-08-07

all etf daily files

  file:    by_date/etf_daily/2009/2009-08-07.parquet
  size:    30 KB
  rows:    671

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-07	SPY	ETF	100.94	102.03	100.39	101.2	220640900.0
2009-08-07	QQQ	ETF	39.91	40.07	39.59	39.88	107512240.0
2009-08-07	IWM	ETF	56.62	57.84	56.29	57.09	49363300.0
2009-08-07	DIA	ETF	93.55	94.5	93.11	93.79	11813100.0
2009-08-07	GLD	ETF	94.32	94.64	93.6	93.75	8042000.0
2009-08-07	TLT	ETF	90.42	90.93	90.22	90.49	3543200.0
2009-08-07	AAXJ	ETF	50.5	50.51	49.79	50.26	675900.0
2009-08-07	ACWI	ETF	38.61	38.68	38.17	38.47	126800.0
2009-08-07	ACWX	ETF	37.38	37.53	37.08	37.32	201442.0
2009-08-07	ADRE	ETF	39.31	39.42	38.88	39.16	124058.0
2009-08-07	AFK	ETF	28.49	28.49	27.5	27.94	47484.0
2009-08-07	AGG	ETF	101.71	102.09	101.36	101.59	1076900.0
2009-08-07	AGQ	ETF	94.42	95.08	91.02	91.44	98100.0
2009-08-07	AGZ	ETF	106.59	106.66	106.3562	106.6	12950.0
2009-08-07	AIA	ETF	36.22	36.66	36.13	36.5	134796.0
2009-08-07	AIQ	ETF	26.05	26.099	25.55	25.7	90177.0
2009-08-07	AIS	ETF	0.97	1.07	0.97	1.02	838690.0
2009-08-07	AIVI	ETF	39.45	39.48	39.1	39.1	17300.0
2009-08-07	AMJ	ETF	24.65	24.82	24.518	24.78	183466.0
2009-08-07	AOA	ETF	27.61	27.71	27.37	27.59	21400.0
2009-08-07	AOK	ETF	26.35	26.4299	26.31	26.31	1139.0
2009-08-07	AOM	ETF	26.72	26.9594	26.72	26.9594	1870.0
2009-08-07	AOR	ETF	27.19	27.31	27.1432	27.1432	2274.0
2009-08-07	ARB	ETF	15.89	16.6	15.61	16.38	261684.0
2009-08-07	BAL	ETF	31.74	32.74	31.74	32.533	16092.0
2009-08-07	BBH	ETF	33.05	33.1533	32.6267	32.86	496800.0
2009-08-07	BIL	ETF	91.7	91.72	91.7	91.7	147250.0
2009-08-07	BITS	ETF	22.28	22.72	21.8	22.4	2651.0
2009-08-07	BIV	ETF	77.39	78.0	77.02	77.36	118200.0
2009-08-07	BJK	ETF	23.25	24.25	23.21	23.89	32700.0
2009-08-07	BKF	ETF	39.43	40.01	39.1801	39.59	216859.0
2009-08-07	BLV	ETF	75.02	75.09	74.52	74.74	39900.0
2009-08-07	BMVP	ETF	11.59	11.69	11.54	11.67	197441.0
2009-08-07	BND	ETF	77.26	77.5	77.09	77.19	986100.0
2009-08-07	BNE	ETF	5.94	6.1	5.8	6.04	6099223.0
2009-08-07	BOSS	ETF	19.02	20.5	19.02	20.5	100.0
2009-08-07	BRF	ETF	35.55	37.2	35.411	35.88	327993.0
2009-08-07	BSV	ETF	78.97	79.09	78.83	78.92	340400.0
2009-08-07	BTF	ETF	60.3	60.75	59.45	59.45	40678.0
2009-08-07	BWX	ETF	28.05	28.05	27.595	27.775	340616.0
2009-08-07	BWZ	ETF	35.78	35.78	35.65	35.7	8614.0
2009-08-07	BZQ	ETF	6675.2	6812.8	6675.2	6720.0	11.25
2009-08-07	CBON	ETF	0.78	1.17	0.78	0.98	229289.0
2009-08-07	CEF	ETF	12.02	12.11	11.99	12.04	1096800.0
2009-08-07	CEW	ETF	21.36	21.429	21.28	21.386	23458.0
2009-08-07	CGO	ETF	13.0	13.11	12.65	12.95	69305.0
2009-08-07	CGW	ETF	16.26	16.38	16.16	16.31	197761.0
2009-08-07	CHB	ETF	0.4897	0.61	0.4897	0.5	3156824.0
2009-08-07	CHI	ETF	11.16	11.5	11.16	11.34	199616.0
2009-08-07	CHIC	ETF	15.74	16.32	15.49	15.71	262780.0

> showing 50 of 671 rows — these rows as CSV

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