PREVIEW / etf_daily / 2008-11-19

all etf daily files

  file:    by_date/etf_daily/2008/2008-11-19.parquet
  size:    27 KB
  rows:    617

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
2008-11-19	SPY	ETF	85.91	86.87	80.92	81.5	558327600.0
2008-11-19	QQQ	ETF	28.4	28.78	26.79	26.86	244288925.0
2008-11-19	IWM	ETF	44.78	45.15	41.24	41.36	96005900.0
2008-11-19	DIA	ETF	84.23	85.37	80.18	80.36	49759400.0
2008-11-19	GLD	ETF	73.42	75.19	72.0	72.26	13963100.0
2008-11-19	TLT	ETF	97.47	99.37	97.21	99.3	2090400.0
2008-11-19	AAXJ	ETF	28.94	28.94	27.0	27.0	669800.0
2008-11-19	ACWI	ETF	29.79	30.0	27.85	28.13	2424800.0
2008-11-19	ACWX	ETF	27.13	27.13	25.47	25.49	84737.0
2008-11-19	ADRE	ETF	23.4	23.76	22.02	22.04	242901.0
2008-11-19	AFK	ETF	21.89	21.89	20.75	20.75	1192.0
2008-11-19	AGG	ETF	97.46	97.89	97.3	97.38	546500.0
2008-11-19	AIA	ETF	22.33	22.39	21.25	21.25	9572.0
2008-11-19	AIQ	ETF	43.45	44.8	41.6	41.7	78533.0
2008-11-19	AIS	ETF	0.44	0.44	0.34	0.36	540900.0
2008-11-19	AIVI	ETF	33.15	33.56	31.55	31.55	27600.0
2008-11-19	AOA	ETF	23.86	23.86	19.48	20.06	19400.0
2008-11-19	AOK	ETF	24.41	24.41	24.41	24.41	1273.0
2008-11-19	AOM	ETF	26.5	26.5	23.73	25.07	2200.0
2008-11-19	AOR	ETF	23.11	23.11	23.11	23.11	200.0
2008-11-19	ARB	ETF	19.05	20.46	16.31	16.38	1513521.0
2008-11-19	BAL	ETF	24.7022	24.7022	24.65	24.65	350.0
2008-11-19	BBH	ETF	55.39	56.2367	53.8067	54.0667	1303800.0
2008-11-19	BIL	ETF	91.92	91.92	91.82	91.82	81200.0
2008-11-19	BITS	ETF	15.36	15.4	14.8	15.08	6650.0
2008-11-19	BIV	ETF	73.16	73.69	72.99	73.55	48500.0
2008-11-19	BJK	ETF	15.66	15.66	14.9	14.9	600.0
2008-11-19	BKF	ETF	21.03	21.46	20.08	20.08	24880.0
2008-11-19	BLV	ETF	68.91	70.28	68.82	70.04	23800.0
2008-11-19	BMVP	ETF	9.94	10.09	9.4	9.42	41096.0
2008-11-19	BND	ETF	74.37	74.99	74.37	74.93	154900.0
2008-11-19	BNE	ETF	2.5	2.5	2.23	2.24	158099.0
2008-11-19	BRF	ETF	14.91	14.91	14.91	14.91	1300.0
2008-11-19	BSV	ETF	77.0	77.4	76.9	77.3	68000.0
2008-11-19	BTF	ETF	42.300000000000004	44.699999999999996	42.24999999999999	42.24999999999999	27756.4
2008-11-19	BWX	ETF	24.7	25.05	24.45	24.45	289168.0
2008-11-19	CBON	ETF	2.57	2.95	2.45	2.45	87157.0
2008-11-19	CDL	ETF	0.24	0.25	0.2	0.21	1457734.0
2008-11-19	CEF	ETF	8.48	8.9	8.43	8.6	811800.0
2008-11-19	CGO	ETF	8.5	8.57	7.9	8.05	30680.0
2008-11-19	CGW	ETF	14.27	14.6	13.5	13.5	138626.0
2008-11-19	CHB	ETF	0.6	0.7	0.48	0.51	2599733.0
2008-11-19	CHI	ETF	7.04	7.18	6.74	6.85	323684.0
2008-11-19	CHIC	ETF	5.9835	5.9835	4.68	4.69	562196.0
2008-11-19	CHW	ETF	4.88	5.0	4.64	5.0	273610.0
2008-11-19	CHY	ETF	6.69	6.9	6.41	6.41	352373.0
2008-11-19	CMF	ETF	50.3	50.4575	49.96	49.96	4512.0
2008-11-19	CNXT	ETF	0.95	1.0	0.8	0.86	475689.0
2008-11-19	COW	ETF	34.31	34.5	33.6	33.6	26216.0
2008-11-19	CPI	ETF	22.75	22.75	22.75	22.75	100.0

> showing 50 of 617 rows — these rows as CSV

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