PREVIEW / etf_daily / 2009-10-01

all etf daily files

  file:    by_date/etf_daily/2009/2009-10-01.parquet
  size:    30 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-10-01	SPY	ETF	103.0	105.73	102.95	102.97	281840600.0
2009-10-01	QQQ	ETF	42.11	42.13	41.0	41.0	140119051.0
2009-10-01	IWM	ETF	60.13	60.18	58.34	58.44	62840600.0
2009-10-01	DIA	ETF	96.92	96.94	95.01	95.12	15473500.0
2009-10-01	GLD	ETF	98.84	98.86	97.88	97.89	11049400.0
2009-10-01	TLT	ETF	98.96	100.06	98.8	99.7	5754400.0
2009-10-01	AAXJ	ETF	52.29	52.8	51.25	51.45	514200.0
2009-10-01	ACWI	ETF	40.65	40.66	39.69	39.69	1058800.0
2009-10-01	ACWX	ETF	39.67	39.67	38.64	38.64	26715.0
2009-10-01	ADRE	ETF	41.05	41.05	39.932	39.952	117407.0
2009-10-01	AFK	ETF	28.55	28.7185	28.31	28.365	13632.0
2009-10-01	AGG	ETF	104.64	104.84	104.4	104.82	784700.0
2009-10-01	AGQ	ETF	114.92	115.56	110.4	110.48	270350.0
2009-10-01	AGZ	ETF	108.74	108.75	108.48	108.73	8324.0
2009-10-01	AIA	ETF	38.25	38.25	37.4	37.579	32272.0
2009-10-01	AIQ	ETF	28.1	28.35	27.5	27.8	45963.0
2009-10-01	AIS	ETF	1.11	1.11	1.07	1.1	318634.0
2009-10-01	AIVI	ETF	41.8	41.8	40.87	40.88	52800.0
2009-10-01	AMJ	ETF	24.97	24.97	24.56	24.64	192139.0
2009-10-01	AOA	ETF	28.93	28.93	28.31	28.32	17500.0
2009-10-01	AOK	ETF	27.27	27.27	26.97	27.0	23226.0
2009-10-01	AOM	ETF	27.9	27.9	27.45	27.49	3691.0
2009-10-01	AOR	ETF	28.34	28.34	27.85	27.85	4265.0
2009-10-01	ARB	ETF	20.49	21.79	20.33	20.87	813820.0
2009-10-01	BAL	ETF	32.38	32.38	31.75	31.83	6933.0
2009-10-01	BBH	ETF	33.7033	33.8767	33.1267	33.1267	475800.0
2009-10-01	BIL	ETF	91.72	91.74	91.7	91.7	591400.0
2009-10-01	BITS	ETF	21.4	21.4	21.16	21.4	364.0
2009-10-01	BIV	ETF	80.5	80.8	80.46	80.75	81800.0
2009-10-01	BJK	ETF	25.58	25.58	24.8	24.9	26000.0
2009-10-01	BKF	ETF	41.61	41.76	40.71	40.87	307008.0
2009-10-01	BLV	ETF	79.98	80.23	79.53	80.13	1574100.0
2009-10-01	BMVP	ETF	11.96	11.96	11.72	11.72	24528.0
2009-10-01	BND	ETF	79.4	79.61	79.28	79.61	2491800.0
2009-10-01	BNE	ETF	7.61	7.7	7.32	7.34	335366.0
2009-10-01	BOSS	ETF	22.3	22.3	22.21	22.21	100.0
2009-10-01	BRF	ETF	40.19	40.42	39.0	39.18	232999.0
2009-10-01	BSV	ETF	80.1	80.1	79.92	79.98	309500.0
2009-10-01	BTF	ETF	59.74999999999999	59.74999999999999	59.004	59.15	3173.4
2009-10-01	BWX	ETF	29.15	29.18	28.955	29.065	917788.0
2009-10-01	BWZ	ETF	37.2	37.2	37.15	37.15	23200.0
2009-10-01	BZQ	ETF	5382.4	5579.2	5382.4	5579.2	8.75
2009-10-01	CEF	ETF	13.13	13.22	12.83	12.96	651100.0
2009-10-01	CEW	ETF	21.89	21.89	21.55	21.58	61079.0
2009-10-01	CGO	ETF	14.02	14.2	13.93	13.94	17425.0
2009-10-01	CGW	ETF	17.86	17.97	17.35	17.38	146253.0
2009-10-01	CHB	ETF	0.4699	0.4699	0.42	0.42	3375536.0
2009-10-01	CHI	ETF	11.89	11.9365	11.57	11.61	179820.0
2009-10-01	CHIC	ETF	17.49	17.51	17.49	17.49	252442.0
2009-10-01	CHW	ETF	7.76	7.78	7.58	7.63	189654.0

> showing 50 of 675 rows — these rows as CSV

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