PREVIEW / etf_daily / 2009-12-24

all etf daily files

  file:    by_date/etf_daily/2009/2009-12-24.parquet
  size:    30 KB
  rows:    694

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-12-24	SPY	ETF	112.19	112.6	112.0	112.48	39677500.0
2009-12-24	QQQ	ETF	45.61	45.98	45.6	45.98	31770350.0
2009-12-24	IWM	ETF	63.29	63.39	63.13	63.36	16521900.0
2009-12-24	DIA	ETF	104.57	105.04	104.55	105.0	3568000.0
2009-12-24	GLD	ETF	107.9	108.37	107.77	108.36	7991600.0
2009-12-24	TLT	ETF	90.33	90.36	89.67	89.71	1698900.0
2009-12-24	AAXJ	ETF	55.32	55.41	53.56	55.37	62500.0
2009-12-24	ACWI	ETF	42.23	42.57	42.23	42.49	87700.0
2009-12-24	ACWX	ETF	41.09	41.0993	40.986	41.06	10541.0
2009-12-24	ADRE	ETF	43.63	43.807	43.56	43.79	57875.0
2009-12-24	AFK	ETF	27.97	27.98	27.881	27.961	2160.0
2009-12-24	AGG	ETF	103.88	103.99	103.73	103.87	388700.0
2009-12-24	AGQ	ETF	118.8	121.5	118.4	121.38	102750.0
2009-12-24	AGZ	ETF	108.03	108.0925	107.861	107.861	11843.0
2009-12-24	AIA	ETF	39.23	39.57	39.23	39.5364	8217.0
2009-12-24	AIQ	ETF	28.5	28.55	28.15	28.5	7278.0
2009-12-24	AIS	ETF	1.11	1.11	1.09	1.1	28683.0
2009-12-24	AIVI	ETF	43.51	43.95	43.51	43.79	7100.0
2009-12-24	AMJ	ETF	28.67	29.0	28.6	28.9	194526.0
2009-12-24	AOA	ETF	30.38	30.68	30.38	30.39	32600.0
2009-12-24	AOK	ETF	27.65	27.65	27.565	27.6	7535.0
2009-12-24	AOM	ETF	28.64	28.66	28.489	28.54	3321.0
2009-12-24	AOR	ETF	29.24	29.36	29.24	29.27	44855.0
2009-12-24	ARB	ETF	24.47	24.76	24.14	24.14	62513.0
2009-12-24	BAB	ETF	24.31	24.3599	24.18	24.275	116622.0
2009-12-24	BAL	ETF	36.19	36.26	36.07	36.07	2835.0
2009-12-24	BBH	ETF	32.6033	32.6033	32.3	32.5033	181800.0
2009-12-24	BIL	ETF	91.7	91.72	91.7	91.72	69100.0
2009-12-24	BITS	ETF	30.32	30.32	29.92	30.24	650.0
2009-12-24	BIV	ETF	79.44	79.47	79.2	79.2	80500.0
2009-12-24	BJK	ETF	23.53	23.57	23.47	23.5	4900.0
2009-12-24	BKF	ETF	45.66	45.75	45.2443	45.64	101334.0
2009-12-24	BLV	ETF	75.95	75.95	75.37	75.37	64000.0
2009-12-24	BMVP	ETF	12.78	12.83	12.78	12.83	8944.0
2009-12-24	BND	ETF	78.72	78.75	78.61	78.66	567900.0
2009-12-24	BNE	ETF	7.0	7.07	6.93	6.97	51963.0
2009-12-24	BRF	ETF	47.75	48.09	47.52	47.86	157278.0
2009-12-24	BSV	ETF	79.83	79.85	79.64	79.68	305600.0
2009-12-24	BTF	ETF	63.550000000000004	64.05	63.550000000000004	63.65	845.4000000000001
2009-12-24	BWX	ETF	28.69	28.9	28.56	28.6	91654.0
2009-12-24	BWZ	ETF	36.64	36.68	36.598	36.64	9168.0
2009-12-24	BZQ	ETF	3844.8	3862.4	3795.2	3806.4	63.0
2009-12-24	CEF	ETF	13.85	14.0	13.8	13.98	535000.0
2009-12-24	CEW	ETF	21.77	21.89	21.77	21.84	50899.0
2009-12-24	CGO	ETF	14.3	14.35	14.25	14.3105	4107.0
2009-12-24	CGW	ETF	18.57	18.57	18.42	18.53	51673.0
2009-12-24	CHI	ETF	12.55	12.57	12.51	12.56	151020.0
2009-12-24	CHIE	ETF	15.05	15.05	14.94	14.95	6825.0
2009-12-24	CHII	ETF	15.47	15.47	15.31	15.35	13408.0
2009-12-24	CHIQ	ETF	16.16	16.33	16.16	16.28	13425.0

> showing 50 of 694 rows — these rows as CSV

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