PREVIEW / etf_daily / 2010-09-21

all etf daily files

  file:    by_date/etf_daily/2010/2010-09-21.parquet
  size:    34 KB
  rows:    786

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-21	SPY	ETF	114.3	114.84	113.51	113.98	268389100.0
2010-09-21	QQQ	ETF	48.84	49.17	48.61	48.82	82352602.0
2010-09-21	IWM	ETF	67.02	67.43	66.53	66.63	64974200.0
2010-09-21	DIA	ETF	107.54	108.31	107.17	107.62	8381800.0
2010-09-21	GLD	ETF	124.77	126.17	124.16	126.01	20408400.0
2010-09-21	TLT	ETF	102.67	104.02	102.26	103.68	12664000.0
2010-09-21	AADR	ETF	27.66	27.75	27.66	27.75	500.0
2010-09-21	AAXJ	ETF	59.35	59.38	58.88	59.07	344200.0
2010-09-21	ACWI	ETF	43.14	43.16	42.62	42.81	343400.0
2010-09-21	ACWX	ETF	41.06	41.17	40.58	40.91	126849.0
2010-09-21	ADRE	ETF	43.66	43.6892	43.2319	43.56	81360.0
2010-09-21	AFK	ETF	31.67	31.83	31.419	31.7	84989.0
2010-09-21	AGG	ETF	108.01	108.46	107.99	108.39	497200.0
2010-09-21	AGQ	ETF	150.76	156.6	148.04	156.02	346650.0
2010-09-21	AGZ	ETF	111.12	111.2899	110.9979	111.2899	14613.0
2010-09-21	AIA	ETF	41.7	41.7	41.39	41.58	13543.0
2010-09-21	AIQ	ETF	22.95	23.2	22.2	22.3	11744.0
2010-09-21	AIS	ETF	1.44	1.45	1.38	1.44	597903.0
2010-09-21	AIVI	ETF	42.67	42.87	42.23	42.84	42500.0
2010-09-21	AMJ	ETF	33.24	33.28	33.1	33.18	740631.0
2010-09-21	AMLP	ETF	76.45	76.55	76.25	76.45	101880.0
2010-09-21	AOA	ETF	31.35	31.45	31.19	31.27	9500.0
2010-09-21	AOK	ETF	28.27	28.4	28.27	28.37	8457.0
2010-09-21	AOM	ETF	29.1	29.1599	29.0255	29.11	8627.0
2010-09-21	AOR	ETF	29.86	29.9044	29.81	29.883	3931.0
2010-09-21	ARB	ETF	28.55	28.68	27.59	27.65	170959.0
2010-09-21	BAB	ETF	26.53	26.6	26.4	26.6	283100.0
2010-09-21	BAL	ETF	49.51	50.05	49.3	49.615	21479.0
2010-09-21	BALT	ETF	11.31	11.33	11.06	11.21	99410.0
2010-09-21	BBH	ETF	32.14	32.4567	32.13	32.36	76800.0
2010-09-21	BIB	ETF	6.4512	6.4825	6.425	6.4375	69520.0
2010-09-21	BICK	ETF	30.94	30.95	30.63	30.7899	36833.0
2010-09-21	BIL	ETF	91.72	91.72	91.7	91.7	742150.0
2010-09-21	BIS	ETF	9761.6	9761.6	9761.6	9761.6	1.25
2010-09-21	BITS	ETF	26.88	27.0	25.68	26.72	3850.0
2010-09-21	BIV	ETF	85.84	86.23	85.62	86.17	145300.0
2010-09-21	BJK	ETF	27.8	27.91	27.58	27.63	3300.0
2010-09-21	BKF	ETF	46.74	46.85	46.27	46.58	215656.0
2010-09-21	BLV	ETF	84.11	85.09	83.99	84.76	37600.0
2010-09-21	BMVP	ETF	12.98	13.02	12.9	12.94	12470.0
2010-09-21	BND	ETF	82.07	82.42	82.07	82.36	577700.0
2010-09-21	BNE	ETF	11.09	11.11	11.07	11.07	167347.0
2010-09-21	BNO	ETF	26.67	26.67	26.49	26.49	5800.0
2010-09-21	BRF	ETF	55.29	55.29	54.71	55.22	489671.0
2010-09-21	BSCE	ETF	20.88	20.9	20.88	20.9	6617.0
2010-09-21	BSV	ETF	81.53	81.64	81.48	81.63	795800.0
2010-09-21	BTF	ETF	75.19999999999999	75.75	74.8	74.89999999999999	4929.400000000001
2010-09-21	BWX	ETF	28.965	29.25	28.93	29.065	219854.0
2010-09-21	BWZ	ETF	35.95	36.45	35.95	36.305	31376.0
2010-09-21	BZQ	ETF	3097.6	3147.2	3051.2	3052.8	1297.5

> showing 50 of 786 rows — these rows as CSV

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