PREVIEW / etf_daily / 2009-09-21

all etf daily files

  file:    by_date/etf_daily/2009/2009-09-21.parquet
  size:    29 KB
  rows:    675

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-21	SPY	ETF	105.89	107.0	105.66	106.45	151892000.0
2009-09-21	QQQ	ETF	42.22	42.7	42.16	42.57	71351343.0
2009-09-21	IWM	ETF	61.32	61.96	61.09	61.74	37511600.0
2009-09-21	DIA	ETF	97.56	98.04	97.23	97.74	7711800.0
2009-09-21	GLD	ETF	97.95	98.62	97.73	98.36	11113200.0
2009-09-21	TLT	ETF	96.1	96.49	95.36	95.98	3050200.0
2009-09-21	AAXJ	ETF	52.36	52.47	51.87	52.4	168000.0
2009-09-21	ACWI	ETF	40.8	40.97	40.58	40.9	41300.0
2009-09-21	ACWX	ETF	39.62	39.94	39.48	39.94	47527.0
2009-09-21	ADRE	ETF	40.61	40.76	40.24	40.7	518636.0
2009-09-21	AFK	ETF	28.5	28.9	28.5	28.7515	7520.0
2009-09-21	AGG	ETF	104.2	104.39	104.09	104.16	433600.0
2009-09-21	AGQ	ETF	116.4	119.4	114.94	117.68	202300.0
2009-09-21	AGZ	ETF	108.42	108.4616	108.17	108.18	7069.0
2009-09-21	AIA	ETF	38.31	38.59	38.2699	38.431	14972.0
2009-09-21	AIQ	ETF	28.25	28.3	27.85	28.1	42767.0
2009-09-21	AIS	ETF	1.09	1.15	1.09	1.14	340802.0
2009-09-21	AIVI	ETF	42.95	43.29	42.27	42.9	35000.0
2009-09-21	AMJ	ETF	24.77	25.04	24.69	25.03	167979.0
2009-09-21	AOA	ETF	29.17	29.29	29.13	29.26	4800.0
2009-09-21	AOK	ETF	27.24	27.32	27.0118	27.17	4331.0
2009-09-21	AOM	ETF	28.02	28.39	27.88	27.95	27319.0
2009-09-21	AOR	ETF	28.48	28.75	28.4506	28.54	7372.0
2009-09-21	ARB	ETF	19.12	19.26	18.85	19.19	132222.0
2009-09-21	BAL	ETF	32.4	32.47	32.37	32.38	2217.0
2009-09-21	BBH	ETF	34.0933	34.6233	34.0067	34.58	382800.0
2009-09-21	BIL	ETF	91.7	91.76	91.7	91.76	101900.0
2009-09-21	BITS	ETF	21.2	21.6	20.52	20.52	3033.0
2009-09-21	BIV	ETF	79.78	79.86	79.51	79.59	109900.0
2009-09-21	BJK	ETF	25.75	26.65	25.5	25.75	12100.0
2009-09-21	BKF	ETF	41.26	41.473	40.75	41.4	166234.0
2009-09-21	BLV	ETF	78.53	78.84	78.26	78.56	13600.0
2009-09-21	BMVP	ETF	12.02	12.1	11.98	12.08	14574.0
2009-09-21	BND	ETF	79.1	79.12	78.93	79.04	414600.0
2009-09-21	BNE	ETF	7.2	7.34	6.94	6.98	171644.0
2009-09-21	BOSS	ETF	20.0	20.59	20.0	20.59	100.0
2009-09-21	BRF	ETF	39.05	39.39	39.0	39.23	151243.0
2009-09-21	BSV	ETF	79.87	79.89	79.71	79.84	404200.0
2009-09-21	BTF	ETF	59.9	60.25	59.5985	59.949999999999996	4182.0
2009-09-21	BWX	ETF	28.925	29.0	28.7	28.855	197368.0
2009-09-21	BWZ	ETF	37.8	37.8	36.9999	37.0	53130.0
2009-09-21	BZQ	ETF	5851.2	5892.8	5721.6	5732.8	27.5
2009-09-21	CEF	ETF	12.95	13.01	12.75	12.99	1043300.0
2009-09-21	CEW	ETF	21.63	21.65	21.55	21.58	30402.0
2009-09-21	CGO	ETF	14.19	14.21	13.91	13.96	44399.0
2009-09-21	CGW	ETF	17.93	18.084	17.82	17.95	140970.0
2009-09-21	CHB	ETF	0.52	0.579	0.5001	0.54	1983508.0
2009-09-21	CHI	ETF	11.68	11.7165	11.44	11.49	126560.0
2009-09-21	CHIC	ETF	17.46	17.49	17.46	17.46	579109.0
2009-09-21	CHW	ETF	7.68	7.78	7.6	7.75	142541.0

> showing 50 of 675 rows — these rows as CSV

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