PREVIEW / etf_daily / 2009-11-02

all etf daily files

  file:    by_date/etf_daily/2009/2009-11-02.parquet
  size:    30 KB
  rows:    673

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-11-02	SPY	ETF	104.13	105.41	103.08	104.32	254222900.0
2009-11-02	QQQ	ETF	41.01	41.57	40.64	41.13	142520642.0
2009-11-02	IWM	ETF	56.63	57.14	55.33	56.22	97996600.0
2009-11-02	DIA	ETF	97.4	99.0	96.82	97.85	20615900.0
2009-11-02	GLD	ETF	103.5	104.25	103.25	103.95	15440900.0
2009-11-02	TLT	ETF	95.51	95.58	94.8	95.05	3463800.0
2009-11-02	AAXJ	ETF	51.88	52.4	50.97	51.86	830600.0
2009-11-02	ACWI	ETF	40.05	40.5	39.58	40.09	75000.0
2009-11-02	ACWX	ETF	38.94	39.67	38.68	39.18	1505964.0
2009-11-02	ADRE	ETF	40.8	41.66	40.4001	41.09	632569.0
2009-11-02	AFK	ETF	28.1	28.54	27.81	27.97	74741.0
2009-11-02	AGG	ETF	104.55	104.6	104.24	104.32	1036700.0
2009-11-02	AGQ	ETF	110.48	113.92	108.64	109.76	289200.0
2009-11-02	AGZ	ETF	108.5	109.0	108.0	108.15	28394.0
2009-11-02	AIA	ETF	37.36	37.8499	37.0519	37.63	69008.0
2009-11-02	AIQ	ETF	27.6	27.65	26.25	26.85	64544.0
2009-11-02	AIS	ETF	1.15	1.17	1.06	1.0999	525554.0
2009-11-02	AIVI	ETF	41.02	42.14	40.99	41.51	25300.0
2009-11-02	AMJ	ETF	25.72	25.88	25.3	25.64	754190.0
2009-11-02	AOA	ETF	28.25	28.41	28.07	28.32	8100.0
2009-11-02	AOK	ETF	26.99	27.05	26.92	27.005	6763.0
2009-11-02	AOM	ETF	27.52	27.642	27.4	27.4455	11304.0
2009-11-02	AOR	ETF	27.86	28.0149	27.7	27.79	19932.0
2009-11-02	ARB	ETF	21.72	22.0	21.5225	21.74	618279.0
2009-11-02	BAL	ETF	35.52	36.13	35.0995	35.29	20035.0
2009-11-02	BBH	ETF	30.15	30.5767	29.8267	30.0933	291600.0
2009-11-02	BIL	ETF	91.76	91.76	91.74	91.76	245400.0
2009-11-02	BITS	ETF	25.52	26.0	25.32	26.0	19312.0
2009-11-02	BIV	ETF	80.25	80.28	79.98	80.07	169600.0
2009-11-02	BJK	ETF	23.63	24.0	23.13	23.54	64500.0
2009-11-02	BKF	ETF	43.14	43.6516	42.31	43.19	199770.0
2009-11-02	BLV	ETF	78.55	78.75	78.15	78.29	29200.0
2009-11-02	BMVP	ETF	11.6967	11.8175	11.6133	11.73	36908.0
2009-11-02	BND	ETF	79.29	79.32	79.05	79.15	525700.0
2009-11-02	BNE	ETF	6.61	6.7	6.25	6.37	161904.0
2009-11-02	BOSS	ETF	21.05	21.05	19.0	19.0	1100.0
2009-11-02	BRF	ETF	41.59	43.25	40.97	41.94	453933.0
2009-11-02	BSV	ETF	79.94	79.96	79.79	79.89	423000.0
2009-11-02	BTF	ETF	59.74999999999999	60.49999999999999	58.75	59.4	14444.2
2009-11-02	BWX	ETF	29.35	29.35	29.165	29.24	684336.0
2009-11-02	BWZ	ETF	37.24	37.29	37.1999	37.22	38186.0
2009-11-02	BZQ	ETF	4747.2	4958.4	4540.8	4750.4	212.5
2009-11-02	CEF	ETF	13.4	13.52	13.31	13.31	811300.0
2009-11-02	CEW	ETF	21.64	21.82	21.64	21.7	39998.0
2009-11-02	CGO	ETF	13.15	13.5	12.65	13.2	76095.0
2009-11-02	CGW	ETF	17.17	17.38	17.0	17.19	54792.0
2009-11-02	CHB	ETF	0.25	0.2578	0.21	0.23	1540496.0
2009-11-02	CHI	ETF	11.54	11.61	11.4	11.46	200051.0
2009-11-02	CHW	ETF	7.38	7.55	7.3006	7.45	155060.0
2009-11-02	CHY	ETF	11.08	11.246	11.02	11.18	206591.0

> showing 50 of 673 rows — these rows as CSV

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