create table stocks_daily
(
exchange char(10) NOT NULL,
symbol char(10) NOT NULL,
date datetime NOT NULL,
o real NOT NULL,
h real NOT NULL,
l real NOT NULL,
c real NOT NULL,
volume int NOT NULL,
adjust real NOT NULL
);

##</code><code>##

    # get the max:
    my $high = $quote_model->search( 
        {
            symbol => $symbol,
            date => { '>=' => $date},
            
        },
          {'select' => [ { max => 'c',  } ], }

            )->single();

    print "high: ", $high->c, "\n";

##</code><code>##

select Max(c) from stocks_daily where symbol = '?' and date >= '?'