PREVIEW / stock_daily / 2011-03-29

all stock daily files

  file:    by_date/stock_daily/2011/2011-03-29.parquet
  size:    197 KB
  rows:    6,073
  symbols: 3,541

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-03-29	AAPL	Stock	12.4164	12.5343	12.3593	12.5343	352900800.0
2011-03-29	MSFT	Stock	25.34	25.52	25.3	25.49	40763500.0
2011-03-29	NVDA	Stock	0.483	0.4848	0.4728	0.4793	715764000.0
2011-03-29	AMZN	Stock	8.5365	8.742	8.5035	8.731	97692000.0
2011-03-29	TSLA	Stock	1.5533	1.6	1.5473	1.5947	11331000.0
2011-03-29	TLT	Stock	91.98	92.5	91.57	91.59	6489272.0
2011-03-29	ES	Stock	33.87	34.34	33.75	34.25	1086100.0
2011-03-29	CL	Stock	40.135	40.375	40.125	40.21	4509800.0
2011-03-29	A	Stock	31.4306	31.917	31.123	31.8741	3209389.0
2011-03-29	AABA-DELISTED	Stock	16.6	16.775	16.53	16.75	9952496.0
2011-03-29	AACC-DELISTED	Stock	5.32	5.38	5.32	5.37	2841.0
2011-03-29	AACG	Stock	7.99	8.0	7.9	7.99	6400.0
2011-03-29	AAI-DELISTED	Stock	7.41	7.43	7.37	7.3775	968584.0
2011-03-29	AAIC-DELISTED	Stock	30.71	30.86	30.71	30.81	25916.0
2011-03-29	AAME	Stock	2.17	2.17	2.17	2.17	700.0
2011-03-29	AAON	Stock	6.0267	6.2301	6.0267	6.1827	92644.0
2011-03-29	AAP	Stock	65.49	65.66	65.18	65.59	464400.0
2011-03-29	AAT	Stock	21.41	21.5	21.18	21.27	240800.0
2011-03-29	AATI-DELISTED	Stock	3.7	3.84	3.69	3.79	47659.0
2011-03-29	AAU-DELISTED	Stock	3.96	4.04	3.9	3.9	230088.0
2011-03-29	AAUAF-DELISTED	Stock	3.96	4.04	3.9	3.9	230288.0
2011-03-29	AAV-DELISTED	Stock	8.97	9.07	8.86	8.92	460727.0
2011-03-29	AAWW-DELISTED	Stock	67.98	68.36	67.58	68.22	133061.0
2011-03-29	AAXJ	Stock	61.44	61.91	61.38	61.82	357699.0
2011-03-29	AAXN-DELISTED	Stock	3.95	4.2	3.9	4.12	436913.0
2011-03-29	AB	Stock	21.72	21.79	21.63	21.75	300400.0
2011-03-29	ABAC-DELISTED	Stock	4.2	4.25	3.9	4.05	121755.0
2011-03-29	ABAX-DELISTED	Stock	29.03	29.09	28.51	28.6	100992.0
2011-03-29	ABB-DELISTED	Stock	23.5	23.74	23.4	23.73	1384397.0
2011-03-29	ABBC-DELISTED	Stock	11.65	11.94	11.57	11.77	46949.0
2011-03-29	ABBNY-DELISTED	Stock	23.5	23.74	23.4	23.73	1417424.0
2011-03-29	ABC-DELISTED	Stock	39.3	39.85	39.25	39.74	1670361.0
2011-03-29	ABCB	Stock	10.05	10.15	10.01	10.14	26700.0
2011-03-29	ABCD-DELISTED	Stock	3.32	3.4	3.3	3.4	14039.0
2011-03-29	ABCO-DELISTED	Stock	25.08	25.32	25.02	25.31	101344.0
2011-03-29	ABCW-DELISTED	Stock	1.05	1.05	1.03	1.04	15610.0
2011-03-29	ABD-DELISTED	Stock	9.09	9.17	8.92	9.12	370390.0
2011-03-29	ABE-DELISTED	Stock	18.36	18.54	18.25	18.53	21615.0
2011-03-29	ABEO	Stock	2687.5	2800.0	2625.0	2800.0	30.0
2011-03-29	ABFS-DELISTED	Stock	25.05	25.05	24.6	24.92	212100.0
2011-03-29	ABG	Stock	18.46	18.79	18.14	18.65	271700.0
2011-03-29	ABH-DELISTED	Stock	26.88	27.08	26.81	26.99	191370.0
2011-03-29	ABM	Stock	25.18	25.41	25.04	25.26	145200.0
2011-03-29	ABMD-DELISTED	Stock	14.44	14.95	14.4	14.6	153017.0
2011-03-29	ABR	Stock	5.68	5.69	5.6	5.65	28400.0
2011-03-29	ABT	Stock	23.04	23.2127	22.9824	23.2127	15344102.0
2011-03-29	ABTL-DELISTED	Stock	7.15	7.25	6.75	7.2	77150.0
2011-03-29	ABUS	Stock	3.0	3.08	2.97	3.0	28100.0
2011-03-29	ABV-DELISTED	Stock	26.8	27.3608	26.74	27.2	2677423.0
2011-03-29	ABVT-DELISTED	Stock	63.88	64.8	63.72	64.5	50741.0

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

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