PREVIEW / stock_daily / 2014-03-11

all stock daily files

  file:    by_date/stock_daily/2014/2014-03-11.parquet
  size:    218 KB
  rows:    6,477
  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
2014-03-11	AAPL	Stock	19.1232	19.2407	19.0211	19.1461	279224400.0
2014-03-11	MSFT	Stock	37.87	38.23	37.72	38.02	25216400.0
2014-03-11	NVDA	Stock	0.4545	0.4608	0.453	0.4568	297220000.0
2014-03-11	AMZN	Stock	18.5495	18.64	18.364	18.441	44922000.0
2014-03-11	META	Stock	72.5	72.59	69.96	70.1	59408300.0
2014-03-11	TSLA	Stock	15.7667	16.3067	15.4953	15.6273	132151500.0
2014-03-11	TLT	Stock	105.98	106.34	105.7799	106.32	3815873.0
2014-03-11	ES	Stock	43.62	43.62	43.13	43.36	851600.0
2014-03-11	CL	Stock	63.17	63.82	63.06	63.29	3367300.0
2014-03-11	A	Stock	41.6524	41.7024	40.4149	40.6724	4783537.0
2014-03-11	AABA-DELISTED	Stock	38.31	38.31	37.4301	37.57	11973603.0
2014-03-11	AACG	Stock	4.63	4.9	4.4	4.4	48500.0
2014-03-11	AAIC-DELISTED	Stock	27.22	27.25	26.69	26.69	121981.0
2014-03-11	AAL	Stock	38.65	39.26	37.95	38.08	11302500.0
2014-03-11	AAMC-DELISTED	Stock	237.0882	241.1765	230.3853	235.8824	127214.0
2014-03-11	AAME	Stock	3.85	3.9	3.83	3.87	4000.0
2014-03-11	AAOI	Stock	27.67	28.01	26.18	26.32	83500.0
2014-03-11	AAON	Stock	13.5111	13.6444	12.9289	12.9689	288450.0
2014-03-11	AAP	Stock	127.25	128.49	126.48	126.94	1022200.0
2014-03-11	AAT	Stock	32.88	33.07	32.64	32.79	152000.0
2014-03-11	AAU-DELISTED	Stock	1.53	1.54	1.5	1.5	95012.0
2014-03-11	AAUAF-DELISTED	Stock	1.53	1.54	1.5	1.5	99552.0
2014-03-11	AAV-DELISTED	Stock	4.0	4.04	3.95	3.98	153025.0
2014-03-11	AAWW-DELISTED	Stock	32.66	32.74	31.73	32.01	221348.0
2014-03-11	AAXJ	Stock	58.2	58.28	57.44	57.52	465389.0
2014-03-11	AAXN-DELISTED	Stock	19.57	19.58	18.8	18.89	1045859.0
2014-03-11	AB	Stock	23.93	24.07	23.4	23.52	456300.0
2014-03-11	ABAC-DELISTED	Stock	1.964	2.09	1.89	1.92	52200.0
2014-03-11	ABAX-DELISTED	Stock	39.37	39.626	38.66	39.01	88760.0
2014-03-11	ABB-DELISTED	Stock	25.37	25.48	25.09	25.205	1639788.0
2014-03-11	ABBNY-DELISTED	Stock	25.37	25.48	25.09	25.19	1679210.0
2014-03-11	ABBV	Stock	51.68	52.14	51.5	51.75	3629800.0
2014-03-11	ABC-DELISTED	Stock	69.11	69.47	68.171	68.35	1444039.0
2014-03-11	ABCB	Stock	21.52	23.08	21.22	22.96	279600.0
2014-03-11	ABCD-DELISTED	Stock	2.08	2.08	2.0	2.07	25623.0
2014-03-11	ABCO-DELISTED	Stock	68.3	68.69	66.5	66.55	194349.0
2014-03-11	ABE-DELISTED	Stock	12.73	12.73	12.49	12.49	24046.0
2014-03-11	ABEO	Stock	462.5	637.5	462.5	550.0	402.0
2014-03-11	ABEV	Stock	7.15	7.18	6.95	6.99	5155100.0
2014-03-11	ABFS-DELISTED	Stock	37.26	37.3699	36.46	36.67	402284.0
2014-03-11	ABG	Stock	54.9	54.94	53.39	53.48	338700.0
2014-03-11	ABGB-DELISTED	Stock	24.2001	24.36	24.19	24.35	14324.0
2014-03-11	ABIL-DELISTED	Stock	9.62	9.62	9.62	9.62	494.0
2014-03-11	ABM	Stock	28.6	28.61	28.08	28.25	207100.0
2014-03-11	ABMD-DELISTED	Stock	29.65	30.4599	29.5	29.96	239796.0
2014-03-11	ABR	Stock	6.76	6.8	6.65	6.72	95400.0
2014-03-11	ABR.A-DELISTED	Stock	24.44	24.44	24.3887	24.3887	300.0
2014-03-11	ABR.B-DELISTED	Stock	22.9237	23.0	22.9237	23.0	2733.0
2014-03-11	ABR.C-DELISTED	Stock	24.47	24.47	24.4	24.4	18210.0
2014-03-11	ABT	Stock	39.85	40.16	39.65	39.71	5117600.0

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

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