PREVIEW / etf_daily / 2008-07-14

all etf daily files

  file:    by_date/etf_daily/2008/2008-07-14.parquet
  size:    27 KB
  rows:    612

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-07-14	SPY	ETF	125.26	125.5	122.4	122.72	322720800.0
2008-07-14	QQQ	ETF	45.13	45.18	44.07	44.23	177389787.0
2008-07-14	IWM	ETF	67.78	67.9	65.86	66.16	113936200.0
2008-07-14	DIA	ETF	112.17	112.39	110.05	110.5	26009300.0
2008-07-14	GLD	ETF	95.09	96.2	94.92	95.91	21242900.0
2008-07-14	TLT	ETF	92.38	93.26	92.29	92.97	4135400.0
2008-07-14	ACWI	ETF	47.83	47.93	47.15	47.31	1231200.0
2008-07-14	ACWX	ETF	48.35	48.41	48.08	48.34	1820.0
2008-07-14	ADRE	ETF	48.52	48.83	47.928	48.1	205968.0
2008-07-14	AFK	ETF	41.32	41.4	41.32	41.4	4000.0
2008-07-14	AGG	ETF	100.22	100.84	100.22	100.38	366000.0
2008-07-14	AIA	ETF	40.5	40.5	39.72	40.12	7643.0
2008-07-14	AIQ	ETF	42.85	42.95	41.9	42.4	26047.0
2008-07-14	AIS	ETF	0.71	0.72	0.7	0.72	48695.0
2008-07-14	AIVI	ETF	58.12	58.42	57.44	57.56	35200.0
2008-07-14	ARB	ETF	45.36	45.81	44.47	44.65	355218.0
2008-07-14	BAL	ETF	45.12	45.12	44.88	45.0	700.0
2008-07-14	BBH	ETF	58.95	59.09	57.74	57.7833	910500.0
2008-07-14	BIL	ETF	91.78	91.84	91.74	91.82	64400.0
2008-07-14	BITS	ETF	23.48	23.92	23.0	23.44	1925.0
2008-07-14	BIV	ETF	76.35	76.91	76.32	76.77	34200.0
2008-07-14	BJK	ETF	31.54	31.54	28.79	29.1	1900.0
2008-07-14	BKF	ETF	49.85	50.65	49.29	49.29	45710.0
2008-07-14	BLV	ETF	74.12	75.04	74.12	74.82	16700.0
2008-07-14	BMVP	ETF	14.7667	15.1733	14.66	14.6833	19920.0
2008-07-14	BND	ETF	76.04	76.46	76.03	76.32	193800.0
2008-07-14	BNE	ETF	11.78	11.8	11.1	11.13	328183.0
2008-07-14	BRF	ETF	14.74	14.74	14.68	14.68	14700.0
2008-07-14	BSV	ETF	77.41	77.52	77.18	77.45	53200.0
2008-07-14	BTF	ETF	83.14999999999999	83.39	77.39999999999999	81.99999999999999	12654.0
2008-07-14	BWX	ETF	27.98	28.145	27.897	28.1	190106.0
2008-07-14	CBON	ETF	3.38	3.45	2.97	2.98	178130.0
2008-07-14	CDL	ETF	0.88	0.97	0.82	0.83	2135459.0
2008-07-14	CEF	ETF	13.94	14.4	13.94	14.38	1576000.0
2008-07-14	CGO	ETF	14.81	14.82	14.4	14.59	18457.0
2008-07-14	CGW	ETF	22.56	22.56	21.65	21.94	189588.0
2008-07-14	CHB	ETF	4.73	4.9	4.42	4.59	1349744.0
2008-07-14	CHI	ETF	13.21	13.25	12.5	12.64	229538.0
2008-07-14	CHIC	ETF	16.0	16.33	15.19	15.48	345243.0
2008-07-14	CHW	ETF	10.9	10.9	10.13	10.29	223541.0
2008-07-14	CHY	ETF	12.15	12.28	11.51	11.77	235648.0
2008-07-14	CMF	ETF	51.65	51.75	51.625	51.625	4216.0
2008-07-14	CN	ETF	59.18	59.18	57.19	57.49	253770.0
2008-07-14	COW	ETF	43.6	43.6	42.85	42.89	119082.0
2008-07-14	CPST	ETF	3.68	3.72	3.5	3.5	2956837.0
2008-07-14	CSA	ETF	16.57	16.57	16.3	16.31	48685.0
2008-07-14	CSB	ETF	16.25	16.5	8.795	10.52	94125.0
2008-07-14	CSD	ETF	20.82	20.82	20.41	20.41	11900.0
2008-07-14	CSQ	ETF	10.62	10.76	10.22	10.26	493598.0
2008-07-14	CUT	ETF	18.05	18.2	17.86	17.96	18000.0

> showing 50 of 612 rows — these rows as CSV

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