PREVIEW / stock_daily / 2011-06-20

all stock daily files

  file:    by_date/stock_daily/2011/2011-06-20.parquet
  size:    197 KB
  rows:    6,128
  symbols: 3,569

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
2011-06-20	AAPL	Stock	11.3343	11.3464	11.0893	11.2614	640645600.0
2011-06-20	MSFT	Stock	24.17	24.66	24.16	24.47	54338400.0
2011-06-20	NVDA	Stock	0.3918	0.4	0.3875	0.3905	745960000.0
2011-06-20	AMZN	Stock	9.298	9.4425	9.2785	9.386	56634000.0
2011-06-20	TSLA	Stock	1.7527	1.764	1.7	1.734	23067000.0
2011-06-20	TLT	Stock	97.33	97.36	96.585	97.02	6613995.0
2011-06-20	ES	Stock	34.72	35.07	34.59	35.06	1613900.0
2011-06-20	CL	Stock	43.965	44.64	43.9	44.555	7005000.0
2011-06-20	A	Stock	33.6838	34.7139	33.4907	34.6066	5328337.0
2011-06-20	AABA-DELISTED	Stock	14.71	15.42	14.66	14.99	32124238.0
2011-06-20	AACC-DELISTED	Stock	3.37	3.56	3.37	3.52	29786.0
2011-06-20	AACG	Stock	10.01	10.4	10.0	10.31	25800.0
2011-06-20	AAIC-DELISTED	Stock	28.81	30.3891	28.69	30.12	113646.0
2011-06-20	AAME	Stock	2.05	2.05	1.98	2.04	1500.0
2011-06-20	AAON	Stock	6.5422	6.717	6.483	6.717	200138.0
2011-06-20	AAP	Stock	58.03	59.25	57.62	59.04	1730400.0
2011-06-20	AAT	Stock	21.95	22.24	21.32	21.81	165200.0
2011-06-20	AATI-DELISTED	Stock	6.04	6.05	6.03	6.04	443409.0
2011-06-20	AAU-DELISTED	Stock	3.0	3.09	2.94	3.0568	260226.0
2011-06-20	AAUAF-DELISTED	Stock	3.0	3.09	2.94	3.0568	260426.0
2011-06-20	AAV-DELISTED	Stock	7.54	7.64	7.52	7.56	197958.0
2011-06-20	AAWW-DELISTED	Stock	56.0	56.92	55.55	56.31	149045.0
2011-06-20	AAXJ	Stock	59.23	59.77	59.23	59.77	168015.0
2011-06-20	AAXN-DELISTED	Stock	4.2	4.2891	4.2	4.23	277161.0
2011-06-20	AB	Stock	19.07	19.24	18.91	19.04	140300.0
2011-06-20	ABAC-DELISTED	Stock	2.18	2.27	2.05	2.05	17810.0
2011-06-20	ABAX-DELISTED	Stock	27.33	27.7	27.01	27.57	156393.0
2011-06-20	ABB-DELISTED	Stock	24.74	24.87	24.58	24.65	2232945.0
2011-06-20	ABBC-DELISTED	Stock	10.77	10.99	10.71	10.92	27099.0
2011-06-20	ABBNY-DELISTED	Stock	24.74	24.87	24.58	24.63	2233245.0
2011-06-20	ABC-DELISTED	Stock	40.99	41.43	40.99	41.379	1177090.0
2011-06-20	ABCB	Stock	9.03	9.2	9.0	9.06	25400.0
2011-06-20	ABCD-DELISTED	Stock	3.15	3.19	3.12	3.16	23027.0
2011-06-20	ABCO-DELISTED	Stock	25.74	26.13	25.74	26.07	111820.0
2011-06-20	ABCW-DELISTED	Stock	0.75	0.75	0.66	0.7	18470.0
2011-06-20	ABD-DELISTED	Stock	7.57	7.71	7.53	7.61	155700.0
2011-06-20	ABE-DELISTED	Stock	18.14	18.325	18.12	18.32	4927.0
2011-06-20	ABEO	Stock	2125.0	2437.5	2075.0	2187.5	22.0
2011-06-20	ABFS-DELISTED	Stock	21.93	22.26	21.81	21.96	221880.0
2011-06-20	ABG	Stock	16.25	17.31	16.09	17.05	509900.0
2011-06-20	ABH-DELISTED	Stock	21.37	22.06	21.31	21.8	476201.0
2011-06-20	ABM	Stock	22.55	23.2	22.53	23.04	399800.0
2011-06-20	ABMD-DELISTED	Stock	16.36	17.06	16.36	16.8	111268.0
2011-06-20	ABR	Stock	4.36	4.44	4.28	4.39	57800.0
2011-06-20	ABT	Stock	24.8009	25.036	24.7385	24.9592	11616090.0
2011-06-20	ABTL-DELISTED	Stock	5.0485	5.197	4.851	4.9	18309.0
2011-06-20	ABUS	Stock	2.61	2.72	2.61	2.67	5900.0
2011-06-20	ABV-DELISTED	Stock	31.17	31.9	31.12	31.81	1440071.0
2011-06-20	ABVA-DELISTED	Stock	4.84	4.84	4.7	4.79	30540.0
2011-06-20	ABVT-DELISTED	Stock	70.12	70.36	69.48	70.32	161351.0

> showing 50 of 6,128 rows — these rows as CSV

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