PREVIEW / etf_daily / 2009-05-18

all etf daily files

  file:    by_date/etf_daily/2009/2009-05-18.parquet
  size:    29 KB
  rows:    651

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-05-18	SPY	ETF	89.55	91.34	88.57	91.23	241447400.0
2009-05-18	QQQ	ETF	33.59	34.28	33.3901	34.24	114333401.0
2009-05-18	IWM	ETF	48.3	49.57	48.11	49.36	55512900.0
2009-05-18	DIA	ETF	83.58	85.12	83.5	85.12	12745200.0
2009-05-18	GLD	ETF	91.53	91.57	90.14	90.36	17353900.0
2009-05-18	TLT	ETF	98.01	98.11	96.37	96.52	2234700.0
2009-05-18	AAXJ	ETF	41.91	43.76	41.91	43.37	417100.0
2009-05-18	ACWI	ETF	33.32	34.12	32.87	34.12	361800.0
2009-05-18	ACWX	ETF	32.22	32.99	32.22	32.99	117881.0
2009-05-18	ADRE	ETF	33.34	34.32	33.34	34.26	287714.0
2009-05-18	AFK	ETF	24.2	24.27	24.0776	24.27	2795.0
2009-05-18	AGG	ETF	102.19	102.22	101.8	101.89	420900.0
2009-05-18	AGQ	ETF	87.38	87.5	83.86	86.28	121250.0
2009-05-18	AGZ	ETF	108.02	108.46	107.5	107.7468	12658.0
2009-05-18	AIA	ETF	31.47	32.04	31.31	31.96	12234.0
2009-05-18	AIQ	ETF	35.65	36.3	35.15	35.9	44847.0
2009-05-18	AIS	ETF	0.5889	0.59	0.56	0.58	34550.0
2009-05-18	AIVI	ETF	34.1	34.89	34.1	34.89	3300.0
2009-05-18	AMJ	ETF	21.67	21.86	21.67	21.8	47200.0
2009-05-18	AOA	ETF	26.29	26.29	24.44	24.85	13500.0
2009-05-18	AOK	ETF	25.55	27.2	25.18	25.71	12253.0
2009-05-18	AOM	ETF	25.3532	25.99	24.89	25.63	12612.0
2009-05-18	AOR	ETF	25.06	25.33	25.06	25.33	3006.0
2009-05-18	ARB	ETF	18.98	19.76	18.78	19.76	408517.0
2009-05-18	BAL	ETF	31.77	32.26	31.4	32.26	20396.0
2009-05-18	BBH	ETF	29.55	29.86	29.3067	29.7867	418500.0
2009-05-18	BIL	ETF	91.68	91.76	91.68	91.76	342350.0
2009-05-18	BITS	ETF	17.84	18.24	17.56	18.16	5872.0
2009-05-18	BIV	ETF	77.43	77.43	76.83	76.95	129100.0
2009-05-18	BJK	ETF	19.75	20.89	19.75	20.89	9000.0
2009-05-18	BKF	ETF	34.23	34.46	33.4589	34.11	109549.0
2009-05-18	BLV	ETF	74.18	74.18	73.3	73.38	22700.0
2009-05-18	BMVP	ETF	10.46	10.66	10.43	10.66	12707.0
2009-05-18	BND	ETF	77.69	77.74	77.26	77.37	507000.0
2009-05-18	BNE	ETF	5.21	5.74	5.09	5.67	143911.0
2009-05-18	BOSS	ETF	16.8	16.8	16.18	16.6	300.0
2009-05-18	BRF	ETF	25.0	26.85	24.85	25.89	53084.0
2009-05-18	BSV	ETF	79.25	79.25	79.0	79.15	174100.0
2009-05-18	BTF	ETF	47.0	47.75	46.6	47.75	8388.4
2009-05-18	BWX	ETF	26.465	26.5	26.375	26.5	252618.0
2009-05-18	BWZ	ETF	34.3	34.31	34.25	34.29	2901.0
2009-05-18	CBON	ETF	1.37	1.39	1.21	1.25	19695.0
2009-05-18	CEF	ETF	11.47	11.51	11.3	11.42	497000.0
2009-05-18	CEW	ETF	20.17	20.34	20.17	20.34	12134.0
2009-05-18	CGO	ETF	10.25	10.38	10.15	10.35	46270.0
2009-05-18	CGW	ETF	14.34	14.7999	14.32	14.7999	44023.0
2009-05-18	CHB	ETF	0.5	0.51	0.47	0.5	270672.0
2009-05-18	CHI	ETF	10.44	10.45	10.07	10.3	259357.0
2009-05-18	CHIC	ETF	10.6	11.14	10.6	11.04	202028.0
2009-05-18	CHW	ETF	6.47	6.64	6.44	6.59	235959.0

> showing 50 of 651 rows — these rows as CSV

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