PREVIEW / stock_daily / 2011-03-01

all stock daily files

  file:    by_date/stock_daily/2011/2011-03-01.parquet
  size:    198 KB
  rows:    6,091
  symbols: 3,553

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-01	AAPL	Stock	12.6954	12.7043	12.4171	12.4754	456136800.0
2011-03-01	MSFT	Stock	26.6	26.78	26.15	26.16	60055000.0
2011-03-01	NVDA	Stock	0.5675	0.5748	0.5412	0.5412	988448000.0
2011-03-01	AMZN	Stock	8.6765	8.698	8.4335	8.472	116942000.0
2011-03-01	TSLA	Stock	1.6033	1.6213	1.58	1.596	16596000.0
2011-03-01	TLT	Stock	91.52	92.4	91.47	92.37	8049413.0
2011-03-01	ES	Stock	34.21	34.35	33.74	33.84	1766700.0
2011-03-01	CL	Stock	39.15	39.46	38.815	38.82	5588600.0
2011-03-01	A	Stock	30.0286	30.3934	29.0773	29.0987	5719777.0
2011-03-01	AABA-DELISTED	Stock	16.49	16.5	16.079	16.11	16088929.0
2011-03-01	AACC-DELISTED	Stock	5.89	5.89	5.65	5.67	10850.0
2011-03-01	AACG	Stock	8.05	8.65	7.77	8.0	252300.0
2011-03-01	AAI-DELISTED	Stock	7.3	7.31	7.27	7.28	2256808.0
2011-03-01	AAIC-DELISTED	Stock	28.07	28.12	26.93	26.98	25274.0
2011-03-01	AAME	Stock	2.04	2.15	2.0	2.0	13000.0
2011-03-01	AAON	Stock	6.0583	6.1472	5.9852	6.0543	798356.0
2011-03-01	AAP	Stock	62.99	63.35	62.22	62.63	1201100.0
2011-03-01	AAT	Stock	21.54	21.69	21.31	21.5	219400.0
2011-03-01	AATI-DELISTED	Stock	4.25	4.3	4.2	4.22	195188.0
2011-03-01	AAU-DELISTED	Stock	4.33	4.39	4.1	4.21	355082.0
2011-03-01	AAUAF-DELISTED	Stock	4.33	4.39	4.1	4.21	356082.0
2011-03-01	AAV-DELISTED	Stock	7.88	7.88	7.65	7.73	245597.0
2011-03-01	AAWW-DELISTED	Stock	68.65	68.76	67.04	67.44	283398.0
2011-03-01	AAXJ	Stock	60.69	60.91	59.94	60.06	441976.0
2011-03-01	AAXN-DELISTED	Stock	3.78	3.8	3.68	3.69	478600.0
2011-03-01	AB	Stock	22.77	22.88	22.42	22.45	380500.0
2011-03-01	ABAC-DELISTED	Stock	4.99	5.0	4.73	4.79	90744.0
2011-03-01	ABAX-DELISTED	Stock	26.55	26.7	25.77	26.27	157492.0
2011-03-01	ABB-DELISTED	Stock	24.55	24.55	24.05	24.13	3826353.0
2011-03-01	ABBC-DELISTED	Stock	12.49	12.57	12.25	12.34	42551.0
2011-03-01	ABBNY-DELISTED	Stock	24.55	24.55	24.05	24.12	4347669.0
2011-03-01	ABC-DELISTED	Stock	37.82	37.99	37.3	37.32	2042911.0
2011-03-01	ABCB	Stock	10.1	10.14	9.92	10.02	42500.0
2011-03-01	ABCD-DELISTED	Stock	3.58	3.61	3.46	3.46	30384.0
2011-03-01	ABCO-DELISTED	Stock	25.59	25.82	24.91	24.97	72558.0
2011-03-01	ABCW-DELISTED	Stock	1.1	1.1	1.0	1.01	216510.0
2011-03-01	ABD-DELISTED	Stock	8.56	8.57	8.197	8.4	323440.0
2011-03-01	ABE-DELISTED	Stock	17.85	17.86	17.6	17.6888	6371.0
2011-03-01	ABEO	Stock	2750.0	2750.0	2500.0	2687.5	29.0
2011-03-01	ABFS-DELISTED	Stock	23.74	23.83	23.15	23.46	212025.0
2011-03-01	ABG	Stock	18.65	18.7	18.1	18.18	341000.0
2011-03-01	ABH-DELISTED	Stock	27.8	27.98	26.78	27.08	439665.0
2011-03-01	ABM	Stock	26.68	26.7	25.66	25.81	214900.0
2011-03-01	ABMD-DELISTED	Stock	12.48	12.71	12.38	12.7	223742.0
2011-03-01	ABR	Stock	7.18	7.33	6.88	6.94	64400.0
2011-03-01	ABT	Stock	23.1216	23.1743	22.7569	22.7905	19163610.0
2011-03-01	ABTL-DELISTED	Stock	5.9	5.9	5.45	5.8	57391.0
2011-03-01	ABUS	Stock	4.95	5.04	4.92	4.92	7100.0
2011-03-01	ABV-DELISTED	Stock	27.18	27.51	27.17	27.46	3042308.0
2011-03-01	ABVA-DELISTED	Stock	4.6101	4.75	4.6101	4.75	3149.0

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

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