PREVIEW / stock_daily / 2011-03-08

all stock daily files

  file:    by_date/stock_daily/2011/2011-03-08.parquet
  size:    197 KB
  rows:    6,071
  symbols: 3,550

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-08	AAPL	Stock	12.6754	12.7643	12.5804	12.7057	356316800.0
2011-03-08	MSFT	Stock	25.77	26.02	25.65	25.91	50549800.0
2011-03-08	NVDA	Stock	0.5173	0.52	0.478	0.4888	1947184000.0
2011-03-08	AMZN	Stock	8.4695	8.4855	8.336	8.3445	84380000.0
2011-03-08	TSLA	Stock	1.64	1.664	1.6	1.644	20998500.0
2011-03-08	TLT	Stock	90.11	90.34	89.65	89.68	8500342.0
2011-03-08	ES	Stock	34.26	34.9	34.14	34.8	1598700.0
2011-03-08	CL	Stock	38.94	39.18	38.775	39.095	5980200.0
2011-03-08	A	Stock	32.9113	33.0544	32.6753	32.8827	5445350.0
2011-03-08	AABA-DELISTED	Stock	16.75	17.02	16.71	16.93	12541969.0
2011-03-08	AACC-DELISTED	Stock	5.65	5.8	5.65	5.77	11883.0
2011-03-08	AACG	Stock	7.51	7.75	7.51	7.74	15800.0
2011-03-08	AAI-DELISTED	Stock	7.3	7.455	7.29	7.43	8148846.0
2011-03-08	AAIC-DELISTED	Stock	25.76	28.54	25.76	28.54	69411.0
2011-03-08	AAME	Stock	2.07	2.09	1.95	2.01	10500.0
2011-03-08	AAON	Stock	5.8963	6.1274	5.8963	6.1235	154912.0
2011-03-08	AAP	Stock	63.08	64.57	62.49	64.08	1251700.0
2011-03-08	AAT	Stock	21.06	21.44	20.96	21.35	214400.0
2011-03-08	AATI-DELISTED	Stock	4.18	4.28	4.07	4.09	100652.0
2011-03-08	AAU-DELISTED	Stock	3.91	3.96	3.8	3.82	407636.0
2011-03-08	AAUAF-DELISTED	Stock	3.91	3.96	3.8	3.82	408636.0
2011-03-08	AAV-DELISTED	Stock	8.67	8.67	8.16	8.26	1182984.0
2011-03-08	AAWW-DELISTED	Stock	66.93	69.12	65.87	68.86	178668.0
2011-03-08	AAXJ	Stock	61.51	62.38	61.37	62.14	384266.0
2011-03-08	AAXN-DELISTED	Stock	3.98	4.1199	3.98	4.085	357399.0
2011-03-08	AB	Stock	23.0	23.22	22.81	22.91	338600.0
2011-03-08	ABAC-DELISTED	Stock	5.21	5.23	5.01	5.2	48436.0
2011-03-08	ABAX-DELISTED	Stock	27.02	28.58	27.02	28.45	185821.0
2011-03-08	ABB-DELISTED	Stock	23.85	23.97	23.71	23.89	2636881.0
2011-03-08	ABBC-DELISTED	Stock	12.26	12.79	12.26	12.64	136708.0
2011-03-08	ABBNY-DELISTED	Stock	23.85	23.97	23.71	23.88	2639400.0
2011-03-08	ABC-DELISTED	Stock	37.28	37.71	37.15	37.57	1283490.0
2011-03-08	ABCB	Stock	9.67	10.0	9.67	10.0	34500.0
2011-03-08	ABCD-DELISTED	Stock	3.41	3.59	3.4	3.59	10473.0
2011-03-08	ABCO-DELISTED	Stock	24.47	25.2	24.47	24.96	211078.0
2011-03-08	ABCW-DELISTED	Stock	1.07	1.07	1.0	1.03	61960.0
2011-03-08	ABD-DELISTED	Stock	8.94	9.3	8.74	9.25	252820.0
2011-03-08	ABE-DELISTED	Stock	17.83	17.9501	17.77	17.93	30084.0
2011-03-08	ABEO	Stock	2562.5	2612.5	2500.0	2550.0	12.0
2011-03-08	ABFS-DELISTED	Stock	23.73	24.6	23.52	24.54	153939.0
2011-03-08	ABG	Stock	19.28	19.59	19.11	19.55	277400.0
2011-03-08	ABH-DELISTED	Stock	28.67	28.79	28.38	28.63	195582.0
2011-03-08	ABM	Stock	26.16	26.29	24.87	25.53	713100.0
2011-03-08	ABMD-DELISTED	Stock	13.2	13.85	12.8	13.84	183555.0
2011-03-08	ABR	Stock	6.25	6.25	6.03	6.17	139000.0
2011-03-08	ABT	Stock	23.2655	23.4334	23.2463	23.3663	11799500.0
2011-03-08	ABTL-DELISTED	Stock	5.85	6.05	5.8	6.05	80414.0
2011-03-08	ABUS	Stock	4.68	4.7	4.67	4.69	8200.0
2011-03-08	ABV-DELISTED	Stock	27.68	28.21	27.45	28.01	1014967.0
2011-03-08	ABVA-DELISTED	Stock	4.95	4.98	4.95	4.98	200.0

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

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