PREVIEW / etf_daily / 2010-09-30

all etf daily files

  file:    by_date/etf_daily/2010/2010-09-30.parquet
  size:    34 KB
  rows:    793

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
2010-09-30	SPY	ETF	115.05	115.79	113.59	114.13	287106700.0
2010-09-30	QQQ	ETF	49.54	49.84	48.75	49.07	122458536.0
2010-09-30	IWM	ETF	68.17	68.55	66.95	67.5	81818000.0
2010-09-30	DIA	ETF	108.91	109.52	107.47	107.91	11670500.0
2010-09-30	GLD	ETF	128.15	128.28	126.61	127.91	19213400.0
2010-09-30	TLT	ETF	105.4	105.59	104.03	105.51	10618400.0
2010-09-30	AADR	ETF	28.37	28.37	28.2	28.21	5000.0
2010-09-30	AAXJ	ETF	60.57	60.87	60.23	60.51	526200.0
2010-09-30	ACWI	ETF	43.41	43.73	42.98	43.21	379200.0
2010-09-30	ACWX	ETF	41.65	41.87	41.14	41.37	181516.0
2010-09-30	ADRE	ETF	44.97	45.19	44.59	45.05	128066.0
2010-09-30	AFK	ETF	32.21	32.32	31.933	32.14	6182.0
2010-09-30	AGG	ETF	108.64	108.7	108.29	108.65	2628600.0
2010-09-30	AGQ	ETF	169.5	170.56	163.16	166.52	298450.0
2010-09-30	AGZ	ETF	111.64	111.64	111.2714	111.41	30818.0
2010-09-30	AIA	ETF	42.46	42.54	42.0719	42.34	35016.0
2010-09-30	AIQ	ETF	23.25	23.25	21.55	22.9	51864.0
2010-09-30	AIS	ETF	1.46	1.46	1.42	1.45	398480.0
2010-09-30	AIVI	ETF	43.66	43.66	42.75	43.07	16000.0
2010-09-30	AMJ	ETF	33.74	33.79	33.55	33.74	497274.0
2010-09-30	AMLP	ETF	77.4	77.4	76.9	77.25	256800.0
2010-09-30	AOA	ETF	31.78	31.98	31.47	31.61	7700.0
2010-09-30	AOK	ETF	28.47	28.47	28.342	28.42	15201.0
2010-09-30	AOM	ETF	29.14	29.23	28.99	29.09	56182.0
2010-09-30	AOR	ETF	30.23	30.23	29.89	29.96	8391.0
2010-09-30	ARB	ETF	28.17	28.47	27.95	27.97	193320.0
2010-09-30	BAB	ETF	26.82	26.83	26.59	26.8	152236.0
2010-09-30	BAL	ETF	50.0	50.669	48.8	49.989	32699.0
2010-09-30	BALT	ETF	11.1	11.1	10.76	11.01	219200.0
2010-09-30	BBH	ETF	31.9167	32.15	31.8033	31.9633	25500.0
2010-09-30	BICK	ETF	31.61	33.29	31.36	31.61	30818.0
2010-09-30	BIL	ETF	91.7	91.72	91.7	91.7	214200.0
2010-09-30	BIS	ETF	9638.4	9764.8	9638.4	9764.8	3.125
2010-09-30	BITS	ETF	27.92	27.92	26.84	26.88	6575.0
2010-09-30	BIV	ETF	86.74	86.74	86.26	86.72	421900.0
2010-09-30	BJK	ETF	28.22	28.24	27.78	27.92	15000.0
2010-09-30	BKF	ETF	47.6	47.88	47.39	47.76	150041.0
2010-09-30	BLV	ETF	85.99	86.06	85.22	85.95	44700.0
2010-09-30	BMVP	ETF	13.238	13.238	13.033	13.11	9331.0
2010-09-30	BND	ETF	82.64	82.7	82.39	82.66	770400.0
2010-09-30	BNE	ETF	11.05	11.38	11.02	11.33	3366331.0
2010-09-30	BRF	ETF	55.96	56.23	55.431	56.19	274694.0
2010-09-30	BSCE	ETF	20.98	20.99	20.964	20.97	5670.0
2010-09-30	BSV	ETF	81.81	81.81	81.65	81.75	518300.0
2010-09-30	BTF	ETF	76.3	76.5	75.5	75.6	4230.8
2010-09-30	BWX	ETF	30.12	30.205	29.9235	29.98	614810.0
2010-09-30	BWZ	ETF	36.8101	36.95	36.8101	36.95	6187.0
2010-09-30	BZQ	ETF	2729.6	2780.8	2716.8	2729.6	1012.0
2010-09-30	CEF	ETF	16.78	16.95	16.47	16.6	1529600.0
2010-09-30	CEW	ETF	22.95	22.95	22.86	22.92	183028.0

> showing 50 of 793 rows — these rows as CSV

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