PREVIEW / etf_daily / 2009-09-18

all etf daily files

  file:    by_date/etf_daily/2009/2009-09-18.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-09-18	SPY	ETF	107.15	107.16	106.36	106.72	153799100.0
2009-09-18	QQQ	ETF	42.56	42.62	42.21	42.44	87453059.0
2009-09-18	IWM	ETF	62.09	62.09	61.26	61.91	36822800.0
2009-09-18	DIA	ETF	98.34	98.46	97.92	98.11	9910900.0
2009-09-18	GLD	ETF	99.73	99.87	98.67	98.67	13937800.0
2009-09-18	TLT	ETF	96.2	96.53	95.67	95.76	2813300.0
2009-09-18	AAXJ	ETF	53.32	53.32	52.51	52.51	215800.0
2009-09-18	ACWI	ETF	41.21	41.37	41.04	41.25	1410600.0
2009-09-18	ACWX	ETF	40.49	40.49	40.08	40.25	45917.0
2009-09-18	ADRE	ETF	41.2	41.2	40.8	40.83	115385.0
2009-09-18	AFK	ETF	28.92	29.59	28.85	29.24	9992.0
2009-09-18	AGG	ETF	104.25	104.39	104.12	104.24	470300.0
2009-09-18	AGQ	ETF	123.64	123.78	120.1	120.2	228350.0
2009-09-18	AGZ	ETF	108.47	108.47	107.8001	107.8801	13943.0
2009-09-18	AIA	ETF	38.7	38.89	38.55	38.74	60119.0
2009-09-18	AIQ	ETF	29.0	29.239	28.001	28.45	38086.0
2009-09-18	AIS	ETF	1.1	1.13	1.06	1.13	484524.0
2009-09-18	AIVI	ETF	43.93	43.93	43.41	43.69	19100.0
2009-09-18	AMJ	ETF	25.04	25.455	24.4599	24.85	250593.0
2009-09-18	AOA	ETF	29.3	29.44	29.29	29.41	3800.0
2009-09-18	AOK	ETF	27.13	27.23	27.03	27.23	15280.0
2009-09-18	AOM	ETF	28.23	28.72	27.9875	28.0	8426.0
2009-09-18	AOR	ETF	28.91	28.91	28.5668	28.67	5808.0
2009-09-18	ARB	ETF	19.06	19.31	18.94	19.25	422546.0
2009-09-18	BAL	ETF	32.89	33.49	32.89	33.2801	4487.0
2009-09-18	BBH	ETF	33.9867	34.1667	33.9133	33.98	149700.0
2009-09-18	BIL	ETF	91.7	91.72	91.7	91.7	483250.0
2009-09-18	BITS	ETF	21.88	22.08	20.24	21.12	11956.0
2009-09-18	BIV	ETF	79.8	79.9	79.5	79.6	114300.0
2009-09-18	BJK	ETF	26.57	26.98	25.78	26.28	11000.0
2009-09-18	BKF	ETF	42.04	42.09	41.6	41.7	215501.0
2009-09-18	BLV	ETF	78.65	78.94	78.38	78.58	18300.0
2009-09-18	BMVP	ETF	12.1533	12.156	12.0711	12.1233	38946.0
2009-09-18	BND	ETF	79.18	79.19	78.95	79.1	432800.0
2009-09-18	BNE	ETF	7.1	7.39	6.84	7.38	350503.0
2009-09-18	BOSS	ETF	19.7	20.29	19.7	20.29	300.0
2009-09-18	BRF	ETF	39.69	39.78	39.29	39.4	197701.0
2009-09-18	BSV	ETF	79.87	79.94	79.75	79.86	357500.0
2009-09-18	BTF	ETF	60.0	60.14999999999999	59.55	59.949999999999996	4223.6
2009-09-18	BWX	ETF	29.225	29.225	29.06	29.09	447808.0
2009-09-18	BWZ	ETF	37.37	37.85	37.37	37.81	27910.0
2009-09-18	BZQ	ETF	5692.8	5784.0	5692.8	5780.8	17.0
2009-09-18	CEF	ETF	13.3	13.37	13.01	13.2	739500.0
2009-09-18	CEW	ETF	21.75	21.75	21.69	21.7	9873.0
2009-09-18	CGO	ETF	14.3	14.3	14.2	14.21	18663.0
2009-09-18	CGW	ETF	18.17	18.17	17.95	18.075	83642.0
2009-09-18	CHB	ETF	0.58	0.6	0.51	0.54	3139368.0
2009-09-18	CHI	ETF	11.71	11.85	11.67	11.73	140668.0
2009-09-18	CHIC	ETF	17.47	17.47	17.45	17.45	590347.0
2009-09-18	CHW	ETF	7.92	7.932	7.72	7.76	171888.0

> showing 50 of 671 rows — these rows as CSV

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