PREVIEW / stock_daily / 2015-03-31

all stock daily files

  file:    by_date/stock_daily/2015/2015-03-31.parquet
  size:    223 KB
  rows:    6,653
  symbols: 3,525

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
2015-03-31	AAPL	Stock	31.5225	31.6225	31.09	31.1075	168362400.0
2015-03-31	MSFT	Stock	40.78	41.03	40.54	40.66	34887200.0
2015-03-31	NVDA	Stock	0.5352	0.5358	0.5228	0.5232	357276000.0
2015-03-31	AMZN	Stock	18.662	18.885	18.5755	18.605	50122000.0
2015-03-31	GOOGL	Stock	27.897	28.1225	27.7335	27.735	34932440.0
2015-03-31	META	Stock	82.9	83.5	82.21	82.22	19734300.0
2015-03-31	TSLA	Stock	12.902	12.9173	12.5607	12.5847	75399000.0
2015-03-31	TLT	Stock	130.24	130.96	129.91	130.69	6844288.0
2015-03-31	ES	Stock	50.7	51.12	50.22	50.52	1192300.0
2015-03-31	CL	Stock	68.86	69.74	68.84	69.34	4180400.0
2015-03-31	A	Stock	41.28	41.78	41.1	41.55	1659200.0
2015-03-31	AA.B-DELISTED	Stock	43.9	44.1999	43.74	43.87	44873.0
2015-03-31	AABA-DELISTED	Stock	44.82	45.2	44.42	44.44	9818649.0
2015-03-31	AAC-DELISTED	Stock	29.79	30.93	29.66	30.58	216793.0
2015-03-31	AACG	Stock	3.95	4.16	3.95	4.1	2900.0
2015-03-31	AAIC-DELISTED	Stock	24.25	24.28	24.01	24.06	239571.0
2015-03-31	AAL	Stock	53.66	53.73	52.68	52.78	8386400.0
2015-03-31	AAMC-DELISTED	Stock	55.5735	55.5882	53.7088	54.45	34394.0
2015-03-31	AAME	Stock	4.05	4.05	4.02	4.03	7400.0
2015-03-31	AAMI	Stock	18.05	19.0	18.05	18.64	523100.0
2015-03-31	AAOI	Stock	13.85	13.99	13.67	13.88	184400.0
2015-03-31	AAON	Stock	16.3333	16.4133	16.0533	16.3533	248550.0
2015-03-31	AAP	Stock	151.8	152.57	149.48	149.69	887500.0
2015-03-31	AAT	Stock	43.66	43.82	43.12	43.28	123600.0
2015-03-31	AAU-DELISTED	Stock	0.9001	0.9615	0.9	0.9	34915.0
2015-03-31	AAUAF-DELISTED	Stock	0.8601	0.9188	0.86	0.9	36744.0
2015-03-31	AAV-DELISTED	Stock	5.21	5.38	5.2	5.37	219951.0
2015-03-31	AAVL-DELISTED	Stock	39.27	41.15	39.0501	40.54	225152.0
2015-03-31	AAWW-DELISTED	Stock	44.39	44.5	42.92	43.02	235487.0
2015-03-31	AAXJ	Stock	63.94	64.12	63.77	64.0	418994.0
2015-03-31	AAXN-DELISTED	Stock	24.9	25.0	24.06	24.115	1120332.0
2015-03-31	AB	Stock	30.71	30.89	30.3	30.87	166600.0
2015-03-31	ABAC-DELISTED	Stock	1.5	1.573	1.5	1.5	9199.0
2015-03-31	ABAX-DELISTED	Stock	66.06	66.52	63.85	64.15	99748.0
2015-03-31	ABB-DELISTED	Stock	21.15	21.27	21.13	21.18	1155217.0
2015-03-31	ABBNY-DELISTED	Stock	21.15	21.27	21.13	21.17	1230528.0
2015-03-31	ABBV	Stock	58.01	58.81	57.71	58.54	12313600.0
2015-03-31	ABC-DELISTED	Stock	113.42	114.27	113.42	113.66	1951640.0
2015-03-31	ABCB	Stock	26.4	26.89	26.01	26.39	656200.0
2015-03-31	ABCD-DELISTED	Stock	3.13	3.4	3.13	3.15	44792.0
2015-03-31	ABCO-DELISTED	Stock	53.07	53.42	52.72	53.24	361930.0
2015-03-31	ABCW-DELISTED	Stock	34.85	34.91	34.5	34.73	6493.0
2015-03-31	ABDC-DELISTED	Stock	13.62	13.93	13.27	13.3	52252.0
2015-03-31	ABE-DELISTED	Stock	12.46	12.59	12.46	12.57	14412.0
2015-03-31	ABEO	Stock	83.25	83.25	73.25	78.5	620.0
2015-03-31	ABEV	Stock	5.78	5.82	5.72	5.76	11536300.0
2015-03-31	ABG	Stock	82.37	83.48	81.86	83.1	580000.0
2015-03-31	ABGB-DELISTED	Stock	18.11	18.21	18.086	18.16	19603.0
2015-03-31	ABIL-DELISTED	Stock	9.96	10.05	9.95	10.05	7000.0
2015-03-31	ABM	Stock	31.87	31.98	31.39	31.86	492200.0

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

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