PREVIEW / etf_daily / 2008-09-19

all etf daily files

  file:    by_date/etf_daily/2008/2008-09-19.parquet
  size:    27 KB
  rows:    613

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-09-19	SPY	ETF	126.7	128.0	123.33	124.12	501087800.0
2008-09-19	QQQ	ETF	43.82	43.83	42.1	42.9	263401424.0
2008-09-19	IWM	ETF	78.92	86.05	73.95	75.0	138448700.0
2008-09-19	DIA	ETF	116.14	116.14	112.66	113.57	20860900.0
2008-09-19	GLD	ETF	85.58	86.44	84.0	85.98	25484700.0
2008-09-19	TLT	ETF	93.86	95.02	93.7	93.97	7169200.0
2008-09-19	AAXJ	ETF	44.51	46.23	44.51	46.19	3700.0
2008-09-19	ACWI	ETF	47.93	49.55	43.4	45.08	103600.0
2008-09-19	ACWX	ETF	79.97	79.97	43.23	43.59	13190.0
2008-09-19	ADRE	ETF	42.68	42.68	40.01	41.3	571865.0
2008-09-19	AFK	ETF	35.52	35.52	34.5901	34.5901	389.0
2008-09-19	AGG	ETF	100.0	101.49	99.77	101.0	1985000.0
2008-09-19	AIA	ETF	38.46	38.46	33.99	37.45	13017.0
2008-09-19	AIQ	ETF	59.65	59.65	56.0	56.6	100495.0
2008-09-19	AIS	ETF	0.71	0.77	0.66	0.75	135300.0
2008-09-19	AIVI	ETF	58.0	58.0	54.17	55.93	30300.0
2008-09-19	ARB	ETF	49.75	50.07	47.47	47.75	656529.0
2008-09-19	BAL	ETF	38.71	38.8	38.71	38.8	400.0
2008-09-19	BBH	ETF	64.0233	64.0233	60.3667	61.8267	470100.0
2008-09-19	BIL	ETF	91.48	97.86	91.48	91.76	813150.0
2008-09-19	BITS	ETF	21.92	23.4	21.92	22.4	16840.0
2008-09-19	BIV	ETF	75.28	76.49	73.59	76.14	54400.0
2008-09-19	BJK	ETF	27.31	28.38	27.31	28.34	1500.0
2008-09-19	BKF	ETF	43.09	43.09	37.8601	39.47	123427.0
2008-09-19	BLV	ETF	74.01	74.4	73.0	74.25	25400.0
2008-09-19	BMVP	ETF	14.49	15.33	14.49	14.63	127819.0
2008-09-19	BND	ETF	77.53	77.53	75.52	76.61	222800.0
2008-09-19	BNE	ETF	12.85	13.01	11.5	12.25	555843.0
2008-09-19	BOSS	ETF	20.15	20.15	20.15	20.15	100.0
2008-09-19	BRF	ETF	14.9	14.9	14.49	14.74	26925.0
2008-09-19	BSV	ETF	77.5	78.78	76.7	77.39	215400.0
2008-09-19	BTF	ETF	80.89999999999999	85.0	78.8	81.5	19909.0
2008-09-19	BWX	ETF	25.3	26.155	25.095	26.075	210324.0
2008-09-19	CBON	ETF	6.5	9.52	5.76	6.5	258990.0
2008-09-19	CDL	ETF	1.24	1.24	0.75	0.75	2986504.0
2008-09-19	CEF	ETF	10.58	11.49	10.58	11.45	1836500.0
2008-09-19	CGO	ETF	12.41	12.55	12.22	12.55	23435.0
2008-09-19	CGW	ETF	21.7	23.11	21.7	22.04	54910.0
2008-09-19	CHB	ETF	6.51	7.88	5.91	7.0	6783104.0
2008-09-19	CHI	ETF	11.38	11.6	10.48	11.31	356265.0
2008-09-19	CHIC	ETF	12.25	12.88	11.49	11.7	716236.0
2008-09-19	CHW	ETF	9.01	9.54	8.61	8.9	348797.0
2008-09-19	CHY	ETF	11.0	11.3	10.64	11.2	314403.0
2008-09-19	CMF	ETF	50.495	50.87	50.295	50.305	9682.0
2008-09-19	CN	ETF	47.93	50.86	47.84	49.26	701084.0
2008-09-19	CNXT	ETF	4.06	4.56	3.89	3.9	626601.0
2008-09-19	COW	ETF	40.55	41.08	40.55	41.0	125221.0
2008-09-19	CPI	ETF	22.5999	22.6	22.5999	22.6	400.0
2008-09-19	CPST	ETF	1.48	1.53	1.32	1.52	7352533.0
2008-09-19	CSA	ETF	18.44	18.44	17.0	17.95	235309.0

> showing 50 of 613 rows — these rows as CSV

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